Welcome to WebmasterWorld Guest from

Forum Moderators: ocean10000

Message Too Old, No Replies

Help, can't get this asp page to show - what's wrong?



11:40 pm on May 7, 2004 (gmt 0)

10+ Year Member

<% Option Explicit %>

Dim DATA_PATH, objDC, objRS, email, password, sendmail
'Maps to database. Change to your database path.
' Create and establish data connection
Set objDC = Server.CreateObject("ADODB.Connection")
objDC.ConnectionTimeout = 15
objDC.CommandTimeout = 30
objDC.Open "DBQ=" & DATA_PATH & ";Driver={Microsoft Access Driver (*.mdb)}; DriverId=25;MaxBufferSize=8192;Threads=20;", "admin", "password"
Set objRS = Server.CreateObject("ADODB.Recordset")
'you may need to adjust this to suit your database
objRS.Open "SELECT * FROM my_users WHERE email = '" & email & "'", objDC, 0, 1

<title>Forgotten Password</title>

'checks if email address exists in the database before sending a message.
if objrs.EOF then
<B><font color="red">
There is no account for <%=email%>.
<% Else %>

'sets variables
email = request.form("email")
'chooses email and password from database that correspond to submitted email address.
email = objrs.Fields("email")
password = objrs.Fields("password")
Set sendmail = Server.CreateObject("CDO.NewMail")
'put the webmaster address here
sendmail.From = "webmaster@itradeplus.com"
'The mail is sent to the address entered in the previous page.
sendmail.To = email
'Enter the subject of your mail here
sendmail.Subject = "The Login Information You Requested"
'This is the content of thr message.
sendmail.Body = "The login Information you requested." & vbCrlf & vbCrlf _
& "email=" & email & vbCrlf _
& "Password=" & password & vbCrlf
'this sets mail priority.... 0=low 1=normal 2=high
sendmail.Importance = 2

Your login information has been mailed to <%=email%>.<br>
You should receive it shortly.
' Close Data Access Objects and free DB variables
Set objRS = Nothing
Set objDC = Nothing
Set sendmail = Nothing
%><%end if%></html>


3:11 pm on May 9, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

Shouldn't be too much of a problem, but you don't have <body> tags.



2:09 pm on May 11, 2004 (gmt 0)

10+ Year Member

use this procedure to get a detailed error message instead of a standard http 500 error:


write back once you find the error message


5:42 pm on May 11, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

You can also turn off "Show Friendly HTTP Error Messages".



Featured Threads

Hot Threads This Week

Hot Threads This Month