> -----Original Message----- > From: Ramin Surya [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 22, 2002 10:09 AM > To: CF-Talk > Subject: RE: CF Fails to recognize date on manual query setting > > > Adam, > > Thanks for responding. > > It is not a rdbms, it is oodbms.
Ahhh, one of those things :P > > We did all the formatting thing and still couldn't get CF to > recognize that it is a date. That seems odd to me. You've even tried the createDate() function? You might also try using createDate AFTER the query of queries, CF should be guaranteed to recognize it then. I don't know if constraints on your date field would work though. Post an example of what you're stuffing into your query object. > > 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. > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
