After spending some time on this I've decided to ask help of the list:
I was using the following to update my ODBC database without a hitch:
<CFSET tmpDate = CreateDate(2000, 12, 24)>
<CFSET myDate = CreateODBCDate(tmpDate)>
<CFQUERY datasource="db1" NAME="updatedate">
UPDATE testdate
set aucdate = #myDate#
where dID = 1
</CFQUERY>
But when I switched to OLE DB I get the following error - with or
without the CreateODBCDate statement.
..........................
Error Diagnostic Information
OLEDB Error Code = -524553244
Malformed GUID. in query expression '{d '2000-12-24'}'.
SQL = "UPDATE testdate set aucdate = {d '2000-12-24'} where dID = 1"
Data Source = "GLIST1"
..........................
--
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]
