Session varaiables - ASP / Active Server Pages

For the following code when ever i open the this page the text box has /
i ahve set the value of text box with session variables whic is exuted only when submit button is clicked....Pls Help me....

Expand|Select|Wrap|Line Numbers

 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>REGISTRATION</title>

<script language="javascript" src="validate.js" type="text/javascript"></script>

</head>

<body>

<h4><b>WELCOME TO REGISTRATION PAGE</b></h4>

<form id="registration" name="registration" method="post"  onsubmit="return ValidateForm();">

 <table width="346">
 
 <tr><br />

  <td width="338" align="Center"><h2 align="center">REGISTRATION</h2></td>

 </tr> 

  <tr>

     <td width="338" align="center" nowrap="nowrap"><h4 align="left">User Name:

          <input name="txtuname" type="text" value=<%=session("username")%> /> <h4 align="left">First Name:

                    <input name="txtfname" type="text" value=<%=session("fname")%> />

     </h4></td>

 </tr>
 
  <tr>

     <td width="338" align="center"><h4 align="left">Last Name:   

          <input name="txtlname" type="text" value=<%=session("lname")%> />     

     </h4></td>

 </tr>
 
 <tr>

     <td align="center" ><h4 align="left">Password:     

          <input name="txtpassword" type="password" value=<%=session("password")%> />     

     </h4></td>

 </tr>
 
  <tr>

     <td align="center"><h4 align="left">EMAIL ID:    

          <input name="txtemail"  type="text" value=<%=session("mail")%> />     

     </h4></td>

 </tr>
 
  <tr>

     <td align="center"><h4 align="left">Phone No:    

          <input name="txtphno" type="text" value=<%=session("phno")%> />     

     </h4></td>

 </tr>
 
   <tr>

     <td align="center"><h4 align="left">Mobile No:    

          <input name="txtmno" type="text" value=<%=session("mno")%> />     

     </h4></td>

 </tr>
 
  <tr>

     <td align="center"><h4 align="left">Address:                       

       <textarea name="txtadd1" wrap="physical" value=<%=session("add1")%>></textarea>

     </h4></td>

 </tr>

 <% response.Write(session("mail"))%>

 <tr>

     <td align="center"><h4 align="left">Address2:    

          <textarea name="txtadd2" value=<%=session("add2")%>></textarea>     

     </h4></td>

 </tr>
 
 <tr>

     <td align="center"><h4 align="left">City:    

          <input name="txtcity" type="text" value=<%=session("city")%>/>     

     </h4></td>

 </tr><tr>

     <td align="center"><h4 align="left">State:    

          <input name="txtstate" type="text" value=<%=session("state")%> />     

     </h4></td>

 </tr>
 
 <tr>

     <td align="center"><h4 align="left">Country:    

          <input name="txtcountry" type="text" value=<%=session("country")%> />     

     </h4></td>

 </tr>
 
 <tr>

     <td align="center"><h4 align="left">Zip code:    

          <input name="txtzip" type="text" value="<%=session("zip")%>" />     

     </h4></td>

 </tr>
 
 <tr><br />

     <td align="center"><input name="btnsubmit" type="submit" id="btnsubmit" value="Submit" />

      <input type="reset" />     </td>

 </tr>     

</table>

</form>
 
</body>

</html>

<%
 
if(request.form("btnsubmit")<>"") then

mail=request.form("txtemail")

id=request.form("txtuname")
 
set conn=server.CreateObject("ADODB.connection")

conn.Mode = 3

ConnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=Rajesh;Port=3306;DATABASE=agstc2008;UID=root;PWD=sa;character set=utf8;"

conn.open ConnString

set rs=server.CreateObject("ADODB.recordset")

query="select * from tbluser"

Set rs = conn.execute(query)

no=2      
 
while not RS.EOF
 
if rs("userEmailId")=mail OR rs("userId")=id THEN

    Response.Write("EMAIL ID/USER ID ALREADY EXISTS")

     session("username")=request.form("txtuname")

    session("password")=request.form("txtpassword")

    session("fname")=request.form("txtfname")

    session("lname")=request.form("txtlname")

    session("email")=request.form("txtemail")

    session("phno")=request.form("txtphno")

    session("mno")=request.form("txtmno")

    session("add1")=request.form("txtadd1")

    session("add2")=request.form("txtadd2")

    session("city")=request.form("txtcity")

    session("state")=request.form("txtstate")

    session("country")=request.form("txtcountry")

    session("zip")=request.form("txtzip")

    no=1

    end if

rs.movenext

wend

if(no=2) then

    session("username")=request.form("txtuname")

    session("password")=request.form("txtpassword")

    session("fname")=request.form("txtfname")

    session("lname")=request.form("txtlname")

    session("email")=request.form("txtemail")

    session("phno")=request.form("txtphno")

    session("mno")=request.form("txtmno")

    session("add1")=request.form("txtadd1")

    session("add2")=request.form("txtadd2")

    session("city")=request.form("txtcity")

    session("state")=request.form("txtstate")

    session("country")=request.form("txtcountry")

    session("zip")=request.form("txtzip")

    response.Redirect("lsucess.asp")

end if
 
rs.close

conn.close

end if

%>

Nov 6 '08 #1

Subscribe Post Reply

2011

DrBunchman

979

Expert 512MB

Hi gowthamkg,

Which text box has the problem?

Dr B

Nov 6 '08 #2

gowthamkg

Hi gowthamkg,

Which text box has the problem?

Dr B

Every text box shows "/" whene ever i load this page...and password text box it is "."

Nov 6 '08 #3

DrBunchman

979

Expert 512MB

Could you try putting some single quotes around the value property of your inputs, like this:

Expand|Select|Wrap|Line Numbers

<input name="txtfname" type="text" value='<%=session("fname")%>' />

I wonder if perhaps the interpreter is picking up the closing / of the input tag as part of the value. Probably not the problem but worth giving it a try!

Let me know how what happens,

Dr B

Nov 6 '08 #4

gowthamkg

ITS gone..but another problem is that..once i click the submit it should check the database whether email id is present or not if so it should display EMAIL ID/USER ID ALREADY EXISTS and it should keep the same entered data's in the form...pls help me...

Nov 6 '08 #5

DrBunchman

979

Expert 512MB

Is it displaying that text?

I think the problem here might be the condition where you say If (no=2) Then...

As far as I can see you have set the variable no to equal 2 no matter what happens.

Dr B

Nov 6 '08 #6

gowthamkg

ya i have set the no =2 default...because if there is only mail id is present it will change to 1 or else it will be directed to a page where it is inserted..

Nov 6 '08 #7

DrBunchman

979

Expert 512MB

Okay, I see what you are doing.

So does that text never display even when there is a mail id present?

Dr B

Nov 6 '08 #8

Similar topics

Passing SESSION Data

by: Paul | last post by:

Hmmm, didn't seem to work. I have set session.use_cookies = 1 and session.use_trans_sid = 1 in my php.ini file. Index.php contains:...

PHP

Session varaibles limit

by: Danny Ni | last post by:

Hi, Are there limits ( as in the size of each variable, number of varaiables, over all size) to session variables? TIA

ASP / Active Server Pages

Weird problem with an ASP.NET application and Session Variables that mess up

by: M. Simioni | last post by:

Hi, the webserver is a HP ProLiant DL380 G3 1GB RAM Dual U320 SCSI COMPAQ Smart Array 5i + Battery Pack installed N°2 (RAID 1) COMPAQ BD072863B2 - 72.8GB Ultra320, 10K Hot-pluggable, 1"...

ASP.NET

custom user session handler + PHPSESSID in cookie

by: joseph conrad | last post by:

Hi, I tried to implement my own session handler in order to keep control on the process the drawback I foun it is not creating and storing in my cookie the PHPSESSID variable anymore. reading te...

PHP

Session variable trouble

by: aroraamit81 | last post by:

Hi, I am facing a trouble. I have some Session variables in my code and somehow my session variables are getting mixed up with other users. For example User A has access to 10 companies and...

ASP.NET

Session Conflict

by: aroraamit81 | last post by:

Well Guys, Here is a very strange trouble. When more than one users request tto same page at the same time then our session gets conflicted. Moreover I printed my SessionID, strangely but true I...

ASP.NET

Retrive data from session variables

by: Santosh | last post by:

Dear All i am writting a code sending mail with attachement. i am writting code for sending mail in one page and code for attaching a file in the next page. aftet attaching a file i am taking...

ASP.NET

Handling session destroy and logout issue. How to handle ?

by: somaskarthic | last post by:

Hi This is somas here. I asked query about detecting the browser close event using javascript. I want to detect the event only when the X button in the top right corner is clicked and not else...

PHP

session issues

by: lyealain | last post by:

<% If Session("username") = "" Then Response.Redirect("/CLS/Login.asp") End If Dim conn Dim connectstr Dim db_name, db_username, db_userpassword Dim db_server Dim res

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing