Yep that's exactly what I did and it worked perfectly. Thanks
-----Original Message-----
From: Anthony Cooper [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:12 AM
To: [EMAIL PROTECTED]
Subject: Re: Dynamic Variable Set By Recordset
Rob,
Could you loop over the query doing a list append?
e.g.
<cfset MyVar = "">
<cfloop query="qData">
<cfset MyVar = ListAppend( MyVar,
"index.cfm?fuseaction=#qData.circuit#.#qData.fuseaction#" )> </cfloop>
Can't think of a way to do it with ValueList().
Ant
----- Original Message -----
From: "Rob C" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 4:01 PM
Subject: Dynamic Variable Set By Recordset
>
> This is kind of confusing so I thought I's throw this out and see if
> anyone can help. So far I have been able to get this to work with one
> column in the db but I need to take this one step further.
>
> I got this to work with one column :
>
> <cfquery name="getLinkNames" datasource="myDS" dbtype="ODBC"> SELECT *
> FROM content;
> </cfquery>
>
> <cfset LinkListLabelsVar = ValueList(getLinkNames.label)>
>
> ----------------------------------------------------------------------
> --
> ---------
>
> I have 2 columns in the db that I need to pull. One is called circuit,
> one is called fuseaction. I need to create a variable which is a
> string comprised of these 2 fields. So the string would be like this :
>
> myVar =
> "index.cfm?fuseaction=#circuit#.#fuseaction#,index.cfm?fuseaction=#cir
> cu
> it#.#fuseaction#,index.cfm?fuseaction=#circuit#.#fuseaction#"
>
>
>
==^================================================================
This email was sent to: [email protected]
EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9
Or send an email to: [EMAIL PROTECTED]
T O P I C A -- Register now to manage your mail!
http://www.topica.com/partner/tag02/register
==^================================================================
