I stand corrected :) ============================================ Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ============================================
-----Original Message----- From: S. Isaac Dealey [mailto:info@;turnkey.to] Sent: Tuesday, October 29, 2002 1:23 PM To: CF-Talk Subject: RE: Reading database and inserting fields into another database > "naming the queries the same is liable to cause > problems... I'd also > recommend using <cfqueryparam cfsqltype="cf_sql_varchar" > value="#ValueList(GetAlias.env_var)#"> -- use > cf_sql_longvarchar if the > values of the files may be more than about 8000 > characters." > True except for valuelist(), query returns comma delimited > anyway, why the extra function? Because if you just use #GetAlias.env_var# you'll only return one row ( the first if you're not inside a cfloop or cfoutput of the query ) of the query and not a comma delimited list of the values in that column. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
