Skip to main content
Participant
December 28, 2006
Question

problem with <cfqueryparam list

  • December 28, 2006
  • 1 reply
  • 206 views
Hi guys can any one tells me what wrong here I have list and I want to updated the error I get is ( Syntax error (comma) in query expression 'bizname=?,?'. ) it is list from form and it is , delemeted, so whats wrong here check the code, any suggestion greatly approciated.,,, Update biz SET validclient = 1 where bizname= (param 1) , (param 2),,,,
This topic has been closed for replies.

1 reply

Inspiring
December 28, 2006
> where bizname=<cfqueryparam
> cfsqltype="cf_sql_varchar" list="yes" separator="-" value="#mylist#">

You can't go = someList, you have use IN (someList)

--
Adam