RE: Query to Structure with keys...

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 mov

RE: Query to Structure with keys...

ryKey][row]] = duplicate(thisRow); } return(theStructure); } -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- Fro

RE: Query to Structure with keys...

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

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

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. SELECT Product_ID, PartNumber, ProductTitle FROM Products P WHEREProduct_ID