Asp and Sql project.I need Help.

mat41 · August 24th, 2007, 01:56 AM

Sorry buddy it's 4.50 on a Friday, home time for me...

Run this in your browser I have placed some client side validation so your user can not proceed umless they have entered a value. Try to submit your form without entering a value to see what i mean

I would post this page to ITS SELF then:

1..based on user input ask the DB is there a record:
   a..IF SO assign the ID to a session variable and redirect the user to where ever
   b..IF NOT promt them 'sorry no details found, try again

so at the top od your page
<%
   if request.form("cid") <> "" then
       'connect to DB
       'run query see if there is a match
       'NOW ASSIGN SESSION VARIABLE
       'direct them to where you want to go
   else
       'this is the default page load
   end if
%>

Anyhow go to run, good luck

Wind is your friend
Matt

Shuchik · August 24th, 2007, 02:18 AM

thanx MAT...I'll try this...lets see :)

mat41 · August 24th, 2007, 02:46 AM

I forgot to post the page, now Im gong home - here it is:

<html>
<head>
<script>
  function validate()
  {
     if (document.formName.cid.value == "")
     {
        alert("You mut enter a name to proceed.");
        document.formName.cid.focus();
        return (false);
     }
  }
</script>
  <title></title>
</head>
<body>

<form name="formName" action="delete.asp" method="post" onsubmit="return validate();">
    <div align="center">
      <center>
    <table border="2" cellpadding="0" cellspacing="0"
style="border-collapse: collapse; text-align:center" width="40%"
bgcolor="#E1E1E1"
height="104">
      <tr>
        <td width="100%" colspan="2" bgcolor="#3163A0" height="22">
        <p align="center">

        Member Login</td>
      </tr>
      <tr>
        <td width="47%" style="text-align: left" height="20">

         Company-ID:</td>
        <td width="53%" style="text-align: left" height="20">
               <input type="text" name="cid" size="11" style="border-style: solid; border-width:1"></td>
      </tr>

      <tr>
        <td width="100%" colspan="2" height="26">
        <p align="center">
                <input type="submit" value="Sign-In" name="signin"></td>
      </tr>
      <tr>
        <td width="100%" colspan="2" height="12">
        <p align="right">
         </td>
      </tr>
    </table>
    <table border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse" bordercolor="#111111" width="100%"
id="AutoNumber5">
      <tr>
        <td width="100%"> </td>
      </tr>
      <tr>
        <td width="100%"> </td>
      </tr>

      <tr>
        <td width="100%"> </td>
      </tr>
      <tr>
        <td width="100%"> </td>
      </tr>
      <tr>
        <td width="100%"> </td>
      </tr>
      <tr>
        <td width="100%"> </td>
      </tr>
    </table>
      </center>
    </div>
    </form>
  </center>
</div>
</body>

</html>

Wind is your friend
Matt

Shuchik · August 24th, 2007, 03:00 AM

Thanx MAT!