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
==^================================================================
