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 ______________________________________________________________________ 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 Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
