3 Replies Latest reply on Dec 12, 2015 8:10 PM by Carl Von Stetten

    The data types time and datetime are incompatible in the equal to operator?

    pirlo89

      I have my simple cfquery that should delete records base on the date, start time and end time that have been passed with the arguments. My cfquery looks like this:

       

      <cfquery name="qryDelete" datasource="test">
        
      Delete From Table
        
      Where DateS = <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.DateSch#">
        
      and Start = <cfqueryparam cfsqltype="cf_sql_time" value="#arguments.Stime#">
        
      and End = <cfqueryparam cfsqltype="cf_sql_time" value="#arguments.Etime#">
      </cfquery>


      I tried to output my argument values, they look like this:

      DateSch
      12/10/2015
      Etime 
      08:25 AM
      Stime 
      08:00 AM


      For some reason after I tried to delete records I got an error that looks like this:

      "The data types time and datetime are incompatible in the equal to operator"


      I'm wondering why my date and times can not be compared with values in database. Should I convert or format my argument values differently before I pass them in my cfquery for deletion?

      If anyone knows how this can be fixed please let me know. Thanks in advance.