Avatar billede vels Nybegynder
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">&nbsp;</td>
      <td width="245" valign="top">&nbsp;</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">&nbsp;</td>
      <td width="245" valign="top">&nbsp;</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 ?
Avatar billede sv Nybegynder
18. juni 2000 - 13:28 #1
hvad giver den af fejl ??
Avatar billede cyigen Nybegynder
18. juni 2000 - 13:36 #2
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">&nbsp;</td>
      <td width="245" valign="top">&nbsp;</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">&nbsp;</td>
      <td width="245" valign="top">&nbsp;</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

%>


________________________________________
Avatar billede vels Nybegynder
18. juni 2000 - 13:47 #3
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
Avatar billede cyigen Nybegynder
18. juni 2000 - 13:59 #4
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
Avatar billede vels Nybegynder
18. juni 2000 - 14:05 #5
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)
Avatar billede vels Nybegynder
18. juni 2000 - 14:06 #6
skod.asp er selve formen (den øverste)
Avatar billede cyigen Nybegynder
18. juni 2000 - 17:07 #7
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")

Avatar billede cyigen Nybegynder
18. juni 2000 - 17:10 #8
cname er vel den form som kommer fra selve ejerens navn??


/cyigen
Avatar billede vels Nybegynder
18. juni 2000 - 17:22 #9
Takker :-) Nu virker det :-)
Avatar billede cyigen Nybegynder
19. juni 2000 - 12:52 #10
Var så lidt!

/CeY
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

IT-JOB

Socialpædagogernes Landsforbund

Data engineer til barselsvikariat: Microsoft Fabric

Capgemini Danmark A/S

AI/Data Engineer

Politiets Efterretningstjeneste

Netværksspecialist til IT i PET

BEC Financial Technologies

Development Manager for Document Lifecycle