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
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
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
]] = 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
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
5 matches
Mail list logo