vbscript, Why am I getting this error ?

Why am I getting this error ?

Author	Message
Paul Whit #1 / 3	Why am I getting this error ? 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 ?
Wed, 13 Jul 2005 21:42:48 GMT

Chris Barbe #2 / 3	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 ?
Wed, 13 Jul 2005 22:17:32 GMT

Randy Ramire #3 / 3	Why am I getting this error ? There is something confusing about the concatenation of your date. WHERE day(T.TranDate) / month(T.TranDate) / year(T.TranDate) = 25/1/2003 Why don't you just have WHERE (T.TranDate) = #25/1/2003# Randy Quote: > 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 ?
Thu, 14 Jul 2005 04:03:01 GMT

Page 1 of 1

[ 3 post ]