request.querystring("datum") är tom.
kontrollera det...
------------------
<A HREF="http://cartman.nu" TARGET=_blank>
nobody expects the spanish inquisition!</A>
Frågan#1
Jag håller på att regigera i en databas, men hela tiden får jag detta meddelnade
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID ='.
/kompis/redigera/redigera1.asp, line 10
koden för sidan ser ut så här:
<html>
<!-- #include virtual="/databas/adovbs.inc" -->
<% Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=c:\inetpub\wwwroot\databas\adressbok.mdb"
Set RecSet = Server.CreateObject("ADODB.Recordset")
Visa = "SELECT * FROM radannonser WHERE ID = " & Trim(Request.QueryString("Datum")) & " "
RecSet.Open Visa, Connect, adOpenStatic, adLockOptimistic %>
<form method="POST" action="redigera2.asp">
<input type="hidden" name="Datum" value="<% =Request.QueryString("Datum") %>">
<input type="text" size="30" name="kategori" value="<% =RecSet("Kategori") %>"><br>
<input type="text" size="30" name="rubrik" value="<% =RecSet("Rubrik") %>"><p>
<input type="text" size="30" name="annonstext" value="<% =RecSet("Annonstext") %>"><p>
<input type="text" size="30" name="namn" value="<% =RecSet("Namn") %>"><br>
<input type="text" size="30" name="telefon" value="<% =RecSet("Telefon") %>"><p>
<input type="text" size="30" name="epost" value="<% =RecSet("Epost") %>"><p>
<input type="submit" value="Uppdatera">
</form>
<% RecSet.Close
Connect.Close %>
<p><a href="default.asp">Redigera annan post!</a>
</html>
------------------
Mvh Martin Persson
Costodia.com, martinpersson.com, Merinternet.com , Sveriges.com , Sigill.net , dress.nu , mittinternet.com