View Single Post
  #3 (permalink)  
Old February 24th, 2005, 06:43 AM
crmpicco crmpicco is offline
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

         <form name="form2" method="post" action="agency_bookdates.asp">
           <input name="agencyid" type="hidden" value="<%=agencyid%>">
           <tr bordercolor="#EEEEEE" bgcolor="#006699">
             <td colspan="3"><div align="left"><strong>MacKenzie - Agency - Booking Search </strong></div></td>
           </tr>
           <tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
             <td><div align="right">Search by </div></td>
             <td><div align="left">
<%
'response.write "agencyid = " & agencyid & "<br>"
set rst1=con.execute("select * from company where company_id = '" & agencyid & "' and agencyid <> '"&agencyid&"'")
user = rst1("agencyid")
%>
<select name="searchby">

<% Do Until rst1.EOF %>
<option value="<%=trim(rst1("agencyid"))%>"><%=trim(rst1(" company_name"))%></option>
<%
rst1.movenext
loop
%>
</select>
             </div></td>
             <td>&nbsp;</td>
           </tr>
           <tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
             <td width="263"><div align="right">Display all bookings that are </div></td>
             <td colspan="2"><div align="left">
                 <input name="timeoption" type="radio" value="current" checked>
             Current (Confirmed)</div></td>
           </tr>
           <tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
             <td><div align="right"></div></td>
             <td colspan="2"><div align="left">
                 <input name="timeoption" type="radio" value="pastdate">
             Past Date </div></td>
           </tr>
               <tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
             <td><div align="right"></div></td>
             <td colspan="2"><div align="left">
                 <input name="timeoption" type="radio" value="option_bookings_only" onClick="location.href='option_agency_bookings.asp '">
             Option Bookings </div></td>
           </tr>
<% if badlogin3 = "true" then%>
<tr bordercolor="#EEEEEE" bgcolor="#EEEEEE"><td colspan="3">
<div align="center">

Sorry, No Bookings Available!

</div>
</td></tr>
<%else%>
<tr><td></td></tr>
<%end if%>



           <tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
             <td>&nbsp;</td>
             <td>&nbsp;</td>
             <td><div align="right">
                 <input name="submit" type="submit" title='Click here to search the whole table by requested criteria' onMouseOver='style.cursor="hand"' value="Submit" width="100" height="25">
             </div></td>
           </tr>
         </form>

Thats the whole form.

as you can see the action is set to go to agency_bookdates.asp on submit. which i need. but if the Option Bookings radio button is clicked i need it to go to option_agency_bookings.asp and take the value of <select name="searchby">

www.crmpicco.co.uk
Reply With Quote