I have bought an off the shelft ASP/VBscript shopping cart from? <[login to view URL]>?
It runs with Acess, but I kept getting "system resource exceed errrors" etc..etc..
So I converted to MySQL
But I am getting some execution error thought-out the site.
I just need all these bugs fixed.
A sample error one below is....
####################
error message
####################
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM ProductColours WHERE ProductID=43' at line 1
/charoncart/adminsection/[login to view URL], line 160
####################
Code
####################
<%
Set MM_Cmd = [login to view URL]("[login to view URL]")
[login to view URL] = MM_CharonCart_STRING
? [login to view URL] = "DELETE * FROM ProductColours WHERE ProductID=" & Request("ProductID")
? [login to view URL]
myarray=split(request("ColourID"),",")
for i=0 to ubound(myarray)
? [login to view URL] = "INSERT INTO ProductColours (ProductID,ColourID) VALUES (" & Request("ProductID") & "," & myarray(i) & ")"
? [login to view URL]
next
%>