|
 |
asp_databases thread: Filters
Message #1 by "Matthew Lohr" <mlohr@t...> on Thu, 13 Apr 2000 16:11:33 -0400
|
|
I am trying to write a script that has two select fields. I want the data
in the second field sorted by whats in the first field. An example would be
if my first select field would be leagues and my second select field is
teams. When I select my league then I want to dynamically update the team
select field. I found an example of doing this when the data is in a text
file but have been unable to do this with a database.
Message #2 by "Shawn Steward" <ssteward@a...> on Mon, 17 Apr 2000 22:28:17
|
|
Are you talking about 2 HTML <select> fields? Like drop down boxes? I'm
sure I could show you how to do what you want if you could be a little more
specific... let me know...
shawn
On 04/14/00, ""Matthew Lohr" wrote:
> I am trying to write a script that has two select fields. I want the data
> in the second field sorted by whats in the first field. An example would be
> if my first select field would be leagues and my second select field is
> teams. When I select my league then I want to dynamically update the team
> select field. I found an example of doing this when the data is in a text
> file but have been unable to do this with a database.
Message #3 by "Matthew Lohr" <mlohr@t...> on Tue, 18 Apr 2000 08:01:36 -0400
|
|
Yes that is exactly what I am talking about. Two select fields one with
league information and one with team information and depending on what
league I select then I only see the teams in that league as options for the
team select list
-----Original Message-----
From: Shawn Steward
Sent: Monday, April 17, 2000 10:28 PM
To: ASP Databases
Subject: [asp_databases] Re: Filters
Are you talking about 2 HTML <select> fields? Like drop down boxes? I'm
sure I could show you how to do what you want if you could be a little more
specific... let me know...
shawn
On 04/14/00, ""Matthew Lohr" wrote:
> I am trying to write a script that has two select fields. I want the data
> in the second field sorted by whats in the first field. An example would
be
> if my first select field would be leagues and my second select field is
> teams. When I select my league then I want to dynamically update the team
> select field. I found an example of doing this when the data is in a text
> file but have been unable to do this with a database.
---
You are currently subscribed to asp_databases
Message #4 by "William Milne" <wmilne01@e...> on Tue, 18 Apr 2000 13:47:24
|
|
Matthew. There is an excellent article at http://www.asptoday.com/ by
Geoffrey Pennington which covers exactly what you want.
Good luck.
On 04/14/00, ""Matthew Lohr" wrote:
> I am trying to write a script that has two select fields. I want the data
> in the second field sorted by whats in the first field. An example would be
> if my first select field would be leagues and my second select field is
> teams. When I select my league then I want to dynamically update the team
> select field. I found an example of doing this when the data is in a text
> file but have been unable to do this with a database.
Message #5 by "Matthew Lohr" <mlohr@t...> on Tue, 18 Apr 2000 10:45:50 -0400
|
|
I looked at the code and have my basic layout of how this is supposed to
work. I appreciate you pointing me in the right direction. I do have one
problem in executing this script though. In line 6 it is giving me a syntax
error ( which is the line I have put the asteriks after, they are not in my
code). The error occurs when I select from the second drop down list. The
only thing I can see is that one of the variables may not be defined or
listed correct. The other problem is that I am not even seeing this code
when I look back into my asp page so I assume that it is server generated.
3. <script LANGUAGE="Javascript">
4. function ChangeOptions(lstPrimary, lstSecondary, strArray)
5. {
6. var alen = eval(strArray + ".length")******************
7. var listLen = 0;
8. var strKey = eval("document.forms[0]." + lstPrimary +
".options[document.forms[0]." + lstPrimary + 9. 9. 9.
9.".selectedIndex].value")
10. eval("document.forms[0]." + lstSecondary + ".options.length = 0");
The following code is what I actually have in my script
<%@ Language=VBScript %>
<% Option Explicit %>
<!-- #include file=adovbs.inc -->
<!-- #include file=DynamicSelect.inc -->
<%
DIM Conn, rsPrimary, rsSecondary, intFirstPub
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "DSN=testddl"
Conn.Open
SET rsPrimary = Server.CreateObject("ADODB.RecordSet")
SET rsSecondary = Server.CreateObject("ADODB.RecordSet")
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
<%
rsPrimary.Open "SELECT pub_id, pub_name FROM publishers ORDER BY pub_name",
Conn
IF Err.number > 0 THEN
Response.Write "Unable to open Primary list" & "<BR>"
Response.Write Err.description
END IF
IF NOT (rsPrimary.BOF AND rsPrimary.EOF) THEN
intFirstPub = rsPrimary("pub_id")
ELSE
intFirstPub = 0
END IF
rsSecondary.Open "SELECT pub_id, title_id, title FROM titles ORDER BY
pub_id, title", Conn
IF Err.number > 0 THEN
Response.Write "Unable to open Secondary list" & "<BR>"
Response.Write Err.description
END IF
FillArray "arrTitles", rsSecondary, "pub_id", "title_id", "title"
%>
<CENTER>
<H2>Dynamic Select List</H2>
<FORM>
<TABLE WIDTH=100%>
<TR>
<TD>Primary List:<br><%SelectBox rsPrimary, "lstPublishers", "pub_id",
"pub_name", "lstTitles", "arrTitles" %></TD>
<TD>Secondary List:<br>
<%
rsSecondary.Filter = "pub_id = '" & intFirstPub & "'"
SelectBox rsSecondary, "lstTitles", "title_id", "title", "", " "
rsSecondary.Filter = adFilterNone
%>
</TD>
</TR>
</TABLE>
</FORM>
</CENTER>
</BODY>
</HTML>
-----Original Message-----
From: William Milne [mailto:wmilne01@e...]
Sent: Tuesday, April 18, 2000 1:47 PM
To: ASP Databases
Subject: [asp_databases] Re: Filters
Matthew. There is an excellent article at http://www.asptoday.com/ by
Geoffrey Pennington which covers exactly what you want.
Good luck.
On 04/14/00, ""Matthew Lohr" wrote:
> I am trying to write a script that has two select fields. I want the data
> in the second field sorted by whats in the first field. An example would
be
> if my first select field would be leagues and my second select field is
> teams. When I select my league then I want to dynamically update the team
> select field. I found an example of doing this when the data is in a text
> file but have been unable to do this with a database.
---
You are currently subscribed to asp_databases
Message #6 by "Shawn Steward" <ssteward@a...> on Tue, 18 Apr 2000 18:56:2
|
|
Did you change anything in the DynamicSelect.asp or .inc files? I
downloaded the files and it ran fine for me. I didn't get any script
errors. I take it this is a javascript error you are getting? Also, are
both lists populated when the page first loads?
shawn
On 04/18/00, ""Matthew Lohr" <mlohr@t...>" wrote:
> I looked at the code and have my basic layout of how this is supposed to
> work. I appreciate you pointing me in the right direction. I do have one
> problem in executing this script though. In line 6 it is giving me a syntax
> error ( which is the line I have put the asteriks after, they are not in my
> code). The error occurs when I select from the second drop down list. The
> only thing I can see is that one of the variables may not be defined or
> listed correct. The other problem is that I am not even seeing this code
> when I look back into my asp page so I assume that it is server generated.
>
>
>
>
>
> 3. <script LANGUAGE="Javascript">
> 4. function ChangeOptions(lstPrimary, lstSecondary, strArray)
> 5. {
> 6. var alen = eval(strArray + ".length")******************
> 7. var listLen = 0;
> 8. var strKey = eval("document.forms[0]." + lstPrimary +
> ".options[document.forms[0]." + lstPrimary + 9. 9. 9.
> 9.".selectedIndex].value")
> 10. eval("document.forms[0]." + lstSecondary + ".options.length = 0");
>
>
> The following code is what I actually have in my script
>
>
>
> <%@ Language=VBScript %>
> <% Option Explicit %>
> <!-- #include file=adovbs.inc -->
> <!-- #include file=DynamicSelect.inc -->
> <%
> DIM Conn, rsPrimary, rsSecondary, intFirstPub
>
>
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.ConnectionString = "DSN=testddl"
> Conn.Open
>
>
> SET rsPrimary = Server.CreateObject("ADODB.RecordSet")
> SET rsSecondary = Server.CreateObject("ADODB.RecordSet")
> %>
> <HTML>
> <HEAD>
> </HEAD>
>
> <BODY>
> <%
> rsPrimary.Open "SELECT pub_id, pub_name FROM publishers ORDER BY pub_name",
> Conn
> IF Err.number > 0 THEN
> Response.Write "Unable to open Primary list" & "<BR>"
> Response.Write Err.description
> END IF
>
> IF NOT (rsPrimary.BOF AND rsPrimary.EOF) THEN
> intFirstPub = rsPrimary("pub_id")
> ELSE
> intFirstPub = 0
> END IF
>
> rsSecondary.Open "SELECT pub_id, title_id, title FROM titles ORDER BY
> pub_id, title", Conn
> IF Err.number > 0 THEN
> Response.Write "Unable to open Secondary list" & "<BR>"
> Response.Write Err.description
> END IF
>
> FillArray "arrTitles", rsSecondary, "pub_id", "title_id", "title"
> %>
> <CENTER>
> <H2>Dynamic Select List</H2>
> <FORM>
> <TABLE WIDTH=100%>
> <TR>
> <TD>Primary List:<br><%SelectBox rsPrimary, "lstPublishers", "pub_id",
> "pub_name", "lstTitles", "arrTitles" %></TD>
> <TD>Secondary List:<br>
> <%
> rsSecondary.Filter = "pub_id = '" & intFirstPub & "'"
> SelectBox rsSecondary, "lstTitles", "title_id", "title", "", " "
> rsSecondary.Filter = adFilterNone
> %>
> </TD>
> </TR>
> </TABLE>
> </FORM>
> </CENTER>
> </BODY>
> </HTML>
>
>
>
> -----Original Message-----
> From: William Milne [mailto:wmilne01@e...]
> Sent: Tuesday, April 18, 2000 1:47 PM
> To: ASP Databases
> Subject: [asp_databases] Re: Filters
>
>
> Matthew. There is an excellent article at http://www.asptoday.com/ by
> Geoffrey Pennington which covers exactly what you want.
> Good luck.
>
> On 04/14/00, ""Matthew Lohr" wrote:
> > I am trying to write a script that has two select fields. I want the data
> > in the second field sorted by whats in the first field. An example would
> be
> > if my first select field would be leagues and my second select field is
> > teams. When I select my league then I want to dynamically update the team
> > select field. I found an example of doing this when the data is in a text
> > file but have been unable to do this with a database.
>
> ---
> You are currently subscribed to asp_databases
Message #7 by "Matthew Lohr" <mlohr@t...> on Wed, 19 Apr 2000 08:27:24 -0400
|
|
Yes both lists are populated. No I did not change anything except the data
connection which I have included below. Both lists are populated. I get the
error when I try to select from the second list it tells me I have a syntax
error. It asks me if I want to debug and if I say no it continues normally
I can then submit a form with this but if I select again from the second
field I get the syntax error again
<%
DIM Conn, rsPrimary, rsSecondary, intFirstPub
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "DSN=testddl"
Conn.Open
SET rsPrimary = Server.CreateObject("ADODB.RecordSet")
SET rsSecondary = Server.CreateObject("ADODB.RecordSet")
%>
-----Original Message-----
From: Shawn Steward [mailto:ssteward@a...]
Sent: Tuesday, April 18, 2000 6:00 PM
To: ASP Databases
Subject: [asp_databases] Re: Filters
Did you change anything in the DynamicSelect.asp or .inc files? I
downloaded the files and it ran fine for me. I didn't get any script
errors. I take it this is a javascript error you are getting? Also, are
both lists populated when the page first loads?
shawn
On 04/18/00, ""Matthew Lohr" <mlohr@t...>" wrote:
> I looked at the code and have my basic layout of how this is supposed to
> work. I appreciate you pointing me in the right direction. I do have one
> problem in executing this script though. In line 6 it is giving me a
syntax
> error ( which is the line I have put the asteriks after, they are not in
my
> code). The error occurs when I select from the second drop down list.
The
> only thing I can see is that one of the variables may not be defined or
> listed correct. The other problem is that I am not even seeing this code
> when I look back into my asp page so I assume that it is server generated.
>
>
>
>
>
> 3. <script LANGUAGE="Javascript">
> 4. function ChangeOptions(lstPrimary, lstSecondary, strArray)
> 5. {
> 6. var alen = eval(strArray + ".length")******************
> 7. var listLen = 0;
> 8. var strKey = eval("document.forms[0]." + lstPrimary +
> ".options[document.forms[0]." + lstPrimary + 9. 9. 9.
> 9.".selectedIndex].value")
> 10. eval("document.forms[0]." + lstSecondary + ".options.length = 0");
>
>
> The following code is what I actually have in my script
>
>
>
> <%@ Language=VBScript %>
> <% Option Explicit %>
> <!-- #include file=adovbs.inc -->
> <!-- #include file=DynamicSelect.inc -->
> <%
> DIM Conn, rsPrimary, rsSecondary, intFirstPub
>
>
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.ConnectionString = "DSN=testddl"
> Conn.Open
>
>
> SET rsPrimary = Server.CreateObject("ADODB.RecordSet")
> SET rsSecondary = Server.CreateObject("ADODB.RecordSet")
> %>
> <HTML>
> <HEAD>
> </HEAD>
>
> <BODY>
> <%
> rsPrimary.Open "SELECT pub_id, pub_name FROM publishers ORDER BY
pub_name",
> Conn
> IF Err.number > 0 THEN
> Response.Write "Unable to open Primary list" & "<BR>"
> Response.Write Err.description
> END IF
>
> IF NOT (rsPrimary.BOF AND rsPrimary.EOF) THEN
> intFirstPub = rsPrimary("pub_id")
> ELSE
> intFirstPub = 0
> END IF
>
> rsSecondary.Open "SELECT pub_id, title_id, title FROM titles ORDER BY
> pub_id, title", Conn
> IF Err.number > 0 THEN
> Response.Write "Unable to open Secondary list" & "<BR>"
> Response.Write Err.description
> END IF
>
> FillArray "arrTitles", rsSecondary, "pub_id", "title_id", "title"
> %>
> <CENTER>
> <H2>Dynamic Select List</H2>
> <FORM>
> <TABLE WIDTH=100%>
> <TR>
> <TD>Primary List:<br><%SelectBox rsPrimary, "lstPublishers", "pub_id",
> "pub_name", "lstTitles", "arrTitles" %></TD>
> <TD>Secondary List:<br>
> <%
> rsSecondary.Filter = "pub_id = '" & intFirstPub & "'"
> SelectBox rsSecondary, "lstTitles", "title_id", "title", "", " "
> rsSecondary.Filter = adFilterNone
> %>
> </TD>
> </TR>
> </TABLE>
> </FORM>
> </CENTER>
> </BODY>
> </HTML>
>
>
>
> -----Original Message-----
> From: William Milne [mailto:wmilne01@e...]
> Sent: Tuesday, April 18, 2000 1:47 PM
> To: ASP Databases
> Subject: [asp_databases] Re: Filters
>
>
> Matthew. There is an excellent article at http://www.asptoday.com/ by
> Geoffrey Pennington which covers exactly what you want.
> Good luck.
>
> On 04/14/00, ""Matthew Lohr" wrote:
> > I am trying to write a script that has two select fields. I want the
data
> > in the second field sorted by whats in the first field. An example
would
> be
> > if my first select field would be leagues and my second select field is
> > teams. When I select my league then I want to dynamically update the
team
> > select field. I found an example of doing this when the data is in a
text
> > file but have been unable to do this with a database.
>
> ---
> You are currently subscribed to asp_databases
$subst('Email.Unsub')
---
You are currently subscribed to asp_databases
Message #8 by "Matthew Lohr" <mlohr@t...> on Wed, 19 Apr 2000 09:08:20 -0400
|
|
The other thin I see is that the code in my dynamicselect.inc file is in
javascript but for some reason Visual Interdev is saying there is a syntax
error in the code
var alen = eval(strArray + ".length")
I am not to sure about debugging Javascript. I think this line is making
the statement that take the longest string in this field and make the size
of the display box that size.
-----Original Message-----
From: Shawn Steward [mailto:ssteward@a...]
Sent: Tuesday, April 18, 2000 6:00 PM
To: ASP Databases
Subject: [asp_databases] Re: Filters
Did you change anything in the DynamicSelect.asp or .inc files? I
downloaded the files and it ran fine for me. I didn't get any script
errors. I take it this is a javascript error you are getting? Also, are
both lists populated when the page first loads?
shawn
On 04/18/00, ""Matthew Lohr" <mlohr@t...>" wrote:
> I looked at the code and have my basic layout of how this is supposed to
> work. I appreciate you pointing me in the right direction. I do have one
> problem in executing this script though. In line 6 it is giving me a
syntax
> error ( which is the line I have put the asteriks after, they are not in
my
> code). The error occurs when I select from the second drop down list.
The
> only thing I can see is that one of the variables may not be defined or
> listed correct. The other problem is that I am not even seeing this code
> when I look back into my asp page so I assume that it is server generated.
>
>
>
>
>
> 3. <script LANGUAGE="Javascript">
> 4. function ChangeOptions(lstPrimary, lstSecondary, strArray)
> 5. {
> 6. var alen = eval(strArray + ".length")******************
> 7. var listLen = 0;
> 8. var strKey = eval("document.forms[0]." + lstPrimary +
> ".options[document.forms[0]." + lstPrimary + 9. 9. 9.
> 9.".selectedIndex].value")
> 10. eval("document.forms[0]." + lstSecondary + ".options.length = 0");
>
>
> The following code is what I actually have in my script
>
>
>
> <%@ Language=VBScript %>
> <% Option Explicit %>
> <!-- #include file=adovbs.inc -->
> <!-- #include file=DynamicSelect.inc -->
> <%
> DIM Conn, rsPrimary, rsSecondary, intFirstPub
>
>
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.ConnectionString = "DSN=testddl"
> Conn.Open
>
>
> SET rsPrimary = Server.CreateObject("ADODB.RecordSet")
> SET rsSecondary = Server.CreateObject("ADODB.RecordSet")
> %>
> <HTML>
> <HEAD>
> </HEAD>
>
> <BODY>
> <%
> rsPrimary.Open "SELECT pub_id, pub_name FROM publishers ORDER BY
pub_name",
> Conn
> IF Err.number > 0 THEN
> Response.Write "Unable to open Primary list" & "<BR>"
> Response.Write Err.description
> END IF
>
> IF NOT (rsPrimary.BOF AND rsPrimary.EOF) THEN
> intFirstPub = rsPrimary("pub_id")
> ELSE
> intFirstPub = 0
> END IF
>
> rsSecondary.Open "SELECT pub_id, title_id, title FROM titles ORDER BY
> pub_id, title", Conn
> IF Err.number > 0 THEN
> Response.Write "Unable to open Secondary list" & "<BR>"
> Response.Write Err.description
> END IF
>
> FillArray "arrTitles", rsSecondary, "pub_id", "title_id", "title"
> %>
> <CENTER>
> <H2>Dynamic Select List</H2>
> <FORM>
> <TABLE WIDTH=100%>
> <TR>
> <TD>Primary List:<br><%SelectBox rsPrimary, "lstPublishers", "pub_id",
> "pub_name", "lstTitles", "arrTitles" %></TD>
> <TD>Secondary List:<br>
> <%
> rsSecondary.Filter = "pub_id = '" & intFirstPub & "'"
> SelectBox rsSecondary, "lstTitles", "title_id", "title", "", " "
> rsSecondary.Filter = adFilterNone
> %>
> </TD>
> </TR>
> </TABLE>
> </FORM>
> </CENTER>
> </BODY>
> </HTML>
>
>
>
> -----Original Message-----
> From: William Milne [mailto:wmilne01@e...]
> Sent: Tuesday, April 18, 2000 1:47 PM
> To: ASP Databases
> Subject: [asp_databases] Re: Filters
>
>
> Matthew. There is an excellent article at http://www.asptoday.com/ by
> Geoffrey Pennington which covers exactly what you want.
> Good luck.
>
> On 04/14/00, ""Matthew Lohr" wrote:
> > I am trying to write a script that has two select fields. I want the
data
> > in the second field sorted by whats in the first field. An example
would
> be
> > if my first select field would be leagues and my second select field is
> > teams. When I select my league then I want to dynamically update the
team
> > select field. I found an example of doing this when the data is in a
text
> > file but have been unable to do this with a database.
>
> ---
> You are currently subscribed to asp_databases
$subst('Email.Unsub')
---
You are currently subscribed to asp_databases
Message #9 by "Matthew Lohr" <mlohr@t...> on Wed, 19 Apr 2000 09:24:15 -0400
|
|
Ok leave my problem alone when I went to show a coworker on his machine it
worked fine. So I tried 5 other machines and it all works. I think Visual
Interdev is doing something where it doesn't recognize the code in
javascript and is stopping it from running. All the other machines have the
same browser, IE 5.0, installed. They just don't have Visual Interdev.
-----Original Message-----
From: Shawn Steward [mailto:ssteward@a...]
Sent: Tuesday, April 18, 2000 6:00 PM
To: ASP Databases
Subject: [asp_databases] Re: Filters
Did you change anything in the DynamicSelect.asp or .inc files? I
downloaded the files and it ran fine for me. I didn't get any script
errors. I take it this is a javascript error you are getting? Also, are
both lists populated when the page first loads?
shawn
On 04/18/00, ""Matthew Lohr" <mlohr@t...>" wrote:
> I looked at the code and have my basic layout of how this is supposed to
> work. I appreciate you pointing me in the right direction. I do have one
> problem in executing this script though. In line 6 it is giving me a
syntax
> error ( which is the line I have put the asteriks after, they are not in
my
> code). The error occurs when I select from the second drop down list.
The
> only thing I can see is that one of the variables may not be defined or
> listed correct. The other problem is that I am not even seeing this code
> when I look back into my asp page so I assume that it is server generated.
>
>
>
>
>
> 3. <script LANGUAGE="Javascript">
> 4. function ChangeOptions(lstPrimary, lstSecondary, strArray)
> 5. {
> 6. var alen = eval(strArray + ".length")******************
> 7. var listLen = 0;
> 8. var strKey = eval("document.forms[0]." + lstPrimary +
> ".options[document.forms[0]." + lstPrimary + 9. 9. 9.
> 9.".selectedIndex].value")
> 10. eval("document.forms[0]." + lstSecondary + ".options.length = 0");
>
>
> The following code is what I actually have in my script
>
>
>
> <%@ Language=VBScript %>
> <% Option Explicit %>
> <!-- #include file=adovbs.inc -->
> <!-- #include file=DynamicSelect.inc -->
> <%
> DIM Conn, rsPrimary, rsSecondary, intFirstPub
>
>
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.ConnectionString = "DSN=testddl"
> Conn.Open
>
>
> SET rsPrimary = Server.CreateObject("ADODB.RecordSet")
> SET rsSecondary = Server.CreateObject("ADODB.RecordSet")
> %>
> <HTML>
> <HEAD>
> </HEAD>
>
> <BODY>
> <%
> rsPrimary.Open "SELECT pub_id, pub_name FROM publishers ORDER BY
pub_name",
> Conn
> IF Err.number > 0 THEN
> Response.Write "Unable to open Primary list" & "<BR>"
> Response.Write Err.description
> END IF
>
> IF NOT (rsPrimary.BOF AND rsPrimary.EOF) THEN
> intFirstPub = rsPrimary("pub_id")
> ELSE
> intFirstPub = 0
> END IF
>
> rsSecondary.Open "SELECT pub_id, title_id, title FROM titles ORDER BY
> pub_id, title", Conn
> IF Err.number > 0 THEN
> Response.Write "Unable to open Secondary list" & "<BR>"
> Response.Write Err.description
> END IF
>
> FillArray "arrTitles", rsSecondary, "pub_id", "title_id", "title"
> %>
> <CENTER>
> <H2>Dynamic Select List</H2>
> <FORM>
> <TABLE WIDTH=100%>
> <TR>
> <TD>Primary List:<br><%SelectBox rsPrimary, "lstPublishers", "pub_id",
> "pub_name", "lstTitles", "arrTitles" %></TD>
> <TD>Secondary List:<br>
> <%
> rsSecondary.Filter = "pub_id = '" & intFirstPub & "'"
> SelectBox rsSecondary, "lstTitles", "title_id", "title", "", " "
> rsSecondary.Filter = adFilterNone
> %>
> </TD>
> </TR>
> </TABLE>
> </FORM>
> </CENTER>
> </BODY>
> </HTML>
>
>
>
> -----Original Message-----
> From: William Milne [mailto:wmilne01@e...]
> Sent: Tuesday, April 18, 2000 1:47 PM
> To: ASP Databases
> Subject: [asp_databases] Re: Filters
>
>
> Matthew. There is an excellent article at http://www.asptoday.com/ by
> Geoffrey Pennington which covers exactly what you want.
> Good luck.
>
> On 04/14/00, ""Matthew Lohr" wrote:
> > I am trying to write a script that has two select fields. I want the
data
> > in the second field sorted by whats in the first field. An example
would
> be
> > if my first select field would be leagues and my second select field is
> > teams. When I select my league then I want to dynamically update the
team
> > select field. I found an example of doing this when the data is in a
text
> > file but have been unable to do this with a database.
>
> ---
> You are currently subscribed to asp_databases
$subst('Email.Unsub')
---
You are currently subscribed to asp_databases
|
|
|
View Cart
