Re: coldfusion query problem

Instead of cast('#form.test#' as int(4)) I'd try #val(form.test)# and a cfqueryparam would probably help the situation as well Original Message --- I have a input box wher I am getting the value for my where clause. INstead I am getting the error Error

Re: coldfusion query problem

why do you need to use cast? can't you just use cfqueryparam cfsqltype=cf_sql_integer value=#form.test#? -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~| Check out the new features and enhancements in the latest

RE: coldfusion query problem

Instead of cast('#form.test#' as int(4)) I'd try #val(form.test)# and a cfqueryparam would probably help the situation as well Original Message --- I have a input box wher I am getting the value for my where clause. INstead I am getting the error Error converting the