Ah, to answer my own question, the correct syntax is
CONTAINSTABLE(tbl , column, <cfqueryparam cfsqltype="cf_sql_varchar"
value="#condition#">)
where #condition# is the condition, without the enclosing brackets for
single quotes.
Haikal Saadh wrote:
Hello everyone.
Has anyone managed to successfully use cfqueryparam for a condition
for SQL Server's full text indexing capabilities?
Or would I have to sanitise them manually?
TIA.
--
Haikal Saadh, Applications Programmer
Teaching and Learning Support Services
K405, Queensland University of Technology, Kelvin Grove Campus
[EMAIL PROTECTED], 3864 8633
CRICOS No. 00213J
