Wrong number of parameters ?!

  • Thread starter Thread starter Alexander Rehbein
  • Start date Start date
A

Alexander Rehbein

Hi,

I have to transfer a web-site to a new server.

I changed nothing, but I always get this scary error:

---------------

ODBC Error Code = 07001 (Wrong number of parameters)

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.

----------------

I changed nothing in the table and in the code.



This is the code-part:

-------------

<cfquery name="qGetDetail" datasource="#gxDatasource#" dbtype="ODBC"
maxrows="2">
SELECT Maeder_Artikel.*, Maeder_Variante.*, Maeder_Lieferant.L_Name
FROM (Maeder_Artikel INNER JOIN Maeder_Variante ON Maeder_Artikel.A_NR =
Maeder_Variante.A_NR) INNER JOIN Maeder_Lieferant ON Maeder_Artikel.L_NR =
Maeder_Lieferant.L_NR
WHERE Maeder_Variante.show = 1 AND Maeder_Variante.V_cuisine = 1;
</cfquery>

---------------

If I execute this Query in Access directly I have to type in two arguments
as the error msg says (WHERE Maeder_Variante.show = 1 AND
Maeder_Variante.V_cuisine = 1; <-- these fields).





I cannot find the error :(

Thank you for your help

Greetings

Alex
 
Back
Top