7 Replies Latest reply: Nov 3, 2008 9:26 AM by -==cfSearching==- RSS

    Is there a way to avoid the error and avoiding the need to write seperate queries

    nikos101 Community Member
      Say I have a query that uses a param in the sql :

      <cfqueryparam value="#arguments.forwardValue#" cfsqltype="cf_sql_integer">

      However sometimes the value forwardValue will contain nothing ie nothing entered in the text input.

      This will generate an error from the CF side. Is there a way to avoid the error and avoiding the need to write seperate queries?