I'm using CF Colin Robinson Senior Analyst Programmer
mailto:[EMAIL PROTECTED] http://www.in-tuition.co.uk -----Original Message----- From: charlie arehart [mailto:[EMAIL PROTECTED]] Sent: 15 January 2002 21:12 To: SQL Subject: RE: time truncation It seems you could address this either in the database or in the app server before passing the formfield value into the query. Which app server are you using? CF? ASP? JSP? PHP? Perl? ... /charlie -----Original Message----- From: Colin Robinson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 6:21 AM To: SQL Subject: time truncation I am querying a table for a column of datetime writing it to a formfield and on a form submission requerying the same data to see if the value in the formfield matches. When I do this query they never match because the millisecond part of the datetime value in the formfield seems to have been removed. Is there a way to stop this ? Colin Robinson Senior Analyst Programmer mailto:[EMAIL PROTECTED] http://www.in-tuition.co.uk ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
