Try this:
<CFSET CategoryIDList = Evaluate("Valuelist(GetCategory#url.id#.Category_ID)")>
Craig
> -----Original Message-----
> From: Duane Boudreau [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 14, 2001 10:43 AM
> To: CF-Talk
> Subject: Evaluate/De problem
>
> I have a query that is generate with a dynamic name:
>
> <cfquery name="GetCategory#url.id#">
> ***
> </cfquery>
>
> I'm trying to get the value of the the CategoryID field into a value list.
> I've tried the following but it keeps erroring out:
>
> <CFSET CategoryIDList =
> Valuelist(Evaluate("GetCategory#url.id#.Category_ID"))>
>
> What am I doing wrong?
>
> Duane
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists