Retain values in controls.

rupen · July 29th, 2005, 05:02 AM

Which is the best method to program a form which has some database validations e.g. employee id should be unique, and after validationg empid the form should retain other values.
In my case form dosen't retains other values entered in form.

Rupen Anjaria.
We CAN'T avoid problems, but of course can solve it.

vinod_yadav1919 · August 6th, 2005, 10:03 AM

Hii Rupen!!,
For this u need to user

<input type=text name=username value='<%=request("username")%>'>

and form must be post back to itself,

Cheers :)

vinod

rupen · August 6th, 2005, 09:47 PM

Hi Vinod,

If that form posts back to itself, then where to put DB validation?

I will be thank full if you can give me idea of a complete form, viz. Adding new record, modification to them, checking from db.

Rupen Anjaria.
We CAN'T avoid problems, but can solve it.

vinod_yadav1919 · August 7th, 2005, 11:41 AM

Hii Rupen !!
sure i will try to explain it

suppose that u have a login form (say login.asp ),when user enters the form details(like first name,last name,age,location,password,username).It check whether username is already created by different user<-this requires database check.
If the userName is already exists then you want to give alert for username already exists.
this time you dont want to lost all the details of (name,age,location)

*******login.asp page**********
<script>
     var jsVariable; //this hold whether the form is alerady posted or not
  jsVariable=0;
function callCheck()
{
if(jsVariable==1)
{
  alert("UserName is already Existed");
   //if you want to clear the usrname text box value then uncomment below line
    // document.myform.username.value=" ";

     document.myform.username.select();
      document.myform.username.focus();
}
}
</script>
<% if request("isposted")="1" then
     //database checkup for userid already exists ,here is ur sql stmt,recordset check on dB part
      //if dB part is success then set value of databasecheckup="success"

    if(databasecheckup=="success") then
     //store the username in session
     //move to the next page ,which is basicall after the userid has been created
     //you can use server.transfer, response.redirect as per your requirement
     end if

  end if%>

<body onload="callCheck()">
<form name="myform" action="login.asp" method=post>
UserName<input type="text" name="username" value='<%=request("username")%>' > <br>
FirstName<input type="text" name="firstname" value='<%=request("firstname")%>' > <br>
LastName<input type="text" name="lastname" value='<%=request("lastname")%>' > <br>
Address<input type="text" name="address" value='<%=request("address")%>' > <br>
<input type=hidden name="isposted" value="1">
</form>

<%
if reqest("isposted")="1" and databasecheckup<>"success" then
     %>
<script>
   jsVariable=1;
</script>

   <%
end if
%>

</body>

hope this will help you .

Cheers :)

vinod