Database

Results 1 to 3 of 3

Thread: Database

  1. #1
    T.Nagaraj Guest

    Default Database

    Sir,<BR>In one of asp page, i have 3 fields("emp_code","emp_name","salary") where "emp_code" is the primary key of emp table. Here "emp_code" is a list box which contains a list of emp_codes from emp table.<BR>My requirement:<BR>When i select a particular emp_code from the list box, the corresponding information should be automatically displayed in the remaining 2 fields from the database.<BR>For Ex: when i select "1002" as emp_code, "suresh" should be emp_name and "8000" should be his salary.<BR>I will be very thankful for you, if you provide solution for this problem.<BR>Thanking you in advance,<BR>T.Nagaraj

  2. #2
    Brad Foust Guest

    Default RE: Database

    Check out this article here on 4guys<BR><BR>http://www.4guysfromrolla.com/webtech/061399-1.shtml<BR><BR>That should get you started.<BR><BR>--brad

  3. #3
    Join Date
    Dec 1969
    Posts
    196

    Default RE: Database

    Try submitting the page to itself. I use this sometimes to cut down on the number of pages.<BR>Example:<BR>Sub cboName_OnChange<BR> frmName.submit()<BR> resub = True &#039Set a flag<BR>End Sub<BR>after resubmitting write the SQL to fill the rest of the form<BR>If resub = True then<BR> SQL = Select...<BR>Good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •