DB connection

strSQL = \"SELECT * FROM Messages WHERE navn = \'\" & navn & \"\' AND MessageID = \" & ID & \"\"

strSQL = \"SELECT * FROM Messages WHERE navn = \'\" & navn & \"\' AND MessageID =\" & ID

rSQL = \"SELECT * FROM Messages WHERE navn=\'\" & navn & \"\' AND MessageID=\" & ID

strSQL = \"SELECT * FROM Messages WHERE navn=\'\" & navn & \"\' AND MessageID=\" & ID

bjarke >> det kræver mere når du laver & \" igen!
så min er mest korrekt

guzzie -> Når det er tal felter skal der ikke være \' og \' uden om

bjarke >> du mener et tal felt for hvis du putter et tal ind i et tekst felt er den god nok :)

Well jeg skrev \"er tal felter\" ?

bjarke >> det er også når det er int felter :)

Textstring criterias are always defined inside
:  \'\" & text & \"\'

Numericstring criterias is equally defined
:    \" & num & \"

good luck with the qoutes...

ruderkonge >> guzzie kan godt læse dansk er bare ikke så god til at skrive det :)

hey Guys

//bjarke-b  I tried your idea but got a syntax error
//Tpiil I tried your idea and got this error
Microsoft OLE DB Provider for ODBC Drivers error \'80040e14\'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression \'navn=\'\' AND MessageID=\'.

/emne_under_emne/admin/edit_message.asp, line 11

Heres the script again I changed the script a little

the link I connect with is this
<a href=\"edit_message.asp?MessageID=<%=Rs_MainMessage(\"ID\")%>&Navn=<%=session(\"name\")%>\">

and the page I open looks like this
<!--#include file=is_this_person_logged_in_checker.inc-->

<%
navn = request.form(\"navn\")
MessageID = request.form(\"MessageID\")

Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"../emne.mdb\")
strSQL = \"SELECT * FROM Messages WHERE navn=\'\" & navn & \"\' AND MessageID=\" & MessageID

Conn.Execute (strSQL)

Set rs = conn.Execute(strSQL)
if not (rs.BOF Or rs.EOF) Then
%>
<html>

<head>
<title>Reply</title>
</head>
<LINK rel=\"stylesheet\" type=\"text/css\" href=\"styles_old.css\">
<body>

thanks
Guzzie

strSQL = \"SELECT * FROM Messages WHERE navn=\'\" & navn & \"\' AND MessageID=\" & Request(\"MessageID\")

navn = request(\"navn\")
MessageID = request(\"MessageID\")

//bjarke-b  - still got error message

havd med mit??

altså så det blev:

<%
navn = request(\"navn\")
MessageID = request(\"MessageID\")

Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"../emne.mdb\")
strSQL = \"SELECT * FROM Messages WHERE navn=\'\" & navn & \"\' AND MessageID=\" & MessageID

Conn.Execute (strSQL)

Set rs = conn.Execute(strSQL)
if not (rs.BOF Or rs.EOF) Then
%>

Har du defineret de to kriterier ?  Prøv:

Response.write navn & id

Hvis der ikke kommmer output kan den ikke finde ud af det, og du må have glemt at sende de pågældende data med...

Tpiil I am still getting error
heres the error
Microsoft OLE DB Provider for ODBC Drivers error \'80040e10\'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/emne_under_emne/admin/edit_message.asp, line 11

this is line 11
Conn.Execute (strSQL)

Guzzie

navn = request.form(\"name\")
MessageID = request.form(\"ID\")

Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"../emne.mdb\")
strSQL = \"SELECT * FROM Messages WHERE navn = \'\" & navn & \"\' AND MessageID = \'\" & ID & \"\'\"

Du definerer messageid men bruger ID som kriterie !!!

Således...

strSQL = \"SELECT * FROM Messages WHERE navn = \'\" & navn & \"\' AND MessageID = \'\" & MessageID & \"\'\"

//ruderkonge -
I tried your idea
navn = request(\"navn\")
MessageID = request(\"MessageID\")
Response.write navn & MessageID

And the correct navn and MessageID are displayed

sorry sådan

strSQL = \"SELECT * FROM Messages WHERE navn = \'\" & navn & \"\' AND MessageID = \" & MessageID

//ruderkonge
my db is like this
<%
navn = request(\"navn\")
MessageID = request(\"MessageID\")
Response.write navn & MessageID

Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"../emne.mdb\")
strSQL = \"SELECT * FROM Messages WHERE navn=\'\" & navn & \"\' AND MessageID=\" & MessageID

Conn.Execute (strSQL)

Set rs = conn.Execute(strSQL)
if not (rs.BOF Or rs.EOF) Then
%>

Hvliken fejlmelding får du nu ?

strSQL = \"SELECT * FROM Messages WHERE (navn=\'\" & navn & \"\') AND (MessageID=\" & MessageID & \")\"

Weee
Ok thanks Guys
it was a little mistake on my part the colume in my db was called ID and not MessageID !!
silly me :)
Now who gets the points or should I split them up ????? You all came with good Ideas
Guzzie

Lidt for hurtig til at svare før....:-) glemte at tænke..

Du havde jo flere fejl i din sætning :-)

hehe

Ok Have split the points up to you three
If any of you are not happy with the way I split them up then write with your comments :)
thanks again guys