Apologies to Mr. Suh who did indeed answer the question by stating
'You must use the native DB syntax for dates...' So I am using Excel
which I think is using the Jet driver and looked at my MySql book and
simply wrote the date as the Date data type specified and ignored the
CF tag. ( YYYY-MM-DD) The code below works. (I am noting it here for
other novices like myself.) I believe I set the formatting of the
excel date to General Date though I've not tried to see if it makes a
difference.
<CFSET ye = 2000>
<CFSET mo = 06>
<CFSET da = 01>
<CFQUERY datasource="test1" NAME="datething">
UPDATE testdate
set aucdate = '#ye#-#mo#-#da#'
where dID = 2
</CFQUERY>
Thanks, Randy
--
Signature......
"In the best relationships sex is the booby prize."
"I'm gotten so out of shape sittin' at the computer all day that I
get out of breath when I have to reach for the percent key!"
- Zeitman
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
