Re: Recordset to structure?
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 daygreat 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
Re: Recordset to structure?
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Recordset to structure?
> 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? If you already have the data in a query type variable, I would just leave it there and manipulate it directly if possible. Using the query functions is not that hard to learn, though adding a row can be cumbersome. If you're using CF5 you can also use QofQ to easily extract data from your modified query data. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ 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
RE: Recordset to structure?
There are 3 UDFs on cflib (http://www.cflib.org/library.cfm?ID=5) in the datamanipulation lib under query -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: vrijdag 12 april 2002 8:14 To: CF-Talk 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
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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
