Pulling info for a form

Results 1 to 2 of 2

Thread: Pulling info for a form

  1. #1
    Join Date
    Dec 1969

    Default Pulling info for a form

    I have an app. that displays whether a clients job is open or closed. A cliI need to add the ability to put a job on hold and have these three options in a drop down. I pull the info from the database based upon which client is selected and then i display the jobs giving each option in the drop downs the id number relating to that job and client. How do i pull that id and what was selected from the drop down(open,close,or hold).<BR><BR>Currently i have been trying to give the option a 1,2, or 3 added on the the ID pulled from the db. Then i have been trying to seperate the two and then enter the info into the db. <BR><BR>response.write "&#060;option value=&#039;" & objRS2("id") & "2" & "&#039;&#062;Close Job&#060;/option&#062;"<BR> <BR>But it doesnt work.<BR><BR>THanks for any help or advice

  2. #2
    Gary Genaw Guest

    Default RE: Pulling info for a form

    You can use an "if then" of "case select"<BR>ie. <BR>&#060;%<BR>If objRS2("id")=2 then <BR>response.write("Close Job")<BR>end if<BR>%&#062;

Posting Permissions

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