MySQL Forums
Forum List  »  Microsoft SQL Server

Having trouble converting VBScript times to MySQL times
Posted by: xtgeminiman
Date: February 06, 2005 12:49PM

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

Options: ReplyQuote


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.