Why am I getting this error ? 
Author Message
 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  
 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  
 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  
 
 [ 3 post ] 

 Relevant Pages 

1. why am I getting this error??

2. Null Values - WHY am I getting this error?

3. Please Help: Why am I now getting this error

4. Why am I getting this error? works in other databases

5. Why am I getting this message?

6. Why am I getting a Closed Recordset

7. I am getting errors I can't pin down

8. VB4 16-bits: I am getting an error message when compiling

9. i am getting error sending stdPic to out-of-Process Component

10. Help - I am getting an error using data control

11. I am getting an error Please help if you can

12. Why do i keep getting Error 3021???

 

 
Powered by phpBB® Forum Software