18. juni 2000 - 13:17
Der er
9 kommentarer og 1 løsning
Update
Hej jeg har denne form: <html> <head> <title>Update</title> </head> <body bgcolor="cac6c6"> <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("scart.mdb") SQLstmt = "SELECT * FROM products WHERE catalogID = " & Request("id") Conn.Execute (SQLstmt) Set rs = conn.Execute(SQLstmt) %> <form method="POST" action="gem_ret_data.asp?id=<%=rs("catalogID")%>"> <table border="0" width="95%" bgcolor="#000000" cellspacing="0" cellpadding="0" style="border: 1 solid #000000"> <tr> <td width="283" colspan="2" valign="top" bgcolor="#000000" bordercolor="#000000"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"><b>Opdater</b></font></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top" height="20"> </td> <td width="245" valign="top"> </td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top" height="1"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><img border="0" src="1x1.gif" width="1" height="1"></font></td> <td width="245" valign="top" height="1"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><img border="0" src="1x1.gif" width="1" height="1"></font></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Produktnavn</b></font></td> <td width="245" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"><b> <input type="text" name="cname" size="30" value="<%=rs("cname")%>"> </b></font></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font face="Verdana" size="2" color="#FFFFFF"><b>Pris</b></font></td> <td width="245" valign="top"><input type="text" name="cprice" size="20" value="<%=rs("cprice")%>"></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font color="#FFFFFF" size="2" face="Verdana"><b>Grossist</b></font></td> <td width="245" valign="top"><input type="text" name="Grosist" size="20" value="<%=rs("Grosist")%>"></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font color="#FFFFFF" size="2" face="Verdana"><b>vare nr.</b></font></td> <td width="245" valign="top"><input type="text" name="ccode" size="20" value="<%=rs("ccode")%>"></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><b><font color="#FFFFFF" size="2" face="Verdana">Beskrivelse</font></b></td> <td width="245" valign="top"><textarea rows="6" name="cdescription" cols="33"><%=rs("cdescription")%></textarea></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font color="#FFFFFF" size="2" face="Verdana"><b>PIC</b></font></td> <td width="245" valign="top"><input type="text" name="cimageurl" size="20" value="<%=rs("cimageurl")%>"></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"> </td> <td width="245" valign="top"> </td> </tr> </table> <input type="hidden" name="dato" value="<%=Now%>"> <p><input type="submit" value="Send" name="B1"></p> </form> <% conn.Close Set conn = nothing Set SQLstmt = nothing %> </body> </html> Den skal opdatere en database. Den skal kun opdatere disse felter der er i formen. Jeg kan sku ikke finde ud af en sql sætning der virker jeg har prøvet denne men den kan jeg ikke få til at virke: <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("scart.mdb") SQLstmt = "UPDATE DISTINCTROW adresse SET cname = " & request.form("cname") & ",cprice = '" & request.form("cprice") & "',Grosist = '" & request.form("Grosist") & "' WHERE catalogID = " & Request("catalogID") 'SQLstmt = SQLstmt & " VALUES (" & request.form("telefon") & ",#" & Now & "#,'" & request.form("navn") & "','" & request.form("adresse") & "'," & request.form("postnr") & ",'" & request.form("city") & "'," & request.form("telefon") & "," & telefax & ",'" & request.form("hjemmeside") & "','" & request.form("email") & "','" & request.form("info_om") & "','" & request.form("henviser_til") & "')" Conn.Execute (SQLstmt) conn.Close Set conn = nothing Set SQLstmt = nothing %> Er der en der kan hjælpe ?
Annonceindlæg fra HP
sv
Nybegynder
18. juni 2000 - 13:28
#1
hvad giver den af fejl ??
Ja måske... Du mangler i din opdaterings felt Where catalogID = " & Session("id") ... Bruge denne ved start siden!!! ________________________________________ <html> <head> <title>Update</title> </head> <body bgcolor="cac6c6"> <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("scart.mdb") SQLstmt = "SELECT * FROM products WHERE catalogID = " & Request("id") Conn.Execute (SQLstmt) Set rs = conn.Execute(SQLstmt) 'Har sættet denne ind så den gemmer ID'en som session!! rs("catalogID") = Session("ID") %> <form method="POST" action="gem_ret_data.asp?id=<%=rs("catalogID")%>"> <table border="0" width="95%" bgcolor="#000000" cellspacing="0" cellpadding="0" style="border: 1 solid #000000"> <tr> <td width="283" colspan="2" valign="top" bgcolor="#000000" bordercolor="#000000"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"><b>Opdater</b></font></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top" height="20"> </td> <td width="245" valign="top"> </td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top" height="1"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><img border="0" src="1x1.gif" width="1" height="1"></font></td> <td width="245" valign="top" height="1"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><img border="0" src="1x1.gif" width="1" height="1"></font></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Produktnavn</b></font></td> <td width="245" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"><b> <input type="text" name="cname" size="30" value="<%=rs("cname")%>"> </b></font></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font face="Verdana" size="2" color="#FFFFFF"><b>Pris</b></font></td> <td width="245" valign="top"><input type="text" name="cprice" size="20" value="<%=rs("cprice")%>"></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font color="#FFFFFF" size="2" face="Verdana"><b>Grossist</b></font></td> <td width="245" valign="top"><input type="text" name="Grosist" size="20" value="<%=rs("Grosist")%>"></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font color="#FFFFFF" size="2" face="Verdana"><b>vare nr.</b></font></td> <td width="245" valign="top"><input type="text" name="ccode" size="20" value="<%=rs("ccode")%>"></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><b><font color="#FFFFFF" size="2" face="Verdana">Beskrivelse</font></b></td> <td width="245" valign="top"><textarea rows="6" name="cdescription" cols="33"><%=rs("cdescription")%></textarea></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"><font color="#FFFFFF" size="2" face="Verdana"><b>PIC</b></font></td> <td width="245" valign="top"><input type="text" name="cimageurl" size="20" value="<%=rs("cimageurl")%>"></td> </tr> <tr bgcolor="#2280c2"> <td width="43" valign="top"> </td> <td width="245" valign="top"> </td> </tr> </table> <input type="hidden" name="dato" value="<%=Now%>"> <p><input type="submit" value="Send" name="B1"></p> </form> <% conn.Close Set conn = nothing Set SQLstmt = nothing %> </body> </html> ________________________________________ Opdaterings siden ________________________________________ <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("scart.mdb") SQLstmt = "UPDATE DISTINCTROW adresse SET cname = " & request.form("cname") & ",cprice = '" & request.form("cprice") & "',Grosist = '" & request.form("Grosist") & "' WHERE catalogID = " & Request("catalogID") 'SQLstmt = SQLstmt & " VALUES (" & request.form("telefon") & ",#" & Now & "#,'" & request.form("navn") & "','" & request.form("adresse") & "'," & request.form("postnr") & ",'" & request.form("city") & "'," & request.form("telefon") & "," & telefax & ",'" & request.form("hjemmeside") & "','" & request.form("email") & "','" & request.form("info_om") & "','" & request.form("henviser_til") & "' WHERE catalogID = " & Session("ID") Conn.Execute (SQLstmt) conn.Close Set conn = nothing Set SQLstmt = nothing %> ________________________________________
Når jeg bruger skod.asp?id=200 ADODB.Recordset error '800a0cb3' Object or provider is not capable of performing requested operation. /data/admin/skod.asp, line 21
hvilken af dem er skod?? det kan være fordi du skal skrive Session("ID") = rs("catalogID") eller hvis det ikke virker så skriv Men det øverste burte virke! ID = rs("catalogID") Session("ID") = ID
når jeg bruger min egen for får jeg denne fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Asus K7M Bulk'.
/data/admin/gem_ret_data.asp, line 23
(tjek evt. selv på
www.vels.dk/data/admin/skod.asp?id=200 )
skod.asp er selve formen (den øverste)
brug det her istedet for <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("scart.mdb") SQLstmt = "UPDATE DISTINCTROW adresse SET cprice = '" & request.form("cprice") & "',Grosist = '" & request.form("Grosist") & "' WHERE catalogID = " & Request("catalogID") 'SQLstmt = SQLstmt & " VALUES (" & request.form("telefon") & ",#" & Now & "#,'" & request.form("navn") & "','" & request.form("adresse") & "'," & request.form("postnr") & ",'" & request.form("city") & "'," & request.form("telefon") & "," & telefax & ",'" & request.form("hjemmeside") & "','" & request.form("email") & "','" & request.form("info_om") & "','" & request.form("henviser_til") & "' WHERE cname = " & Request.form("cname") Conn.Execute (SQLstmt) conn.Close Set conn = nothing Set SQLstmt = nothing %> Og ved den der øverste script eller skod.asp slet den der linie som jeg skrev SSSSSSLLLLLLEEEEEETTTTTTTTTTT Session("ID") = rs("catalogID")
cname er vel den form som kommer fra selve ejerens navn?? /cyigen
Takker :-) Nu virker det :-)
19. juni 2000 - 12:52
#10
Var så lidt! /CeY
Kurser inden for grundlæggende programmering