listQualify() and preserveSingleQuotes()
<cfqueryparam> for good measure :)
On 6/24/06, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> In access, I run a query to get a valueList() from a text field. I use that
> list to populate a 2nd query like this
>
> .....
> WHERE thefield IN ('#thelist#')
>
> This returns nothing because it's formatted like this:
>
> IN ('ITN,CIS,CSC')
>
> Then I tried setting a blank list, looped over the valuelist items, added
> some single quotes, then listappend()'d them to the list.
>
> it threw an error... the generated SQL looked like this:
> IN ("ITN","CIS","CSC")
>
> Even tho dumping the list revealed no quotes... just singles.
>
> I ended up setting some list funtioned variables, looping over, adding
> commas... was incredibly silly but it worked.
>
> What am I missing?
>
> Thanks,
> Will
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244720
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
