> Hi,
>
> i am running the following query on query:
>
> <cfquery name="newQuery" dbtype="query">
> select * from query
> <cfloop index="fl2" from="1" to="#arraylen(queryListArray)#">
> <cfif fl2 eq 1>
> where #columnName# like '%,#queryListArray[fl2]#,%'
> <cfelse>
> or #columnName# like '%,#queryListArray[fl2]#,%'
> </cfif>
> </cfloop>
> </cfquery>
Take those commas outa there. ??
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307872
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
