sql error help

Nov 07, 2005 2 Replies

hey everyone, i am trying to output this query in html through javascript. the error it gives me is error # 2147217913 error converting datatype nvarchar to numeric



code: var ItemCode;



ItemCode = window.prompt ("enter items lookup code"," "); var sql = "SELECT [Transaction].Time, [Transaction].TransactionNumber, TransactionEntry.Price, TransactionEntry.Quantity, Item.Description FROM TransactionEntry INNER JOIN [Transaction] ON TransactionEntry.TransactionNumber = [Transaction].TransactionNumber AND TransactionEntry.StoreID = [Transaction].StoreID INNER JOIN Customer ON [Transaction].CustomerID=Customer.ID LEFT JOIN Item ON TransactionEntry.ItemID = Item.ID LEFT JOIN Store ON TransactionEntry.StoreID = Store.ID"; sql = sql + " WHERE Item.ItemLookUpCode = " + ItemCode;



any help will be much appreciated


Try This:

sql = sql + " WHERE Item.ItemLookUpCode = '" + ItemCode + "'";

thank you Glen, Silly mistake on my side. thank you for your help that solve the problem shoby

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required