Hvorfor virker det ikke
Hej med jerJeg har en side, hvor man har mulighed for at vælge hvilken varer man vil se med en checkbox. Det virker fint, så længe man kun vælger en vare, men vælger man to får jeg hele tiden denne fejl på min detajleside
-----------------------
Microsoft JET Database Engine error '80040e14'
Syntax error (comma) in query expression 'KatalogID = 4, 3'.
/malerjust/asp/salgdetajle.asp, line 20
--------------------------------
Her er min kode på den side, som skal vise de varer man har valgt
----------------------------
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="../../Connections/Malerjust.asp" -->
<%
Dim rskatalog__MMColParam
rskatalog__MMColParam = "0"
If (Request.Form("valg") <> "") Then
rskatalog__MMColParam = Request.Form("valg")
End If
%>
<%
Dim rskatalog
Dim rskatalog_numRows
Set rskatalog = Server.CreateObject("ADODB.Recordset")
rskatalog.ActiveConnection = MM_Malerjust_STRING
rskatalog.Source = "SELECT * FROM Katalog WHERE KatalogID = " + Replace(rskatalog__MMColParam, "'", "''") + ""
rskatalog.CursorType = 0
rskatalog.CursorLocation = 2
rskatalog.LockType = 1
rskatalog.Open()
rskatalog_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
rskatalog_numRows = rskatalog_numRows + Repeat1__numRows
%>
<html><!-- InstanceBegin template="/Templates/temp_forside_just1.dwt.asp" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Malermester Just</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<script Language="JavaScript">
<!--
function displayDate() {
var this_month = new Array(12);
this_month[0] = "Januar";
this_month[1] = "Februar";
this_month[2] = "Marts";
this_month[3] = "April";
this_month[4] = "Maj";
this_month[5] = "Juni";
this_month[6] = "July";
this_month[7] = "August";
this_month[8] = "September";
this_month[9] = "Oktober";
this_month[10] = "November";
this_month[11] = "December";
var today = new Date();
var day = today.getDate();
var month = today.getMonth();
var year = today.getYear();
if (year < 1000) {
year += 1900;
}
return(day+" "+this_month[month]+" "+year);
}
function MM_displayStatusMsg(msgStr) { //v1.0
status=msgStr;
document.MM_returnValue = true;
}
//-->
</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<link href="../stylesheet/just" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#003366" onLoad="MM_preloadImages('../gfx/menunedrod_04.gif','../gfx/menunedrod_06.gif','../gfx/menunedrod_08.gif','../gfx/menunedrod_10.gif','../gfx/menunedrod_12.gif')">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td valign="top"><table width="760" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" valign="top">
<!-- ImageReady Slices (malerjustlogo.psd) -->
<TABLE WIDTH=759 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD> <IMG SRC="../gfx/malerjustlogo_01.gif" WIDTH=124 HEIGHT=41></TD>
<TD> </TD>
<TD> <IMG SRC="../gfx/malerjustlogo_03.gif" WIDTH=62 HEIGHT=41></TD>
<TD width="164"> <IMG SRC="../gfx/malerjustlogo_04.gif" WIDTH=164 HEIGHT=41></TD>
<TD> <IMG SRC="../gfx/malerjustlogo_05.gif" WIDTH=261 HEIGHT=41></TD>
</TR>
<TR>
<TD> <IMG SRC="../gfx/malerjustlogo_06.gif" WIDTH=124 HEIGHT=35></TD>
<TD> <IMG SRC="../gfx/malerjustlogo_07.gif" WIDTH=148 HEIGHT=35></TD>
<TD> <IMG SRC="../gfx/malerjustlogo_08.gif" WIDTH=62 HEIGHT=35></TD>
<TD width="164" height="35" valign="top"> </TD>
<TD width="261"> <IMG SRC="../gfx/malerjustlogo_10.gif" HEIGHT=35></TD>
</TR>
<TR>
<TD height="40"> <IMG SRC="../gfx/malerjustlogo_11.gif" WIDTH=124 HEIGHT=40></TD>
<TD> <IMG SRC="../gfx/malerjustlogo_12.gif" WIDTH=148 HEIGHT=40></TD>
<TD> <IMG SRC="../gfx/malerjustlogo_13.gif" WIDTH=62 HEIGHT=40></TD>
<TD width="164" rowspan="2" valign="bottom"> <div align="center">
<!-- InstanceBeginEditable name="Overskrift" -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<!-- InstanceEndEditable --></div></TD>
<TD width="261" rowspan="2" valign="bottom"><!-- InstanceBeginEditable name="Menu" -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<!-- InstanceEndEditable --></TD>
</TR>
<TR>
<TD> </TD>
<TD> </TD>
<TD> </TD>
</TR>
</TABLE>
<!-- End ImageReady Slices -->
</td>
</tr>
<tr>
<td colspan="2" valign="top"> </td>
</tr>
<tr>
<td width="135" valign="top"> <table width="135" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1"> </td>
<td width="120" valign="top"><TABLE WIDTH=120 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD width="19"> <IMG SRC="../gfx/menuned_03.gif" name="p1" WIDTH=19 HEIGHT=28 id="p1"></TD>
<TD width="101"> <a href="profil.asp?kategoriID=1"><IMG SRC="../gfx/menuned_04.gif" name="profil" WIDTH=101 HEIGHT=28 border="0" id="profil" onMouseOver="MM_swapImage('profil','','../gfx/menunedrod_04.gif',1)" onMouseOut="MM_swapImgRestore()"></a></TD>
</TR>
<TR>
<TD> <IMG SRC="../gfx/menuned_05.gif" name="p2" WIDTH=19 HEIGHT=36 id="p2"></TD>
<TD> <a href="profil.asp?kategoriID=2"><IMG SRC="../gfx/menuned_06.gif" name="nyheder" WIDTH=101 HEIGHT=36 border="0" id="nyheder" onMouseOver="MM_swapImage('nyheder','','../gfx/menunedrod_06.gif',1)" onMouseOut="MM_swapImgRestore()"></a></TD>
</TR>
<TR>
<TD> <IMG SRC="../gfx/menuned_07.gif" name="p3" WIDTH=19 HEIGHT=36 id="p3"></TD>
<TD> <a href="profil.asp?kategoriID=3"><IMG SRC="../gfx/menuned_08.gif" name="entreprise" WIDTH=101 HEIGHT=36 border="0" id="entreprise" onMouseOver="MM_swapImage('entreprise','','../gfx/menunedrod_08.gif',1)" onMouseOut="MM_swapImgRestore()"></a></TD>
</TR>
<TR>
<TD> <IMG SRC="../gfx/menuned_09.gif" name="p4" WIDTH=19 HEIGHT=32 id="p4"></TD>
<TD> <a href="salg.asp?kategoriID=4"><IMG SRC="../gfx/menuned_10.gif" name="salg" WIDTH=101 HEIGHT=32 border="0" id="salg" onMouseOver="MM_swapImage('salg','','../gfx/menunedrod_10.gif',1)" onMouseOut="MM_swapImgRestore()"></a></TD>
</TR>
<TR>
<TD> <IMG SRC="../gfx/menuned_11.gif" name="p5" WIDTH=19 HEIGHT=34 id="p5"></TD>
<TD> <a href="mailto:%20malerjust@post.tele.dk"><IMG SRC="../gfx/menuned_12.gif" name="email" WIDTH=101 HEIGHT=34 border="0" id="email" onMouseOver="MM_swapImage('email','','../gfx/menunedrod_12.gif',1)" onMouseOut="MM_swapImgRestore()"></a></TD>
</TR>
</TABLE>
<!-- ImageReady Slices (menuned.psd) -->
<!-- End ImageReady Slices -->
</td>
<td width="14"> </td>
</tr>
</table></td>
<td width="600" valign="top"> <TABLE WIDTH=625 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD width="39"> <IMG SRC="../gfx/brodtekst_01.gif" WIDTH=39 HEIGHT=20 border="0"></TD>
<TD width="547" background="../gfx/brodtekst_05.gif">
</TD>
<TD width="39"> <IMG SRC="../gfx/brodtekst_06.gif" WIDTH=39 HEIGHT=20 border="0"></TD>
</TR>
</TABLE>
<table width="625" border="0" align="center" cellpadding="0" cellspacing="0" class="brodtabel">
<tr>
<td valign="top"> <!-- InstanceBeginEditable name="tekst" -->
<%
While ((Repeat1__numRows <> 0) AND (NOT rskatalog.EOF))
%>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>Varetype = </td>
<td rowspan="3"> <div align="right">
<% If rskatalog.Fields.Item("Billedevare").Value <> "" Then %>
<%=(rskatalog.Fields.Item("Billedevare").Value)%>
<% End If %>
</div></td>
</tr>
<tr>
<td>Varenavn = <%=(rskatalog.Fields.Item("Varenavn").Value)%></td>
</tr>
<tr>
<td>Vare nr. = </td>
</tr>
<tr>
<td colspan="2">Pris kr. = </td>
</tr>
<tr>
<td colspan="2">Beskrivelse af varen</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2"> </td>
</tr>
</table>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rskatalog.MoveNext()
Wend
%>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" class="brodtekst">
<tr>
<td valign="top"> <p> </p></td>
</tr>
</table>
<!-- InstanceEndEditable --></td>
</tr>
</table>
<TABLE WIDTH=625 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD width="39"> <IMG SRC="../gfx/brodtekstnede_01.gif" WIDTH=39 HEIGHT=20 border="0"></TD>
<TD width="547" background="../gfx/brodtekstnede_05.gif">
</TD>
<TD width="39"> <IMG SRC="../gfx/brodtekstnede_06.gif" WIDTH=39 HEIGHT=20 border="0"></TD>
</TR>
<TR>
<TD> </TD>
<TD><div align="center"><font color="#FFFFFF" size="2">Denne side
ses bedst med Internet Explorer 5 eller Netscape 6.<br>
Copyright © Malermester Just 2002 <br>
<script language="JavaScript" class="dato">
<!--
document.write (displayDate());
//-->
</script>
<br>
</font></div></TD>
<TD><div align="right"><font color="#FFFFFF" size="2"> </font></div></TD>
</TR>
</TABLE>
<p> </p>
<tr>
<td valign="top"></td>
<td></td>
</tr>
</table></td>
</tr>
</table>
<p class="dato"> </p>
</body>
<!-- InstanceEnd --></html>
<%
rskatalog.Close()
Set rskatalog = Nothing
%>
-------------------------------
Håber i kan hjælpe mig
