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:244719
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
