Update
HejJeg har denne asp fil jeg opdatere min webshop med. Det er en jeg selv har lavet, men jeg har lavet en kannon fejl... Når eks. viser kategorien bundkort og vil rette prisen på eks. 4 varere skal jeg rette prisen på varere 1 og trykke opdater og så ændre prisen på varere 2 og trykke opdater.... kan man ikke lave sådan man rette alle de priser under den kategori også KUN trykker opdater 1 gang??
Her er filen
------------------------------
<html>
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">
<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 4.0\">
<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">
<title>Vis adresser</title>
</head>
<body bgcolor=\"cac6c6\">
<%
if Request(\"id\") = 1 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Blandet</font></b></center>\"
end if
if Request(\"id\") = 2 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Bundkort</font></b></center>\"
end if
if Request(\"id\") = 3 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>CD-brændere</font></b></center>\"
end if
if Request(\"id\") = 4 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>CD-ROM drev</font></b></center>\"
end if
if Request(\"id\") = 5 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Digital Kamera</font></b></center>\"
end if
if Request(\"id\") = 6 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Disk drev</font></b></center>\"
end if
if Request(\"id\") = 7 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>DVD drev</font></b></center>\"
end if
if Request(\"id\") = 8 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Grafikkort</font></b></center>\"
end if
if Request(\"id\") = 9 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Harddiske</font></b></center>\"
end if
if Request(\"id\") = 10 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Højtalere</font></b></center>\"
end if
if Request(\"id\") = 11 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Joysticks</font></b></center>\"
end if
if Request(\"id\") = 12 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Kabinetter</font></b></center>\"
end if
if Request(\"id\") = 13 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Kabler</font></b></center>\"
end if
if Request(\"id\") = 14 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Lydkort</font></b></center>\"
end if
if Request(\"id\") = 15 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Medier</font></b></center>\"
end if
if Request(\"id\") = 16 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Mini Notes</font></b></center>\"
end if
if Request(\"id\") = 17 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Modems</font></b></center>\"
end if
if Request(\"id\") = 18then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>MP3 Player</font></b></center>\"
end if
if Request(\"id\") = 19 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Mus</font></b></center>\"
end if
if Request(\"id\") = 20 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Net tilbehør</font></b></center>\"
end if
if Request(\"id\") = 21 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Netkort</font></b></center>\"
end if
if Request(\"id\") = 22 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Printere</font></b></center>\"
end if
if Request(\"id\") = 23 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Processor</font></b></center>\"
end if
if Request(\"id\") = 24 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Ram</font></b></center>\"
end if
if Request(\"id\") = 25 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Scannere</font></b></center>\"
end if
if Request(\"id\") = 26 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Skærme</font></b></center>\"
end if
if Request(\"id\") = 27 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Tasteturer</font></b></center>\"
end if
if Request(\"id\") = 29 then
Response.Write \"<center><b><font color=\'#000000\' face=\'Verdana\' size=\'3\'>Webcam</font></b></center>\"
end if
%>
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Request.ServerVariables(\"APPL_PHYSICAL_PATH\") & \"\\data\\admin\\scart.mdb\"
SQLstmt = \"SELECT * FROM products WHERE ccategory = \" & Request(\"id\")
\'
\'response.write SQLstmt
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%>
<br>
<table border=\"1\" width=\"866\" bgcolor=\"#7D9BB9\" cellspacing=\"0\" cellpadding=\"0\" style=\"border: 1 solid #000000\">
<tr>
<%
DO WHILE NOT rs.EOF
ccategory = rs(\"ccategory\")
catalogID = rs(\"catalogID\")
cname = rs(\"cname\")
cprice = rs(\"cprice\")
Grosist = rs(\"Grosist\")
cdescription = rs(\"cdescription\")
cimageurl = rs(\"cimageurl\")
ccode = rs(\"ccode\")
catalogID = rs(\"catalogID\")
dato = rs(\"dato\")
%>
<tr>
<td valign=\"middle\" align=\"center\" bgcolor=\"#7D9BB9\" width=\"862\"><font face=\"Arial\" size=\"2\"><b><form method=\"POST\" action=\"gem_ret_data.asp?id=<%=rs(\"catalogID\")%>\">
<input type=\"hidden\" name=\"catalogID1\" size=\"1\" value=\"<%=catalogID%>\"><input type=\"hidden\" name=\"ccategory\" size=\"1\" value=\"<%=ccategory%>\">
<table border=\"0\" width=\"100%\" cellspacing=\"3\" cellpadding=\"2\">
<tr>
<td width=\"18%\" valign=\"top\" bgcolor=\"#3366FF\"><font face=\"Arial\" size=\"2\" color=\"#FFFFFF\"><b>Produkt navn:<br>
<input type=\"text\" name=\"cname\" size=\"41\" value=\"<%=cname%>\"><br>
Vare nr.:
<br>
<input type=\"text\" name=\"ccode\" size=\"20\" value=\"<%=ccodel%>\">
<br>
Sidst opdateret: <%=dato%> <input type=\"hidden\" name=\"dato1\" size=\"11\" value=\"<%=date%>\">
</b></font></td>
<td width=\"10%\" valign=\"top\" bgcolor=\"#3366FF\">
<p align=\"center\"><font face=\"Arial\" size=\"2\" color=\"#FFFFFF\"><b>Pris: <br>
<input type=\"text\" name=\"cprice\" size=\"10\" value=\"<%=cprice%>\">Kr.</b></font></p>
</td>
<td width=\"17%\" valign=\"top\" bgcolor=\"#3366FF\"><font face=\"Arial\" size=\"2\" color=\"#FFFFFF\"><b>Grossist:<br>
<input type=\"text\" name=\"Grosist\" size=\"23\" value=\"<%=Grosist%>\"><br>
</b></font></td>
<td width=\"41%\" valign=\"top\" bgcolor=\"#3366FF\"><font face=\"Arial\" size=\"2\" color=\"#FFFFFF\"><b>Beskrivelse:<br>
<input type=\"text\" name=\"cdescription\" size=\"45\" value=\"<%=cdescription%>\">
<input type=\"submit\" value=\"Update\" name=\"B1\"></b></font></td>
</tr>
</table>
</b></font></form></td>
<%
rs.MoveNext
LOOP
RS.Close
Response.Write \"</TABLE>\"
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%> </tr>
</table>
<p> </p>
</body>
