Hey Kay, If you're using CF 5 go to CFLIB.org and checkout the data manipulation libraries. I used a great UDF called QueryToArrayofStructures the other day....great stuff...their is probably something that does what you want ;-)
HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Kay Smoljak" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 11:13 PM 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists