Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 29th, 2005, 08:19 AM
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 run database query when drop-down is selected

I have this code in a ASP page:

Code:
<%
set rsregion=con.execute("SELECT DISTINCT Geog_loc FROM `dbo_tp_country` where Geog_loc IS NOT NULL order by Geog_loc asc")
set rsregion2=con.execute("SELECT DISTINCT Geog_loc,area,CountryCode FROM `dbo_tp_country` where Geog_loc IS NOT NULL order by CountryCode asc")
%>

<select name="region" style="font-size:9px" onChange="<%bRunMySQL=true%>">
<%
if not rsregion.eof then
while not rsregion.eof
%>
<option value="<%=rsregion2("CountryCode")%>" id="region<%=r%>"><%=rsregion("Geog_loc")%>
<%
r=r+1
rsregion.movenext
wend
end if
rsregion.close
set rsregion=nothing
%>
</select>

<%
if bRunMySQL then
set rstest=con.execute("select * from dbo_tp_city")
response.Write "select * from dbo_tp_city"
end if
%>
When the drop-down is selected I need to run another MySQL query to produce the drop-down
values for another drop-down.

How can i do this, as you can see i have attempted this with setting the boolean vaue bRunMySQL.

Any ideas?

TIA.

Picco

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt
__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk
Reply With Quote
  #2 (permalink)  
Old July 29th, 2005, 10:03 AM
Registered User
Points: 1,897, Level: 17
Points: 1,897, Level: 17 Points: 1,897, Level: 17 Points: 1,897, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
Send a message via Yahoo to rupen
Default

Hi Picco,

I have been banging my head on wall to solve this prob, what i can say is that this is a sort of limitation of ASP, as it runs on serverside and values in combo is fill at client side, through reasearch of 1 month i found a link:
----------------
http://www.tek-tips.com/faqs.cfm?fid=3978
----------------
But i can't solve this one.

I can fill them with javascript array but i don't prefer this(although i have code for this).
If you come to solve this plea let me know on this forum.
All the best!!!



W

Rupen Anjaria.
We CAN'T avoid problems, but of course can solve it.
Reply With Quote
  #3 (permalink)  
Old July 31st, 2005, 03:46 AM
Registered User
 
Join Date: Jul 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey,

You can run a JavaScript so that when the first drop-down list changes it
reloades the page with for example (page.asp?code=123) where the code is the country code
selected. Or you can do that but using POST.

Reply With Quote
  #4 (permalink)  
Old August 9th, 2005, 10:16 AM
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

Code:
<% ' Last Edit: CRM_08aug05 %>

<%
Response.Buffer =true
on error resume next
''''''''''''''''''''''''''''''''''''''''
' destination.asp
''''''''''''''''''''''''''''''''''''''''
' Allow user to select the Airport 
' code from thrre drop-down menus
' Region, Country, City
'''''''''''''''''''''''''''''''''''''''''
companyid = Session("companyid")
'response.Write "companyid = " & companyid & "<br>"
Dim r
r=0

setLocale(2057) '... set the Local Settings to English - United Kingdom
%>
<HTML>
<HEAD>
<META NAME="Owner" CONTENT="crmpicco">
<META NAME="Copyright" CONTENT="crmpicco">
<META NAME="Author" CONTENT="crmpicco">
<title>Destination Search</title>

<style TYPE="text/css">

A:link{    COLOR: ;    TEXT-DECORATION: none}
A:visited{    COLOR: ;    TEXT-DECORATION: none}
A:hover{    COLOR: ;    TEXT-DECORATION: none}

</style>

</HEAD>

<body bgcolor="#f5f5f5" leftmargin="0"  rightmargin="0"  topmargin="0"  bottommargin="0">
<br>
<form name="form" id="form" method="post" action="destination2.asp">
<%
set rsregion=con.execute("SELECT DISTINCT Geog_loc FROM `dbo_tp_country` where Geog_loc IS NOT NULL order by Geog_loc asc")
%>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">

    <tr>
      <td width="16"><img src="images/top_lefbb.gif" width="16" height="16"></td>
      <td height="16" background="images/top_midbb.gif"><img src="images/top_midbb.gif" width="16" height="16"></td>
      <td width="24"><img src="images/top_rigbb.gif" width="24" height="16"></td>
    </tr>
    <tr>
      <td width="16" background="images/cen_lef.gif"><img src="images/cen_lef.gif" width="16" height="11"></td>
      <td align="center" valign="middle" bgcolor="#FFFFFF">

<table width="100%" align="center" border="1" bordercolor="#000000">
<tr bgcolor="#006699" bordercolor="#000000">
<td colspan="10" bgcolor="#006699" bordercolor="#000000">
<b>Destination Search</b>
</td>
</tr>
<tr bordercolor="#ffffff"><td>&nbsp;</td></tr>
<tr bordercolor="#ffffff">
<td align="center">

Region:

</td>
<td colspan="2" align="left">

<select name="region" style="font-size:9px" onChange="form.submit()">
<option value="empty"> </option>
<%
if not rsregion.eof then
while not rsregion.eof
if rsregion("Geog_loc") <> "Africa - Gulf of Guinea" AND rsregion("Geog_loc") <> "Africa - Mozambique Channel" AND rsregion("Geog_loc") <> "Asia - Arabian Sea" AND rsregion("Geog_loc") <> "Asia - Commonwealth of Independent States" AND rsregion("Geog_loc") <> "Europe - Commonwealth of Independent States" AND rsregion("Geog_loc") <> "North America - Atlantic Ocean" AND rsregion("Geog_loc") <> "North America - North Atlantic Ocean" then
%>
<option value="<%=rsregion("Geog_loc")%>" id="region<%=r%>"><%=rsregion("Geog_loc")%></option>
<%
end if
r=r+1
rsregion.movenext
wend
end if
rsregion.close
set rsregion=nothing
%>
</select>
</td>
</tr>
<%
'if bRunMySQL then
'set rstest=con.execute("select * from dbo_tp_city")
'response.Write ("select * from dbo_tp_city")
'end if
%>
<tr bordercolor="#ffffff">
<td align="center" >Country:</td>
<td align="left">
<div onMouseOver="style.cursor='hand'">
<select name="country" style="font-size:9px " disabled title="Please Select a Region">
<option value="0"> </option>
</select>
</div>
</td>
</tr>

<tr bordercolor="#ffffff">
<td align="center">City:</td>
<td align="left">
<div onMouseOver="style.cursor='hand'">
<select name="city" style="font-size:9px " disabled  title="Please Select a Region">
<option value="0"> </option>
</select>
</div>
</td>
</tr>
<tr bordercolor="#ffffff"><td>&nbsp;</td></tr>
</table>


</td>
      <td width="24" background="images/cen_rigbb.gif"><img src="images/cen_rigbb.gif" width="24" height="11"></td>
    </tr>
    <tr>
      <td width="16" height="16"><img src="images/bot_lefbb.gif" width="16" height="16"></td>
      <td height="16" background="images/bot_midbb.gif"><img src="images/bot_midbb.gif"  height="16"></td>
      <td width="24" height="16"><img src="images/bot_rigbb.gif" width="24" height="16"></td>
    </tr>

</table>
</td></tr>
<div align="center">
<br>
<table width="75">
<tr>
<td height="20" bordercolor="#000000" align="center" bgcolor="#006699" onClick="window.close();"
onMouseOver="this.bgColor = '#C0C0C0'; this.style.color='#000000'; style.cursor='hand';window.status='';" 
    onMouseOut="this.bgColor = '#006699'; this.style.color='#FFFFFF';window.status='';">

        Close

    </td>
    </tr>
    </table>
  </div>

<input type="hidden" name="onlycity" value="true">
<input type="hidden" name="paste" value="<%=request("paste")%>">
</form>
</BODY> 
</HTML>
www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt
Reply With Quote
  #5 (permalink)  
Old August 9th, 2005, 12:28 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: delhi, delhi, India.
Posts: 553
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to vinod_yadav1919 Send a message via Yahoo to vinod_yadav1919
Default

Crmpicco!!
Can we use the same thing
with
http://p2p.wrox.com/topic.asp?TOPIC_ID=31530


Cheers :)

vinod
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a drop down list in a query carbon052 Access 3 March 19th, 2008 11:53 AM
No Database selected... jimboroberts BOOK: Professional Search Engine Optimization with PHP: A Dev's Guide to SEO ISBN: 978-0-470-10092-9 0 June 25th, 2007 03:12 AM
two frame - how to run selected url in other fram BrendonMelville HTML Code Clinic 1 March 14th, 2006 03:58 PM
drop down box selected value crmpicco HTML Code Clinic 1 March 31st, 2005 09:56 AM



All times are GMT -4. The time now is 05:40 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.