Avatar billede mightythor Nybegynder
10. maj 2001 - 11:21 Der er 7 kommentarer og
1 løsning

Hvorfor virker dette ikke??

Hej Alle

Jeg er ved at lave en personlig side, og jeg har et problem jeg ikke forstår.

Her er siden:

http://www.autonorden-it.dk/mt

Tryk på knappen: Everquest
Tryk på knappen: Karakterer

Vælg en Karakter, nu får jeg en fejlmeddelelse:

Microsoft OLE DB Provider for ODBC Drivers error \'80040e10\'

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

/mt/eq3.asp, line 28

Her er koden for de 2 filer:

EQ2.ASP

<html>
<head>
<title>Mighty Thors Ultra Deluxe Page of Everything</title>
<style type=\"text/css\">
.bgcolor    { background: #003a00 }
.bgcolorover { background: #ff9900; color: #000000 }
a            { text-decoration: none }
</style>
</head>
<body bgcolor=\"#003a00\" text=\"#fcfc52\" link=\"#fcfc52\" alink=\"#fcfc52\" vlink=\"#fcfc52\">
<font face=\"verdana\">
<table width=\"760\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td width=\"60%\" align=\"center\" valign=\"top\"><img src=\"gfx/mt.gif\" width=\"501\" height=\"119\" border=\"0\" alt=\"Animeret Mighty Thor logo\"></td>
<td width=\"40%\">&nbsp;</td>
</tr>
</table>
<br><br>
<table width=\"760\" cellpadding=\"4\" cellspacing=\"5\" border=\"1\" bordercolor=\"#003a00\">
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"default.asp\"><font size=\"1\"><b>Forside</b></font></a></td>
<td width=\"660\" rowspan=\"8\" valign=\"top\"><center><font size=\"2\"><b>Mine Karakterer i EverQuest, sorteret efter Servers</b></font><br><br>
<table cellspacing=\"5\" cellpadding=\"2\" border=\"0\">
<tr>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><b>Drinal:</b></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=reaber\"><u>Reaber<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Wood Elf</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Ranger</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 10</font></td>
</tr>
<tr>
<td valign=\"top\"><font size=\"2\"><b>Povar:</b></font></td>
<td valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=tovary\"><u>Tovary<u/></a></font></td>
<td valign=\"top\"><font size=\"2\">Barbarian</font></td>
<td valign=\"top\"><font size=\"2\">Warrior</font></td>
<td valign=\"top\"><font size=\"2\">Level 17</font></td>
</tr>
<tr>
<td valign=\"top\"><font size=\"2\"><b>Tallon Zek:</b></font></td>
<td valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=zkye\"><u>Zkye<u/></a></font></td>
<td valign=\"top\"><font size=\"2\">Wood Elf</font></td>
<td valign=\"top\"><font size=\"2\">Ranger</font></td>
<td valign=\"top\"><font size=\"2\">Level 10</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><b>The Rathe:</b></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=wildroot\"><u>Wildroot<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Wood Elf</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Druid</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 40</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\">&nbsp;</td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=thax\"><u>Thax<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Dwarf</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Cleric</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 19</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\">&nbsp;</td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=wulfheim\"><u>Wulfheim<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Barbarian</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Warrior</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 15</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\">&nbsp;</td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=zcye\"><u>Zcye<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Wood Elf</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Ranger</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 14</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\">&nbsp;</td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=plean\"><u>Plean<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Dwarf</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Rogue</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 11</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\">&nbsp;</td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=poltroy\"><u>Poltroy<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Half Elf</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Bard</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 05</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\">&nbsp;</td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=flaym\"><u>Flaym<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Erudite</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Wizard</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 04</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\">&nbsp;</td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=fleetfoot\"><u>Fleetfoot<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Wood Elf</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Druid</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 03</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><b>Vallon Zek:</b></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=bodur\"><u>Bodur<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Dwarf</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Cleric</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 26</font></td>
</tr>
<tr>
<td width=\"20%\" valign=\"top\">&nbsp;</td>
<td width=\"20%\" valign=\"top\"><font size=\"2\"><a href=\"eq3.asp?name=rahllos\"><u>Rahllos<u/></a></font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Barbarian</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Shaman</font></td>
<td width=\"20%\" valign=\"top\"><font size=\"2\">Level 09</font></td>
</tr>
</table>
</center>
</td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"info.asp\"><font size=\"1\"><b>Personlig Info</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"eq.asp\"><font size=\"1\"><b>Everquest</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"rpg.asp\"><font size=\"1\"><b>Rollespil</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"forum/\"><font size=\"1\"><b>Forum</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"links.asp\"><font size=\"1\"><b>Links</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"admin.asp\"><font size=\"1\"><b>Administration</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#003a00\" bordercolordark=\"#003a00\"><br><br><br><br><br><br><br><br><br><br><br></td>
</tr>
</table>
</font>
</body>
</html>

EQ3.ASP

<html>
<head>
<title>Mighty Thors Ultra Deluxe Page of Everything</title>
<style type=\"text/css\">
.bgcolor    { background: #003a00 }
.bgcolorover { background: #ff9900; color: #000000 }
a            { text-decoration: none }
</style>
</head>
<body bgcolor=\"#003a00\" text=\"#fcfc52\" link=\"#fcfc52\" alink=\"#fcfc52\" vlink=\"#fcfc52\">
<font face=\"verdana\">
<table width=\"760\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td width=\"60%\" align=\"center\" valign=\"top\"><img src=\"gfx/mt.gif\" width=\"501\" height=\"119\" border=\"0\" alt=\"Animeret Mighty Thor logo\"></td>
<td width=\"40%\">&nbsp;</td>
</tr>
</table>
<br><br>
<table width=\"760\" cellpadding=\"4\" cellspacing=\"5\" border=\"1\" bordercolor=\"#003a00\">
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"default.asp\"><font size=\"1\"><b>Forside</b></font></a></td>
<td width=\"660\" rowspan=\"9\" valign=\"top\">

<%
set conn = server.createobject(\"adodb.connection\")
conn.open \"driver={microsoft access driver (*.mdb)}; dbq=\" & server.mappath(\"mt.mdb\")
sqlstmt = \"select * from EQEQUIP where char = \" & request(\"name\")
conn.Execute (sqlstmt)
set rs = conn.execute(sqlstmt)
%>

<center><font size=\"4\"><b>UDRUSTNINGSLISTE</b></font>
<table width=\"100%\" cellpadding=\"2\" cellspacing=\"0\" border=\"2\" bordercolor=\"#fcfc52\">
<tr>
<td width=\"100%\" bordercolorlight=\"#003a00\" bordercolordark=\"#003a00\">
<table width=\"100%\" cellpadding=\"2\" cellspacing=\"4\" border=\"1\" bordercolor=\"#003a00\">
<tr>
<td width=\"20%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"lefteardes\")%>&name=<%=rs(\"leftear\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Left Ear</b></a><br><br><%=rs(\"leftear\")%></font></p></td>
<td width=\"20%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"neckdes\")%>&name=<%=rs(\"neck\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Neck</b></a><br><br><%=rs(\"neck\")%></font></p></td>
<td width=\"20%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"facedes\")%>&name=<%=rs(\"face\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Face</b></a><br><br><%=rs(\"face\")%></font></p></td>
<td width=\"20%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"headdes\")%>&name=<%=rs(\"head\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Head</b></a><br><br><%=rs(\"head\")%></font></p></td>
<td width=\"20%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"righteardes\")%>&name=<%=rs(\"rightear\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Right Ear</b></a><br><br><%=rs(\"rightear\")%></font></p></td>
</tr>
</table>
<table width=\"100%\" cellpadding=\"2\" cellspacing=\"4\" border=\"1\" bordercolor=\"#003a00\">
<tr>
<td width=\"17%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"leftringdes\")%>&name=<%=rs(\"leftring\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Left Ring</b></a><br><br><%=rs(\"leftring\")%></font></p></td>
<td width=\"16%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"leftwristdes\")%>&name=<%=rs(\"leftwrist\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Left Wrist</b></a><br><br><%=rs(\"leftwrist\")%></font></p></td>
<td width=\"17%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"armsdes\")%>&name=<%=rs(\"arms\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Arms</b></a><br><br><%=rs(\"arms\")%></font></p></td>
<td width=\"17%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"handsdes\")%>&name=<%=rs(\"hands\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Hands</b></a><br><br><%=rs(\"hands\")%></font></p></td>
<td width=\"16%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"rightwristdes\")%>&name=<%=rs(\"rightwrist\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Right Wrist</b></a><br><br><%=rs(\"rightring\")%></font></p></td>
<td width=\"17%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"rightringdes\")%>&name=<%=rs(\"rightring\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Right Ring</b></a><br><br><%=rs(\"rightwrist\")%></font></p></td>
</tr>
</table>
<table width=\"100%\" cellpadding=\"2\" cellspacing=\"4\" border=\"1\" bordercolor=\"#003a00\">
<tr>
<td width=\"17%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"shoulderdes\")%>&name=<%=rs(\"shoulder\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Shoulder</b></a><br><br><%=rs(\"shoulder\")%></font></p></td>
<td width=\"16%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"chestdes\")%>&name=<%=rs(\"chest\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Chest</b></a><br><br><%=rs(\"chest\")%></font></p></td>
<td width=\"17%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"backdes\")%>&name=<%=rs(\"back\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Back</b></a><br><br><%=rs(\"back\")%></font></p></td>
<td width=\"17%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"waistdes\")%>&name=<%=rs(\"waist\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Waist</b></a><br><br><%=rs(\"waist\")%></font></p></td>
<td width=\"16%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"legsdes\")%>&name=<%=rs(\"legs\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Legs</b></a><br><br><%=rs(\"legs\")%></font></p></td>
<td width=\"17%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"feetdes\")%>&name=<%=rs(\"feet\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Feet</b></a><br><br><%=rs(\"feet\")%></font></p></td>
</tr>
</table>
<table width=\"100%\" cellpadding=\"2\" cellspacing=\"4\" border=\"1\" bordercolor=\"#003a00\">
<tr>
<td width=\"25%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"prihanddes\")%>&name=<%=rs(\"prihand\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Primary Hand</b></a><br><br><%=rs(\"prihand\")%></font></p></td>
<td width=\"25%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"sechanddes\")%>&name=<%=rs(\"sechand\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Secondary Hand</b></a><br><br><%=rs(\"sechand\")%></font></p></td>
<td width=\"25%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"rangeddes\")%>&name=<%=rs(\"ranged\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Ranged</b></a><br><br><%=rs(\"ranged\")%></font></p></td>
<td width=\"25%\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#fcfc52\"><p align=\"center\"><font size=\"1\"><a href=\"#\" onClick=\"window.open(\'eq_vis_item.asp?id=<%=rs(\"id\")%>&item=<%=rs(\"ammodes\")%>&name=<%=rs(\"ammo\")%>\', \'\', config=\'height=200,width=400,left=250,top=200,toolbar=no,menubar=no,scrollbars=no,resizeable=no,location=no,directories=no,status=no\')\";><b>Ammo</b></a><br><br><%=rs(\"ammo\")%></font></p></td>
</tr>
</table>
</td>
</tr>
</table>
</center>

<%
rs.close
conn.close
set conn = nothing
set sqlstmt = nothing
%>

</td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"info.asp\"><font size=\"1\"><b>Personlig Info</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"eq.asp\"><font size=\"1\"><b>Everquest</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"eq2.asp\"><font size=\"1\"><b>Karakterer</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"rpg.asp\"><font size=\"1\"><b>Rollespil</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"forum/\"><font size=\"1\"><b>Forum</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"links.asp\"><font size=\"1\"><b>Links</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#fcfc52\" bordercolordark=\"#dada52\" class=\"bgcolor\" onmouseover=\"this.className=\'bgcolorover\'\" onmouseout=\"this.className=\'bgcolor\'\"><a href=\"admin.asp\"><font size=\"1\"><b>Administration</b></font></a></td>
</tr>
<tr>
<td width=\"100\" align=\"center\" valign=\"top\" bordercolorlight=\"#003a00\" bordercolordark=\"#003a00\"><br><br><br><br><br><br><br><br><br><br><br><br><br></td>
</tr>
</table>
</font>
</body>
</html>

Håber nogen kan hjælpe...

Mvh
Søren
Avatar billede nute Nybegynder
10. maj 2001 - 11:32 #1
fjern denne linje i EQ3.asp:

conn.Execute (sqlstmt)


en annen ting er at det er overhodet ikke nødvendig å poste all denne HTML kode. det hadde holdt med  å kun poste din ASP kode...
Avatar billede mightythor Nybegynder
10. maj 2001 - 11:40 #2
Hmm

Det virker ikke nute, så for jeg bare denne fejl:

Microsoft OLE DB Provider for ODBC Drivers error \'80040e10\'

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

/mt/eq3.asp, line 29


Mvh
Søren
Avatar billede mightythor Nybegynder
10. maj 2001 - 11:54 #3
Prøver at omformulere spørgsmålet
Avatar billede erikjacobsen Ekspert
10. maj 2001 - 11:55 #4
men gør nu alligevel som nute siger. Én execute er nok, ellers er fejlen i linien

      sqlstmt = \"select * from EQEQUIP where char = \" & request(\"name\")

hvor enten request(\"name\") er tom (har du stavet det rigtigt) eller den skulle have
været

      sqlstmt = \"select * from EQEQUIP where char = \'\" & request(\"name\") & \"\'\"

prøv dig frem

Avatar billede erikjacobsen Ekspert
10. maj 2001 - 11:56 #5
Ikke nødvendigt, mightythor. Den klarer vi nok
Avatar billede mightythor Nybegynder
10. maj 2001 - 12:04 #6
erikjacobsen

Det virker, jeg hader alle de \' og \" i ASP

:)

Hvis du opretter et svar i:

http://www.eksperten.dk/spm/71701

Så får du points

Mvh
Søren
Avatar billede cyb Nybegynder
10. maj 2001 - 12:20 #7
Prøv at udskriv din connections streng.

response.write \"driver={microsoft access driver (*.mdb)}; dbq=\" & server.mappath(\"mt.mdb\")

Jeg tror du mangler et \';\' tegn tilsidst.

Avatar billede nute Nybegynder
10. maj 2001 - 12:22 #8
cyb >> det er ikke nødvendig...
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester