0 Replies Latest reply on Jun 2, 2006 1:02 AM by sfbell

    problem with queryparams

      Recently upgraded to Coldfusion 7 using JDBC drivers (V 3.5) with Oracle 8i. Since then we have been getting problems with some queryparams in <cfquery> SQL statement...., eg,
      <cfqueryparam value="#ValueList(get_service.ct_service_id)#" list="yes">. This returns the following error:
      Error executing Databse query. [Macromedia][Oracle JDBC] Internal error: Net8 protocol error.

      <cfqueryPARAM value="#arguments.request_id#" cfsqltype="cf_sql_integer" maxlength="10"> This returns the following error:
      For input string: ":099960" null.

      Can anyone help?