SELECT circuit + '.' + fuseaction AS label FROM content
Matthew P. Smith Web Developer, Object Oriented -----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=#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 ==^================================================================
