Have you tried passing a string value of the date? MySQL accepts dates in YYYY-MM-DD format instead of Microsoft's standard value... maybe it'll work if you concatanate the values manually? It's a wild guess : )
At 01:24 AM 12/30/2002 +0800, Chien, Shih Chiang wrote:
tks, Michael I am not sure it's mysql's problem or myODBC351's problem....But, what I am sure is rs2("data").Value = Now is working fine in mysql323 + myodbc351 but, err in mysql407 + myodbc351 the err msg in msgbox: Query-based update failed because the row to update could not be found.
-- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php