rs.MoveNext loops the page
Ok, i am very unfamiliar with ASP but the problem i am having is that the page loops itself. I.E. it goes from header to footer and then loops another 10 times. I believe it is "because of rs.movenext" or "because the OPEN DB CONN is inside the page loop". PLEASE help if you see anything that is a simple fix.
<%
email= Session("Email")
' OPEN DATABASE CONNECTION
Set Conn = Server.CreateObject("ADODB.Connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sql2.reinventinc.com;UID=re9165;PWD=sys709; DATABASE=jobspath"
' Open Recordset
Set RS = Server.CreateObject( "ADODB.Recordset" )
RS.CursorType = adOpenStatic
mySQL= "SELECT * FROM jregister where email = '" & email & "'"
RS.Open mySQL, Conn
while NOT rs.eof
%>
<html>
<head>
<title>JOBSPATH.COM</TITLE>
<meta name="Author" content="Jobspath" />
<meta name="GENERATOR" content="Jobspath" />
<meta name="TITLE" value="Jobspath.com"/>
<meta name="alias" content="http://www.jobspath.com/">
<meta name="DESCRIPTION" content="The Jobspath.com web page, entry point to information about Jobspath.com products and services"/>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<link href="style.css" rel="stylesheet" type="text/css">
<body link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" MARGINHEIGHT="0" MARGINWIDTH="0" LEFTMARGIN="0" TOPMARGIN="0">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<div align="center">
<table class="table_body">
<tr>
<td id="center_columnreg" align="center">
<div class="mod_title">Resume Update</div>
<div id="update_resume">
<div class="mod_textbox1">
<form name="form1" method="post" action="jregister1.asp">
<br />
First name
<input name="rfname" type="text" id="rfname" value="<%=RS( "rfname" )%>" size="25" class="name">
Last name
<input name="rlname" type="text" id="rlname" value="<%=RS( "rlname" )%>" size="25" class="last">
<br />
E-mail
<input name="email" type="text" id="email" value="<%=RS( "email" )%>" size="25" class="email">
Password
<input name="password" type="text" id="password" size="25" class="password">
<br /><br />Address
<input name="address" type="text" id="address" value="<%=RS( "address" )%>" size="70" class="address">
<br />City
  ; <input name="city" type="text" id="city" value="<%=RS( "city" )%>" size="25" class="city">
State
<input name="state" type="text" id="state" value="<%=RS( "state" )%>" size="19" class="state">
ZIP
<input name="zip" type="text" id="zip" value="<%=RS( "zip" )%>" size="3" class="zip">
<br /><br />Phone
<input name="hphone" type="text" id="hphone" value="<%=RS( "hphone" )%>" size="25" class="homephone">
Work Phone
<input name="wphone" type="text" id="wphone" value="<%=RS( "wphone" )%>" size="25" class="workphone">
<br />
<br />
Visa Status
<br />
<INPUT NAME="visa" class="textbox" TYPE=RADIO value="Yes, I am a U.S. citizen or Green Card holder.">
Yes, I am a U.S. citizen/Green Card holder.<br>
<INPUT NAME="visa" class="textbox" TYPE=RADIO value="Yes, I have a permit to work in the U.S.">
Yes, I have a permit to work in the U.S.<br>
<INPUT NAME="visa" class="textbox" TYPE=RADIO value="No, I require sponsorship to work in the U.S.">
No, I require sponsorship to work in the U.S. <br /><br />
Available to start
<input name="available" type="text" value="<%=RS( "available" )%>" id="available" size="25" class="avaib_start">
<br/>
Main Job Category
<textarea name="objective" cols="51" rows="3" wrap="VIRTUAL" id="objective" class="objective">value="<%=RS( "objective" )%>"</textarea>
Objective
<textarea name="workexp" cols="51" rows="5" wrap="VIRTUAL" id="workexp" class="workexp">value="<%=RS( "workexp" )%>"</textarea>
Work Experience
<textarea name="education" cols="51" rows="5" wrap="VIRTUAL" id="education" class="educatoin">value="<%=RS( "education" )%>"</textarea>
Education
<textarea name="other" cols="51" rows="5" wrap="VIRTUAL" id="other" class="other">value="<%=RS( "other" )%>"</textarea>
Other
<br><br />
Preferred work locations
<input name="rjpwa" type="text" id="rjpwa" value="<%=RS( "rjpwa" )%>" size="25" class="pref_loc">
how to contact
<input name="contact" type="text" id="contact" size="20" class="to_contact">
<div align="center">
<input type="submit" name="Submit" value="Update" class="jregister_submit">
<input type="reset" name="Submit2" value="Clear" class="jobseek_submit">
</div>
</form>
</div>
</div>
</td>
</tr>
</table>
</div>
</td>
</tr>
<td></td>
</table>
</body>
</html>
<%
rs.movenext1
wend
RS.Close
Conn.Close
Set Conn = Nothing
%>
|