Hi -
Here's a query that is run against a Microsoft Access database. It has been
working fine for a few years now, but has suddenly broke. Starting this
month, Access is recording the DATE_SUBMITTED as a time value, usually
around 12:00 AM, instead of a date. The last recorded correct date is
1/8/2002.
Anyone know what would cause this?
<cfquery name="ClassSubmit" datasource="facultygrade">
update courses
set WEB_STATUS=2,DATE_SUBMITTED=#dateformat(now(),"MM/DD/YYYY")#
Where CRN='#attributes.crn#' and
(INSTRUCTOR_ID_1='#User#' or INSTRUCTOR_ID_2='#User#' or
INSTRUCTOR_ID_3='#User#')
</cfquery>
Thanks,
Brian
______________________________________________________________________
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
