Depending on your database, you could just build a concatenation in your query:
SELECT 'index.cfm?fuseaction=' + circuit + '.' + fuseaction AS str FROM tblFuses --- Billy Cravens -----Original Message----- From: Rob C [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:01 AM To: [EMAIL PROTECTED] 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=#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 ==^================================================================
