Fill Fields

Results 1 to 2 of 2

Thread: Fill Fields

  1. #1
    Chris McDaniel Guest

    Default Fill Fields

    I would like to fill the fields in a form based on an ID already in the database. The user types 12345 in a text field and hits submit, then all of the appropriate fields are filled for that record. My SQL stmt. works fine, but I am not sure how to reference the text field where the user enters the unique number. <BR><BR>Any help is much appreciated. Thanks.

  2. #2
    Swanand Mokashi Guest

    Default RE: Fill Fields

    on th form page :<BR><BR>&#060;form name="form1" method="post" action="databasePage.asp"&#062;<BR>&#060;input type="text" name="someID"&#062;<BR>&#060;/form&#062;<BR><BR>on the databasePage.asp where the Query works :<BR><BR><BR>&#060;%someID=request.form("someID")< BR>&#039Now use ur query<BR>strQuery="select * from yourTable where urID=" & someID<BR>%&#062;<BR><BR><BR>Hope this helps<BR>

Posting Permissions

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