RE: Query to Structure with keys...

2002-12-11 Thread Ian Skinner
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

RE: Query to Structure with keys...

2002-12-11 Thread Matthew Friedman
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

RE: Query to Structure with keys...

2002-12-11 Thread Che Vilnonis
Code examples would be great!!! -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 3:24 PM To: CF-Talk Subject: RE: Query to Structure with keys... you could use the valuelist(query.colname) function to do this with out the loop

RE: Query to Structure with keys...

2002-12-11 Thread Matthew Friedman
]] = duplicate(thisRow); } return(theStructure); } /cfscript -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 3:20 PM To: CF-Talk Subject: RE: Query to Structure with keys... Code examples would be great!!! -Original Message

RE: Query to Structure with keys...

2002-12-11 Thread Che Vilnonis
Thanks...you gotta love CFLIB.org! I can't believe I forgot about that resource. -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 3:37 PM To: CF-Talk Subject: RE: Query to Structure with keys... If you are looking at moving