this is a functioning website with ecommerce, there are some small fixes I need done
1) the site is [login to view URL]
2) We are using live ups rates from the ups server [which is working] see [login to view URL] enter some data to see
3) I am trying to integrate the ups shipping upon checkout but am getting an error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CustomerID='.
/ecominclude/[login to view URL], line 146
Optionally, please select your shipping method
Anyway this is what we need done:
1) test the ecommerce portion look for small bugs and fix them, create a customer login then try to order, you can use a dummy credit card#
2) The code is a bit sloppy with duplicate connection scripts variables etc.., so please clean up the asp code
3) lastly get the live ups rates working, as the products in the database have weights in them the ups system will work [you will be given full ftp access to the site and the access database]