Yes, one way is by hand:

<cfset s = structNew()>
<cfset s.name = query.name[x]> where x is the row you want
<cfset s.foo = query.foo[x]> where x is the row you want

You can also use the UDF QueryRowToStruct:

http://www.cflib.org/udf.cfm?ID=358

=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email    : [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -----Original Message-----
> From: Brent Goldman [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, January 16, 2002 9:44 PM
> To: CF-Talk
> Subject: copying individual query rows
> 
> 
> Hi,
> 
> Is it possible to copy an individual query row to a 
> structure, and basically
> you can use structure[column] to get each of the row's 
> columns from this
> structure?  If it is possible, how can I do it?
> 
> Thanks
> -Brent
> 
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation � $99/Month � Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to