Results 1 to 3 of 3

Thread: Filling a form

  1. #1

    Thread Starter
    Hyperactive Member parkes's Avatar
    Join Date
    Jan 1999
    Location
    Unitied Kingdom
    Posts
    303
    I'm using ASP.

    I've got a form with a drop down list at the top from which you can select one option only. This works fine, but what I need to be able to do, is once I've selected an option is to read a database and fill in the rest of the fields on the same page.

    Help how is this done as I'm failry new to the ASP side of things
    Thanks in advance for any help provided.

    VB 6 Enterprise Edition SP4
    ADO, SQL 7/2000, ASP and some JavaScript


    >> Life goes on, but for how long? <<
    If you can smile when things go wrong, you have someone in mind to blame

  2. #2
    Member
    Join Date
    Aug 2000
    Location
    Florida
    Posts
    45

    Filling a form from database

    see
    http://www.asp101.com/samples/form_to_db.asp

    Many other great samples here.
    If I could only remember my name...

  3. #3
    Frenzied Member monte96's Avatar
    Join Date
    Sep 2000
    Location
    Somewhere in AZ
    Posts
    1,379
    Unless you have all possible values loaded into client side arrays, you will need to pass the selected value back to the page as a querystring and populate the recordset only if the querystring is passed.
    I would then say throw it into an array using the GetRows method of the recordset and populate the fields using the array.
    You'd probably want to either set a flag indicating that a selection has been made or check array bounds so your code doesn't try to access the array when it is empty(On the initial page load)

    oOOo--oOOo
    __/\/\onte96
    oOOo--oOOo
    Senior Programmer/Analyst
    MCP
    monte96_@hotmail.com
    monte96@vbgarage.com


    Your results may vary.. some restrictions may apply.. pricing and participation may vary.. not available in all states.. professional driver closed course..quantities limited..

Posting Permissions

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



Click Here to Expand Forum to Full Width