Solved this. There seems to be only one way to make this work that I have
found. You need to do something like this:
select id
from GetAllPubs <-- your cached query
where Title like <cfqueryparam value="%#arguments.searchTerms#%"
cfsqltype="CF_SQL_VARCHAR">
Obviously, change the cfsqltype to suit your needs. The tricky (and
undocumented??) part involves having to pass the value in within the percent
signs (to match the
expression anywhere in the field). If you put the percents outside of the
cfqueryparam tag or enclose the tag in single quotes (both of which I did) it
will fail with a more or less useless error of either "null pointers" or "query
param out of range".
Hope this helps someone.
ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:14:3889
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.14
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
