Answered
cfqueryparam not working
Update statement as follows
update data
set words= '#form.words#',
description= '#form.description#',
title= '#form.title#'
where page = '#form.id#'
is translated right by coldfusion to give the insert....
update data
set words= 'x',
description= 'y',
title= 'test'
where page = '3719'
Change the statement to use cfqueryparam as follows
update data
set words= '#form.words#',
description= '#form.description#',
title= <cfqueryparam value="#form.title#" cfsqltype="CF_SQL_VARCHAR" null="Yes">
where page = '#form.id#'
But the same form data produces an error.
update data
set words= 'x',
description= 'y',
title= ?
where page = '3719'
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) =
Any ideas? Coldfusion v7. MS SQL Server 2005
