Ramin Surya wrote: > Long story short, > > We are retrieving wddx data out of the database, deserialize it and stuffing it into >a query using QueryNew() function. One of the field that we are setting happens to >be of a date. > > Then, we query the manual query that we just created and trying to filter some data >based on the date.
Put the data in ISO 8601 format and query it as a string. Jochem P.S. Rightpadding a date with zero's to get a full size string is usually faster as performing a partial comparison on each row. WHERE datefield BETWEEN '2002-03-21 00:00:00' AND '2002-03-22 00:00:00' vs. WHERE Left(datefield, 10) BETWEEN '2002-03-21' AND '2002-03-22' P.P.S. I don't even know if functions inside QoQ is supported :? ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
