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
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
