Displaying Date value using ASP
Dear all,
I am currently trying to display the value in an Oracle date
field using ASP. However, I encountered the following error :
Microsoft OLE DB Provider for ODBC Drivers error '80020009'
Multiple-step OLE DB operation generated errors. Check each OLE
DB status value, if available. No work was done.
?
My code is as follow:
set abc= server.createobject("adodb.recordset")
abc.activeconnection = gDBConnectString
sqlstring = "select c_datetime from counter_tbl where c_variable
= 'counter1'"
abc.open sqlstring
response.write abc("c_datetime")
I have tried using to_Date to format the field but when I try to
display it, there will be the same errors again. The SQL
statement executes successfully in SQLPLUS.
Please help. Thanks!
Regards,
Dara.