Having trouble converting VBScript times to MySQL times
I really need to get the current time, not only for this user function but for message boards and other things as well. Can someone please help me out? This error doesn't make sense.
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/consoletopmainie.asp, line 39
Line 39 is the rsuser("lol")=now()
I've heard I need to convert the now() to YYYY-MM-DD HH:MM:SS.MMMMMM, which is the MySQL standard. How do I do that?
sql = "SELECT * FROM Users WHERE username = '" & username & "'"
Set rsUser = Server.CreateObject("ADODB.Recordset")
rsUser.Open sql, conn, 3, 3
rsuser("lol")=now()
rsuser.update
Subject
Written By
Posted
Having trouble converting VBScript times to MySQL times
February 06, 2005 12:49PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.