Tjek om post findes i db

Fandt selv svaret http://www.eksperten.dk/spm/336097

Ja det er, her er et eksempel.

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("db.mdb")
Conn.Open DSN

SQL = "Select * From koeb WHERE e-mail='" & Request.Form("Email") & "'"
Set rs = Conn.Execute(SQL)

If NOT (rs.BOF OR rs.EOF) Then
Response.Redirect "nextpage.asp"
Else
Response.Write "En Fejlmeddelse..."
End IF

Conn.Close
Set Conn = Nothing
%>