It depends on what you want the structure to look like. The query structure is ideally suited to manipulating the data as it's returned from the tables. But structures can be any number of things. I tend to use them to create hierarchies. Give us some more information about what you're trying to do, and we'll be able to help you.
Sharon ----- Original Message ----- From: "Kay Smoljak" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 12, 2002 2:13 AM Subject: Recordset to structure? > Hi all, > > I'm wondering what the simplest way would be to convert a query > recordset to a structure. I know that a recordset *is* a structure, but > I would like to copy it to the session scope and add, edit and remove > keys as it goes through various scripts. I can't find anything on the > developer's exchange. > > The two options I can see are looping over each record and copying it to > a struct, or using Query functions to manipulate the recordset itself. I > haven't worked with the query functions very much - are there any > limitations to either of these approaches? How about performance? > > Any pointers would be greatly appreciated. > > Kay. > ______________________________________________________ > Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd > > Level 9/105 St George's Terrace - Perth - Western Australia > Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au > > http://developer.perthweb.com.au - Tools for Developers > cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
