Great. Somebody beats me to the answer while I'm cooking.
As if I don't feel stupid enough heating eggos in the oven. Leggo my
blueberry eggos!
At 04:16 PM 4/21/2001 -0400, you wrote:
>Try
>
>query_name.fieldname[1]
>
>i.e.
>
>for a query called qryTest, with a field called RecordID
>
><CFSET StartRecord=qryTest.RecordID[1]>
>
>
>
>-----Original Message-----
>From: Erika L Walker [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, April 21, 2001 4:03 PM
>To: CF-Community
>Subject: Quick Question....
>
>
>Help....
>
>Brain Rot....
>
>Got a query....gets all names beginning with B's from a table...
>
>The record ID could be 43 for all I care or know.
>The record count the query returns is like 145....fine.
>
>How do I get the very first record returned by the query....I want that
>first reference number to be exact.
>
>I need to set it to a variable....
>
><cfset StartRecord = ?????>
>
>queryname.startrow? but that's not the record number..... am I seeing this
>right?
>
>Erika
>
>"Friendship is never an accident. It is always the result of high
>intentions, sincere effort, intelligent direction and skillful execution. It
>represents the wise choice of many alternatives." - unknown
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
