you could use the valuelist(query.colname) function to do this with out the loop
-----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 3:13 PM To: CF-Talk Subject: RE: Query to Structure with keys... First of all, if you want to use the Product ID's you need to return them with the Select Clause. Just using a field in the where clause does not return them. <cfquery name="getProductDetails" datasource="XXX"> SELECT Product_ID, PartNumber, ProductTitle FROM Products P WHERE Product_ID IN (9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631) </cfquery> Then what I've done in the past is just loop over the query and create a structure. I'd love to know if there are any more direct ways to do this. <cfscript> productStruct = newStruct(); for (i=1;i<=getProductDetails.recordcount;i=i+1) { tempArray = newArray(1); tempArray[1] = getProductDetails.PartNumber; tempArray[2] = getProductDetails.ProductTitle; productStruc[getProductDetails.Product_ID][i] = tempArray; } </cfscript> Then you should be able to play with your new structure something like this. <cfoutput> <td>PartNumber</td><td>ProductTitle</td> <td>#productStruct['9911'][1]#</td><td>#productStruct['9911'][2]#</td> </cfoutput> Please pardon in problem with my <cfscript> code. I just wrote that off the top of my head, and I don't use <cfscript> all that often. I hope this helps. Ian Skinner -----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 11:13 AM To: CF-Talk Subject: Query to Structure with keys... Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart. I have this query... <cfquery name="getProductDetails" datasource="XXX"> SELECT PartNumber, ProductTitle FROM Products P WHERE Product_ID IN (9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631) </cfquery> I would to place this query into a structure. The keys need to come from the Product_IDs in the where clause of the query. Each key has as its value, the column names that are returned. Any ideas on how to do this??? <cfscript> based code samples would be appreciated. Ché Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com