> "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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
