That was perfect! Thank you!
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
-----Original Message-----
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 21, 2001 4:17 PM
To: CF-Community
Subject: RE: Quick Question....
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
