|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Too few parameters. Expected 1. What does it mean?
I have a Access database on a tomcat server. Normal database operations works just perfect, so I don't think there is anything wrong with the connection. My problem is two sql querys that both give me the same error: Too few parameters. Expected 1.
When i run them in Access alone, I get what I want... What is the problem? SELECT Dep.DeptName, Dep.Owes, COUNT(Car.OutTo) AS CarsOut, SUM(Car.Cost*((Today.Date-Car.OutOn)+1)) AS Liability, Dep.Owes+Liability AS Total FROM Today, (Dep INNER JOIN Emp ON Dep.DeptName=Emp.DeptName) INNER JOIN Car ON Emp.Name=Car.OutTo GROUP BY Dep.DeptName, Dep.Owes HAVING ((Dep.DeptName)<>"It") SELECT Car.CarNr, Car.Make FROM (CanTake INNER JOIN Emp ON CanTake.Name = Emp.Name) INNER JOIN Car ON CanTake.Make = Car.Make WHERE (((Car.Make)=[CanTake].[Make]) AND ((CanTake.Name)=[Emp].[Name]) AND ((Car.OutTo) Is Null) AND ((Emp.Name)=[Jenny])); Just an other problem: When running the last query in access, why do i have to type in the Emp.Name in a "popup" form asking for parameter value? Doesn't Emp.Name = Jenny do the trick? When i remove that last criteria i get the whole list, so it got to do something right.. Last edited by victor : April 5th, 2004 at 11:23 PM. |
|
#2
|
|||
|
|||
|
I have solved the problems
![]() SELECT Dep.DeptName, Dep.Owes, COUNT(Car.OutTo) AS CarsOut, SUM(Car.Cost*((Today.Date-Car.OutOn)+1)) AS Liability, Dep.Owes+Liability AS Total FROM Today, (Dep INNER JOIN Emp ON Dep.DeptName=Emp.DeptName) INNER JOIN Car ON Emp.Name=Car.OutTo GROUP BY Dep.DeptName, Dep.Owes HAVING Dep.DeptName <> 'It' and SELECT Car.CarNr, Car.Make FROM (CanTake INNER JOIN Emp ON CanTake.Name = Emp.Name) INNER JOIN Car ON CanTake.Make = Car.Make WHERE Car.Make = CanTake.Make AND CanTake.Name = Emp.Name AND Car.OutTo Is Null AND Emp.Name = 'Jenny' |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Too few parameters. Expected 1. What does it mean? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|