You can specify the delimiter in ValueList, and it needn't be a single character eg <cfquery name=foo> SELECT circuit + '.' + fuseaction AS string FROM table </cfquery>
<links = ValueList(foo.string, ",index.cfm?fuseaction=")> now you'd need to add the index.cfm at the start too: <links = ",index.cfm?fuseaction=" & links> But if you're building a string in the query you might as well add the whole lot there, unless you're worried about network trafic, but you probably need a fair few fuseactions before that became an issue.. <SNIP> > > 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?fuseact > ion=#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 ==^================================================================
