----- Original Message -----
From: Rob C <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 5:01 PM
Subject: Dynamic Variable Set By Recordset
Hi Rob,
Don't pull them out as two fields - just concatenate ("index.cfm?fuseaction=" +
circuitcolumnvalue + "." + fuseactioncolumnvalue) in your query, then ValueList
and off you go!
/t
>
> 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=#circu
> 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
==^================================================================
