too few parameters

[cr0w]

Under microsoft acces this query works fine but under asp(VBScript) I get an error too few parameters

SELECT DISTINCT Produkten.Catagorie, Produkten.ArtikelId, Produkten.Titel, Produkten.Imagepath, Produkten.Omschrijving, Produkten.Artikelnr FROM Produkten INNER JOIN (Maten INNER JOIN Kleuren ON (Maten.ProduktID = Kleuren.ProduktID) AND (Maten.MaatID = Kleuren.MaatID)) ON Produkten.ArtikelId = Maten.ProduktID WHERE (((Produkten.Catagorie)="& cat & &quot AND ((Kleuren.Voorraad)>=1) AND ((produkten.status)=1)) Order by Titel

 

[jonscott8]

Did you remember to populate the variable cat?

If Produkten.Catagorie is a Text field, you'll need to encapsulate the value with single quotes. IE,

(((Produkten.Catagorie)='" & cat & "') AND

Typically, this error occurs when there is something in the SQL that Jet can't identify, ie, a misspelled field/table name,etc... Jon Hawkins