cfquery name=GetEnv datasource=database-name dbtype=ODBC
SELECT strVar,strDestination
FROMusers
/cfquery
cfset myString = ListAppend(myString, GetEnv.strVar, ,)
Ade
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: 22 October 2002 17:33
To:
Look into ValueList()...
Collin Tobin
QA Engineer
617 219 2000
[EMAIL PROTECTED]
Macromedia®
What the web can be.(tm)
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: Tuesday, October 22, 2002 12:33 PM
To: CF-Talk
Subject: Read from database and insert into string
Look into the ValueList() function, which takes a query.column and converts
it into a comma-delimited list/string. If you want each list item to be
quoted, than use the QuotedValueList() function. So, your code would look
like:
cfquery name=GetEnv datasource=database-name dbtype=ODBC
-
From: Adrian Lynch [mailto:adrian.l;thoughtbubble.net]
Sent: 22 October 2002 17:37
To: CF-Talk
Subject: RE: Read from database and insert into string
cfquery name=GetEnv datasource=database-name dbtype=ODBC
SELECT strVar,strDestination
FROMusers
/cfquery
cfset
Easy, use the ValueList() function ...
CFSET results=ValueList(GetEnv, strVar)
--- Ben
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: Tuesday, October 22, 2002 12:33 PM
To: CF-Talk
Subject: Read from database and insert into string
Hi,
I need to read from my
Use ValueList()
e.g
cfset myList = ValueList(GetEnv.strVar)
- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 12:33 PM
Subject: Read from database and insert into string
Hi,
I need to read from my database the field
6 matches
Mail list logo