• 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: rawRowsForSQL key to uppercase, a bug?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: rawRowsForSQL key to uppercase, a bug?


  • Subject: Re: rawRowsForSQL key to uppercase, a bug?
  • From: David LeBer <email@hidden>
  • Date: Tue, 2 Nov 2004 08:27:22 -0500


On Nov 2, 2004, at 1:58 AM, Lon Baker wrote:

Shaun,

Thanks. I am talking about the keys of the NSDictionaries returned in the arrry from rawRowsFromSQL. All the key are converted to UPPERCASE.

String sql = "SELECT DISTINCT c.r_chunk_pk, MATCH blah blah blah;

		NSArray keys = new NSArray(new String[] {"chunkPK", "rel"});

		NSArray array = EOUtilities.rawRowsForSQL(ec,"table_name", sql, keys);

I use the full text search in site search for <http://www.oetker.ca>. EOUtilities.rawRowsForSQL takes an array of the key names in the order you expect them and (if provided) substitutes them in the dictionaries.

I just fetch the pk's and and a ranking value for sorting and fault the objects as needed.

;david

--
David LeBer
Codebase Software Systems
site:   http://www.codebase.ca
blog: http://david.codebase.ca

Attachment: smime.p7s
Description: S/MIME cryptographic signature

 _______________________________________________
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:
    • [SOLVED] rawRowsForSQL key to uppercase, a bug?
      • From: Lon Baker <email@hidden>
    • [SOLVED] rawRowsForSQL key to uppercase, a bug?
      • From: Lon Baker <email@hidden>
References: 
 >rawRowsForSQL key to uppercase, a bug? (From: Lon Baker <email@hidden>)
 >Re: rawRowsForSQL key to uppercase, a bug? (From: Lon Baker <email@hidden>)

  • Prev by Date: Re: AW: CSS with WOComponent
  • Next by Date: WebObjects Update?
  • Previous by thread: Re: rawRowsForSQL key to uppercase, a bug?
  • Next by thread: [SOLVED] rawRowsForSQL key to uppercase, a bug?
  • Index(es):
    • Date
    • Thread