This is interesting too. Thanks. I'll have to pocket this idea for later. I see what you are saying though.
What I did is just queried a number of columns that I need in different instances and I am using the recordset in a few different ways. I am only pulling a fairly small amount of data so it should be fine. -----Original Message----- From: t [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:04 AM To: [EMAIL PROTECTED] Subject: Re: Dynamic Variable Set By Recordset ----- 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=#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 ==^================================================================
