macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: Searching on date ranges

Subject: Re: Searching on date ranges
From: "cf_dev2"
Date: Tue, 21 Aug 2007 22:05:41 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
So your booking table contains "available" rooms not "booked" rooms? 

 Validate the form field dates and either pass the values using cfqueryparam or 
using STR_TO_DATE(form.arrivalDate, theDateFormat) . For performance reasons 
its usually better to use a function on a constant value instead of a column, 
when possible.


<Prev in Thread] Current Thread [Next in Thread>