Thanks, that did the trick.
I used this and it worked:
<cfloop query="qGetLinks">
<cfset myVar = ListAppend(myVar,
"index.cfm?fuseaction=#circuit#.#fuseaction#")>
</cfloop>
<cfoutput>#myVar#</cfoutput>
-----Original Message-----
From: John Farrar [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Dynamic Variable Set By Recordset
Try a cfloop and spin through each record. Before the loop make sure the
varialbe is set to "" to prevent errors. Inside the loop set the
variable like this inside your loop (watch using large loops inside
script).... <cfset result =
ListAppend(variable,"index.cfm?fuseaction=#circuit#.#fuseaction#")>
John Farrar
>>> [EMAIL PROTECTED] 04/05/02 10:01AM >>>
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
==^================================================================
