10. august 2000 - 19:04
Der er
3 kommentarer og 1 løsning
Database uddate problemer igen!!!
Goddag igen Jeg er ved at lave min database om, bl.a med online opdatering.men har et \"lille\" problem :( har en fil (retdata.asp) som kommer ud med denne fejl..: UPDATE DISTINCTROW Blandet SET Navn = mig igen, dato = #10-08-00 18:57:51#, Vits = \'ny test\' WHERE id = 127 VALUES (\'mig igen\',#10-08-00 18:57:51#,\'ny test\') Microsoft OLE DB Provider for ODBC Drivers fejl \'80040e14\' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression \'mig igen\'. /dbase/tilfoj/gem_ret_data.asp, linje 20 er der en eller anden der kan se hvad f.... jeg nu laver forkert :(
Annonceindlæg tema
Cloud & AI
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
10. august 2000 - 19:06
#1
retdata som hedder gem_ret_data.asp.. <html> <head> <title>Ret i Data</title> </head> <body> <% Set Conn = Server.CreateObject(\"ADODB.Connection\") Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"../jokes.mdb\") SQLstmt = \"SELECT * FROM blandet WHERE id = \" & Request(\"id\") Conn.Execute (SQLstmt) Set rs = conn.Execute(SQLstmt) %><center> <form method=\"POST\" action=\"gem_ret_data.asp?id=<%=rs(\"id\")%>\"> <table border=\"0\" width=\"400\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"0\" style=\"border: 1 solid #000000\"> <tr> <td valign=\"middle\" bgcolor=\"#ffff00\" colspan=\"2\" align=\"right\" height=\"18\" width=\"400\"><font color=\"#000080\" face=\"Arial\" size=\"1\">[<a href=\"default.asp\" style=\"color: #000080\">Til forsiden</a> ]</font></td> </tr> <tr> <td width=\"283\" colspan=\"2\" valign=\"top\" bgcolor=\"#000000\" bordercolor=\"#000000\"><b><font size=\"2\" face=\"Arial\" color=\"#000000\">_</font></b><font size=\"2\" face=\"Arial\" color=\"#FFFFFF\"><b>Ret i data.</b></font></td> </tr> <tr> <td width=\"70\" valign=\"top\" bgcolor=\"#ffff00\" height=\"20\"><b><font size=\"2\" face=\"Arial\" color=\"#ffff00\">_</font><font size=\"2\" face=\"Arial\" color=\"#000080\">ID-nr.</font></b></td> <td width=\"221\" valign=\"top\" bgcolor=\"#ffff00\"><b><font color=\"#FFFFFF\" size=\"2\" face=\"Arial\"> </font><font size=\"2\" face=\"Arial\" color=\"#000000\">Udfyldes automatisk.</font></b></td> </tr> <tr> <td width=\"70\" valign=\"top\" bgcolor=\"#000080\" height=\"1\"><img border=\"0\" src=\"images/1x1.gif\" width=\"1\" height=\"1\"></td> <td width=\"221\" valign=\"top\" bgcolor=\"#000080\" height=\"1\"><img border=\"0\" src=\"images/1x1.gif\" width=\"1\" height=\"1\"></td> </tr> <tr> <td width=\"70\" valign=\"top\" bgcolor=\"#ffff00\"><b><font size=\"2\" face=\"Arial\" color=\"#ffff00\">_</font></b><font size=\"2\" face=\"Arial\" color=\"#000080\"><b>Tilsend af</b></font></td> <td width=\"221\" valign=\"top\" bgcolor=\"#ffff00\"><font size=\"2\" face=\"Arial\" color=\"#000000\"><b><input type=\"text\" name=\"Navn\" size=\"25\" value=\"<%=rs(\"Navn\")%>\"></b></font></td> </tr> <tr> <td width=\"70\" valign=\"top\" bgcolor=\"#000080\" height=\"1\"><img border=\"0\" src=\"images/1x1.gif\" width=\"1\" height=\"1\"></td> <td width=\"221\" valign=\"top\" bgcolor=\"#000080\" height=\"1\"><img border=\"0\" src=\"images/1x1.gif\" width=\"1\" height=\"1\"></td> </tr> <tr> <td width=\"70\" valign=\"top\" bgcolor=\"#ffff00\"><b><font size=\"2\" face=\"Arial\" color=\"#ffff00\">_</font></b><font size=\"2\" face=\"Arial\" color=\"#000080\"><b>Vitsen</b></font></td> <td width=\"221\" valign=\"top\" bgcolor=\"#ffff00\"><font size=\"2\" face=\"Arial\" color=\"#000000\"><b><textarea rows=\"10\" name=\"Vits\" cols=\"21\"><%=rs(\"Vits\")%></textarea></b></font></td> </tr> <tr> <td width=\"70\" valign=\"top\" bgcolor=\"#000000\"><b><font size=\"2\" face=\"Arial\" color=\"#000000\">_</font></b></td> <td valign=\"top\" bgcolor=\"#000000\"> <p align=\"right\"><font size=\"1\" face=\"Arial\" color=\"#FFFFFF\">Humorsiden.dk</font></p> </td> </tr> </table> <input type=\"hidden\" name=\"dato\" value=\"<%=Now%>\"> <p><input type=\"submit\" value=\"Send\" name=\"B1\"></p> </form></center> <% conn.Close Set conn = nothing Set SQLstmt = nothing %> </body> </html>
10. august 2000 - 19:07
#2
ups forkerte fil :) her er den::: <% response.buffer = true %> <html> <head> <title>Ny side 2</title> </head> <body> <% Set Conn = Server.CreateObject(\"ADODB.Connection\") Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"../Jokes.mdb\") SQLstmt = \"UPDATE DISTINCTROW Blandet SET Navn = \" & request.form(\"Navn\") & \", dato = #\" & Now & \"#, Vits = \'\" & request.form(\"Vits\") & \"\' WHERE id = \" & Request(\"id\") SQLstmt = SQLstmt & \" VALUES (\'\" & request.form(\"Navn\") & \"\',#\" & Now & \"#,\'\" & request.form(\"Vits\") & \"\')\" response.write sqlstmt Conn.Execute (SQLstmt) conn.Close Set conn = nothing Set SQLstmt = nothing response.redirect (\"default.asp\") %> </body> </html>
10. august 2000 - 19:09
#3
SQLstmt = \"UPDATE DISTINCTROW Blandet SET Navn = \'\" & request.form(\"Navn\") & \"\', dato = #\" & Now & \"#, Vits = \'\" & request.form(\"Vits\") & \"\' WHERE id = \" & Request(\"id\")
10. august 2000 - 19:23
#4
Tak for hjælpen :) /MtM
Kurser inden for grundlæggende programmering