How to compare dates in SQL Server

by

There are a couple of issues going on here. Any form field that ends in _date is a form validation criteria. So the form field needs to be renamed todate and fromdate. Next it is good that you are trying to sanitize the input. cfqueryparam is used to do that. Last but not least, between is cleaner SQL Your query should look a little like:

<cfif isDate(form.fromDate) AND isDate(form.toDate)>

    <cfquery name="qryUser_Activation_Events">
    SELECT * 
    FROM   user_activation_events
    WHERE  STATUS_CODE =1
    AND    event_date BETWEEN <cfqueryparam cfsqltype="CF_SQL_date" value="#form.fromDate#">
        AND DATEADD(d, 1, <cfqueryparam cfsqltype="CF_SQL_date" value="#form.toDate#">)
    ORDER BY ...
    </cfquery>

<cfelse>  
    <!--- Error handling goes here --->
</cfif>

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. SQL update query using joins
  3. How to update two tables in one statement in SQL Server 2005?
  4. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  5. SQL query to select dates between two dates
  6. Convert Month Number to Month Name Function in SQL
  7. How to avoid the “divide by zero” error in SQL?
  8. Create a date from day month and year with T-SQL
  9. Selecting COUNT(*) with DISTINCT
  10. Querying data by joining two tables in two database on different servers
  11. Are there any disadvantages to always using nvarchar(MAX)?
  12. Real life example, when to use OUTER / CROSS APPLY in SQL
  13. Better techniques for trimming leading zeros in SQL Server?
  14. SQL – Subtracting a depleting value from rows
  15. Turn off constraints temporarily (MS SQL)
  16. Get the week start date and week end date from week number
  17. Pass table as parameter into sql server UDF
  18. conditional unique constraint
  19. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  20. SELECT FOR UPDATE with SQL Server
  21. Performance of SQL Server 2005 Query
  22. OPENXML with xmlns:dt
  23. How to select date without time in SQL
  24. How to find sum of multiple columns in a table in SQL Server 2005?
  25. Is it possible to execute a text file from SQL query?
  26. Query times out from web app but runs fine from management studio
  27. Add a row number to result set of a SQL query
  28. Is there a quick way to check if ANY column is NULL?
  29. Why do SQL Server Scalar-valued functions get slower?
  30. SQL query for parent-child chain

Leave a Comment