Search results for query: *

Hi Andy! Believe it or not, the shopping cart is now up and running! I entered the queries like this: Create Procedure qryOrderInfo as SELECT o.orderID, o.*, p.ccode, p.cname, p.cprice, oi.numitems, c.* FROM customers c INNER JOIN orders o ON c.custID = o.ocustomerid INNER JOIN oitems oi ON...

OMG, I just found a typo in my script. The call openConn() was missing!! So now I get the error msg: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. /eksamen/process.asp, linje 70 So there's got to be something wrong about the...

Does anyone here have SQL server? If so, I could send you the files so you'll have a look for yourselves. I've been trying to get this cart to work for 3 days now, and I know I'm close. It's just incredibly frustrating right now.

Hi, thanks for helping. Here's the code: sqlAdd = "INSERT INTO orders(ocustomerid,odate,orderamount,ocardtype,ocardno," sqlAdd = sqlAdd & "ocardname,ocardexpires,ocardaddress" If Not Request.Form("shipaddress")="" then sqlAdd = sqlAdd &...

When I try to check out my order in the shopping cart, I get an error which I don't know what means: Microsoft OLE DB Provider for SQL Server (0x80040E14) Line 1: Incorrect syntax near '.06'. /folder/process.asp, line 62 The code on that line is: call openConn() dbc.execute sqlAdd, intAffected

Nevermind people, problem is solved. I just found out my global.asa file wasn't initiating...

Hi, I been trying to get this shopping cart to work all week. Whenever I put an item in the basket I get an error msg: "Your browser does not enable cookies". But my browser DOES enable cookies. Here's the first half of the addprod.asp page: Dim prodid, quantity, arrCart, scartItem prodid =...

Maybe you could innstall that shopping cart yourself, and have a look? It only takes a couple of minutes. The url is: http://www.urlogy.com/asp/ashopkart.asp Once again, I really appreciate your help here.

No, the only query accepted was qryOrders...

Yeah, I understood the connection part. Here is the four queries: qryOrderInfo SELECT orders.orderID, orders.*, products.ccode, products.cname, products.cprice, oitems.numitems, customers.* FROM customers INNER JOIN (orders INNER JOIN (products INNER JOIN oitems ON products.catalogID...

All the tables from the Access database converts fine into the SQL database. But the access database has four stored queries that don't convert. Well, actually when I use the DTS wizards to convert the database, one of the queries, "qryOrders", is listed as a "view" and get's converted to a...

I'm converting a Access database to SQl, but I've ran into some problems. I'm a complete rookie at this and I'm trying out a free shopping cart from http://www.urlogy.com/. When converting to SQL, it says on the website something like this: "Remember to also create the stored procedures with...

Yeah, I tried it. It still doesn't work.

No, the data type is float. Any suggestions?

I'm building a website with a shopping cart. But when I'm setting up the cartID, I get a error message. My browser is in norwegian, but I think the msg says "Type mismatch" (or something like that). Here is the code: dim CartID CartID = Request.QueryString ("CartID") If CartID = "" Then Dim...

I'm really stuck on this.. how do I split up a string and then count each character? For example that the letter A had 3 occurences, b had 2 etc. etc.. I've been working on this for several days, but I can't figure it out. So any help would be appreciated.