Redirecting to another page

Results 1 to 2 of 2

Thread: Redirecting to another page

  1. #1
    Join Date
    Dec 1969
    Posts
    730

    Default Redirecting to another page

    I am using a drop-down list and want to pass the value of the list (state ID number) to another page where it will load up the information for that particular state. Can this be done?

  2. #2
    Jason Buck Guest

    Default RE: Redirecting to another page

    &#060;select name="Selstate"&#062;<BR>&#060;option value="1" selected&#062;Alabama&#060;/option&#062;<BR>&#060;option value="2" &#062;Alaska&#060;/option&#062;<BR>&#060;/select&#062;<BR>When you post this to the next page do the following.<BR><BR>&#060;% strState = request.form("Selstate") <BR><BR>then your SQL statement should look like this:<BR><BR>YOURSQL = "SELECT FIELDA, FIELDB, FIELDC FROM TABLENAME WHERE (((TABLENAME.STATEID)=&#039" & strState & "&#039));"<BR><BR>I hope this helps. Any other questions feel free to contact me.<BR><BR>Respectfully,<BR><BR>Jason<BR>webmaster @wnj.com<BR><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
  •