• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: SQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQL


  • Subject: Re: SQL
  • From: Ron X <email@hidden>
  • Date: Tue, 17 Apr 2012 10:22:17 +0300

        NSArray<String> keys = new NSArray<String>(new String[]{"chart_count", "chart_size_sum"});
        NSArray<NSDictionary> result = EOUtilities.rawRowsForSQL(editingContext,
                "legalsounds",
                "SELECT count(*), sum(songFileSize) FROM `Song`", keys);

works fine

17 апреля 2012 г. 10:20 пользователь Ron X <email@hidden> написал:
Error!
The method rawRowsForSQL(EOEditingContext, String, String, NSArray) in the type EOUtilities is not applicable for the arguments (EOEditingContext, String, String, String[])

13 апреля 2012 г. 21:47 пользователь Larry Mills-Gahl <email@hidden> написал:



On Apr 13, 2012, at 7:07 AM, Ron X wrote:

thank you very much! very good!
this method considered deprecated - is there non-deprecated method?

EOUtilities.rawRowsForSQL(EOEditingContext ec, String modelName, String sqlString, NSArray keys) 


rawRowsForSQL

public static NSArray rawRowsForSQL(EOEditingContext ec,
                                    String modelName,
                                    String sqlString,
                                    NSArray keys)
Evaluates the specified SQL and returns the resulting raw rows.


Parameters:
ec - an EOEditingContext
modelName - name of the EOModel to use
sqlString - the query string in SQL syntax
keys - array of Strings corresponding to the SELECT list; these will be used as the keys in the result dictionaries; use null for default naming
Returns:
matching raw rows (an NSArray of NSDictionaries)
Since:
5.2.2



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: SQL
      • From: Johann Werner <email@hidden>
References: 
 >SQL (From: Ron X <email@hidden>)
 >Re: SQL (From: David LeBer <email@hidden>)
 >Re: SQL (From: Ron X <email@hidden>)
 >Re: SQL (From: Ramsey Gurley <email@hidden>)
 >Re: SQL (From: Ron X <email@hidden>)
 >Re: SQL (From: John Huss <email@hidden>)
 >Re: SQL (From: Ron X <email@hidden>)
 >Re: SQL (From: Henrique Gomes <email@hidden>)
 >Re: SQL (From: Ron X <email@hidden>)
 >Re: SQL (From: Larry Mills-Gahl <email@hidden>)
 >Re: SQL (From: Ron X <email@hidden>)

  • Prev by Date: Re: SQL
  • Next by Date: Re: SQL
  • Previous by thread: Re: SQL
  • Next by thread: Re: SQL
  • Index(es):
    • Date
    • Thread