At 04:03 PM 4/21/2001 -0400, you wrote:
>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?
You want the id for the startrow? Cause the startrow is 1. If you want the
id for the startrow,
<cfset startrecord = queryname.id[1]>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
