Too few parameters. Expected 1.

der er det galt at den  ikke modtager \"kat-id\"

filnavn.asp?kat-id=xxx

hvis du bare vil vise alle kat-id skal du lave den sådan her...

Set rs2 = Connect.Execute(\"SELECT * FROM indhold ORDER BY kat-id\")

Set rs2 = Connect.Execute(\"SELECT * FROM indhold WHERE kat-id = \" & request(\"kat-id\"))

bjarke-b  >> jeg har lige prøvet dit forslag men det giver samme fejl ?
Her er hele scriptet:

<%
response.buffer = true
Request.QueryString(\"kat-id\")

set connect = server.createobject(\"ADODB.Connection\")
Connect.open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.mappath(\"image.mdb\")

\'Set rs2 = Connect.Execute(\"SELECT * FROM indhold WHERE kat-id = \'\" & request(\"kat-id\") & \"\'\")
Set rs2 = Connect.Execute(\"SELECT * FROM indhold WHERE kat-id = \" & request(\"kat-id\"))


if not rs2.EOF then
do until rs2.EOF
Response.Write \" - <a href=\"\"\" & rs2(\"kat-id\") & \"\"\">\" & rs2(\"kat-id\") & \"</a><br>\"
rs2.MoveNext
Loop
else
Response.Write \"Ingen Links i denne kategori!\"
end if

%>

katid = int(Request(\"kat-id\"))
Set rs2 = Connect.Execute(\"SELECT * FROM indhold WHERE kat-id = \" & katid)

Det kommer jo an på hvilke datatype du har sat feltet kat-id til at være!

kat-id er tekst

katid = Request(\"kat-id\")
Set rs2 = Connect.Execute(\"SELECT * FROM indhold WHERE kat-id = \'\" & katid & \"\')

Samme fejl
Too few parameters. Expected 1.

Det er fordi du skal have [] rundt om kat-id som følgende:
\"SELECT * FROM indhold WHERE [kat-id] = \" & katid
Grunden til det er at du har lavet et Specialtegn i dit kollonnenavn.