
Why am I getting this error ?
Have you tried it in the SQL Server Query Designer (or in Access Query Designer) - they will give you more info on the
error.
Chris.
I'me trying to run this SQL statement in an ASP ...
SELECT T.TranDate, T.TranInvoiceNo, S.StorName, P.SaleNameFirst,
P.SaleNameLast, C.CustNameFirst, C.CustNameLast, I.InvMake,
I.InvDescription, I.InvSize, I.InvColour FROM Transactions_Sales T, Store S,
SalesPeople P, Customer C, Inventory I WHERE day(T.TranDate) /
month(T.TranDate) / year(T.TranDate) = 25/1/2003 AND T.TranStoreNo =
S.StorNo AND T.TranSalesPersonNo = P.SaleNo AND T.TranCustomerNo = C.CustNo
AND T.TranInventoryNo = I.InvNo AND T.TranStoreNo = I.InvStoreNo ORDER by
S.StorName
but I get this error ...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/shoes/rep_tranlist2.asp, line 57
I don't understand the error being displayed. The SQL looks OK to me.
Any ideas ?