VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Problems and bugs
 TIME error in Tracking & RMA (MySQL)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AftrBrnr
Starting Member

32 Posts

Posted - November 12 2008 :  11:57:56  Show Profile  Reply with Quote
I get this error when trying to add an RMA or respond to Tracking when logged in as a Customer (via 'Account'):


Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Incorrect time value: '11:27:07 AM' for column 'tracktime' at row 1 

/shop/shopcusttracking.asp, line 178 



Thanks in advance for any help you can offer!
AftrBrnr

AftrBrnr
Starting Member

32 Posts

Posted - November 12 2008 :  15:00:12  Show Profile  Reply with Quote
I managed to fix this myself.

I replaced this line:


sql= sql & "," & timedelimit(time()) 


with this one


sql= sql & "," & timedelimit(formatdatetime(time(),vbshorttime)) 


..in the following files:

shopa_rma.asp
shopa_trackingorder.asp
shopcusttracking.asp
shoprma.asp

-AftrBrnr
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000