Hvad gør jeg galt??
jeg har en kode der ser sådan her ud:<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DBQ=c:\\inetpub\\wwwroot\\job\\jobdatabase.mdb;DefaultDir=c:\\inetpub\\wwwroot\\job;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;\"
SQL=\"SELECT * FROM job WHERE Kategori = \" & Request.QueryString(\"kat\")
Set RS = Server.CreateObject(\"ADODB.RecordSet\")
rs.open SQL,conn
do while not rs.eof and not rs.bof
response.write \"<table width=500 bgcolor=#e9e9e9 bordercolor=#00000 onmouseover=co(this,\'in\'); onmouseout=co(this,\'out\');><tr valign=top><td width=30 valign=top><font size=2 face=verdana>\" & rs(\"id\") & \"<br></td><td valign=top width=430><font size=2 face=verdana>\" & rs(\"titel\") & \"</td><td width=40><font size=2 face=verdana><a href=edit3.asp?ID=\" & rs(\"id\") & \" class=menu>Ret</a></td><td><font size=2 face=verdana><a href=sletgodkend.asp?ID=\" & rs(\"id\") & \" class=menu>Slet</a></tr><table>\"
rs.movenext
loop
%>
Og får denne fejl:
Microsoft OLE DB Provider for ODBC Drivers fejl \'80040e10\'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/job/vis.asp, linje 17
