This may be an incompatibility b/t FC and Oracle. I know that when I use <cfqueryparam type="date" /> in MS SQL2k, exactly this behavior is seen. To get the time portion to save, I had to change it to <cfqueryparam type="timestamp" />.
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jake Churchill Sent: Monday, August 06, 2007 11:36 AM To: [email protected] Subject: [farcry-dev] FC 3.0.2 Oracle Date I have been banging my head against the wall for 2 hours now and have gotten no where. I'd appreciate it if anyone out there has any suggestions for me. I am running FC 3.0.2 with an Oracle 10g backend on a Linux server. I have no choice in these so upgrading is not an option. The issue is that the time portion of the startdate, enddate, datetimelastupdated, etc. gets lost. These fields are all DATE data types in Oracle and from what I've read they should be storing the date as well. I've tried everything I can think of from changing to a TIMESTAMP (this breaks gregorianCalendar.cfc) to running an ALTER SESSION script that I found and it doesn't work. The site I am working on will be running at a minimum 6 calendars so I definitely need the time to be stored as well. Is there anything I can do? Please, please help.and thank you in advance! _____ Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~--- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 4:16 PM
smime.p7s
Description: S/MIME cryptographic signature
