SalesCart Forums : Newbie needs help

Newbie needs help : THANK YOU! THANK YOU! THANK YOU! Follwed...

Wed, 21 Sep 2005 11:57:17 +0000

Author: cibolo
Subject: 426
Posted: September/21/05 at 11:57am

THANK YOU! THANK YOU! THANK YOU!
Follwed those instructions and it worked perfectly.

Newbie needs help : Try this article for the ISAM...

Wed, 21 Sep 2005 11:48:26 +0000

Author: Techno Geek
Subject: 426
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

Newbie needs help : Thank you, you were correct, I...

Wed, 21 Sep 2005 10:00:39 +0000

Author: cibolo
Subject: 426
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)
%>

I undelined line 138

Thank you again.

Newbie needs help : Type mismatch usually means that...

Wed, 21 Sep 2005 08:51:15 +0000

Author: Techno Geek
Subject: 426
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.

Newbie needs help : Thank you in advance for any and...

Wed, 21 Sep 2005 07:33:13 +0000

Author: cibolo
Subject: 426
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.