RE: Read from database and insert into string

2002-10-22 Thread Adrian Lynch
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:

RE: Read from database and insert into string

2002-10-22 Thread Collin Tobin
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

RE: Read from database and insert into string

2002-10-22 Thread Mosh Teitelbaum
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

RE: Read from database and insert into string

2002-10-22 Thread Adrian Lynch
- 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

RE: Read from database and insert into string

2002-10-22 Thread Ben Forta
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

Re: Read from database and insert into string

2002-10-22 Thread Tim Painter
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