I a have a page is which is fulfil by user and given a login name as the login is unique so if the login is already there then there is error and must back to give another login but how I can store other information



<%



     strSQL = "SELECT * FROM Employee WHERE LoginID ='" & request("login") & "' "
    set objRS2 = objDataConn.execute(strSQL)
    if not objRS2.eof then

    [u]page = "AddEmp.asp?Login=" & request("login") & "name=" & request("name")
    Response.Redirect(Page)</u>

    else
     strSQL2 = "Insert into Employee(LoginId,Password, Name , FatherName, NIC, Tlelephone, Mobile , Email, Address, Department, Designation, Salery, IsAdmin ) values ('" & request("Login") & "','" & request("Password") & "', '" & request("name") & "', '" & request("fname") & "', '" & request("nic") & "', '" & request("Tele") & "', '" & request("Mob") & "', '" & request("email") & "', '" & request("Address") & "', '" & request("Department") & "','" & request("Designation") & "', '" & request("Salery") & "' ,'" & request("IsAdmin") & "')"
     set objRS2 = objDataConn.execute(strSQL2)
     end if




Response.Redirect("Admin.asp")

    %>
the underline are not given the feild of name.
Is there any other solution or wat
Please send me immediately
Already thanks for your coopration


Love 4 all

__________________
(*_*)

Numan
--------------------------------------------------
It is not important what you get But important is&nbsp;&nbsp;how you got it

A change in the page structure is needed.

You have a registration page which checks the details of the visitor submitted through a page say - registration.asp. Let that page be registrationFB.asp. i.e. registration.asp collects the visitor details initially and submits to registrationFB.asp

You have a page which will be shown after successful registration. Let that page be welcome.asp

The form on registrationFB.asp should submit to the same page. The code structure in registrationFB.asp is as follows.

' Collect the posted values from registration.asp in variables

' The validation script

' Initialize a variable strErrorMessage as an empty string. (strErrorMessage="")

' check whether fields are empty.

' check whether login exists.

' after each validation check you need to concatenate the error message to the variable strErrorMessage.

' if(strErrorMessage="") then

' show the error message

' show the form. In the form show the values. You can get the values from the variables into which you stored them at the beginning of the page. Please remember that this form gets submitted to registrationFb.asp.

' else

' go to welcome.asp

' end if

Are you trying to pass both the login and the name field to AddEmp.asp?

If so, you should add an & before the name, so it is passed as a valid QueryString parameter....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Legs (Graham Massey Mix) by Art Of Noise (Track 9 from the album: The Fon Mixes) What's This?