I will be out of the office from Monday, October 20, through Wednesday October 24, and will return on Thursday October 25. I will have limited access to email and voicemail.
Please contact Geri Johnson at ext 1-8404 for urgent Global Sales Programs Web related issues. Thanks, Peter Nugent Webmaster Novell Global Sales Programs Phone :(801) 861-8419 Cell: (801) 319-3503 >>> "[EMAIL PROTECTED]" 03/22/02 09:08 >>> 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. > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
