Adam, Thanks for responding.
It is not a rdbms, it is oodbms. We did all the formatting thing and still couldn't get CF to recognize that it is a date. The mystery lives on... -----Original Message----- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 9:50 AM To: CF-Talk Subject: RE: CF Fails to recognize date on manual query setting > 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. This doesn't apply to your question, but why would you store hierarchical files in a rdbms, just to pull them out and convert them to a query object? Is it just Friday morning, or does that seem backwards? > 1. CF DOES recognize that it is a date when it is being > pulled fresh from the wddx data. > 2. However CF does not recognize it as a date after we stuff > it into a query and retrieve it by using query of queries. Can you post an example of one of the dates being returned in your query of queries? Try using one of the date functions on whatever you're stuffing into the query object. Play with different formats until isDate(query.datefield) returns true in your query of queries. Adam. > > Thanks in advance and any insight is greatly appreciated. > ______________________________________________________________________ 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
