Newbie needs help
Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=426
Printed Date: November/24/24 at 6:34am
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com
Topic: Newbie needs help
Posted By: cibolo
Subject: Newbie needs help
Date Posted: September/21/05 at 7:33am
|
Thank you in advance for any and all help. I am new to salescart, and databases. I am working on a site that someone else built and is no longer around to help or answer questions. When I click the add to cart button the page comes up as
Microsoft VBScript runtime error '800a000d' Type mismatch: 'weight' /cgi-bin/shop1.asp line 17 Below is the code from the page itself lines 8 thru 17 Quantity = Abs(Request("Quantity")) part = SQLEncode(Request("part")) price = SQLEncode(Request("price")) description = SQLEncode(Request("description")) units = SQLEncode(Request("units")) size = SQLEncode(Request("size")) weight = SQLEncode(Request("weight")) taxed = SQLEncode(Request("taxed")) upsell = SQLEncode(Request("upsell")) weight = Quantity * weight Also this site was built with older software versions than what I have. I am not sure what version of FP or SalesCart where used. It was last updated on 5/20/02. I am using FP 2003 and the new Salescart Pro. Thanks again. |
Replies:
Posted By: Techno Geek
Date Posted: September/21/05 at 8:51am
|
Type mismatch usually means that you're putting in something other than what the database is expecting to see.
For example, the weight field in the database is set to number only so if you enter anything but a number in the field you will get this error message. I'm not sure about the recordsets above but it doesn't look the same to me. ------------- Techno Geek Customer Support Engineer ComCity and SalesCart Technical Support |
Posted By: cibolo
Date Posted: September/21/05 at 10:00am
|
Thank you, you were correct, I had text in the database and it was looking for a number.
Fixed that and now I am getting this error Microsoft JET Database Engine error '80004005' Could not find installable ISAM. /cgi-bin/shop1.asp, line 138 Below is the code for lines 120 thru 150 on the page For x=1 to 3 If chkQuantity > volarray(x) Then &n bsp; adjustprice = (price * (disarray(x)/100)) showdiscount = disarray(x) End If If adjustprice <> 0 Then price = price - adjustprice price = Round(price,2) &nbs p; 'round to two decimal places adjustprice = 0 End If Next End If Set Connection = Server.CreateObject("ADODB.Connection") Connection.Open Session("ConnectionString") SQLStmt = "INSERT INTO item " SQLStmt = SQLStmt & "([Orderid], Discount, Quantity, Item, Price, Description, Units, [Size], Weight, Taxed, Upsell) " SQLStmt = SQLStmt & "VALUES (" & Order & ", " & showdiscount & ", " & Quantity & ", '" & part & "', '" & price & "', " SQLStmt = SQLStmt & "'" & description & "', '" & units & "', '" & size & "', '" & weight & "', '" & taxed & "', '" & upsell & "'); " Set RS = Connection.Execute(SQLStmt) %> <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 3.0//EN" "html.dtd"> <html> <head> I undelined line 138 Thank you again. |
Posted By: Techno Geek
Date Posted: September/21/05 at 11:48am
|
Try this article for the ISAM error message: http://support.salescart.com/kb/KB-details.asp?key=5393 - http://support.salescart.com/kb/KB-details.asp?key=5393 ------------- Techno Geek Customer Support Engineer ComCity and SalesCart Technical Support |
Posted By: cibolo
Date Posted: September/21/05 at 11:57am
 THANK YOU! THANK YOU! THANK YOU!
Follwed those instructions and it worked perfectly. |