I'm sure there must b an easy answer to this problem.. [?]

I have a DB [ADODB] filled list box. Prior to it being ?Submitted? I 
require to now the text within the list box either that that has already 
been selected by the client which is the most probable or by default if 
the client finds that the first item in the list box is that which they 
require. This is in order to pass it to another SQL statement where it 
would be used in the WHERE statement prior to that SQL filling a further 
list box. I must have half a dozen books on asp, xml, html etc., but all 
are reluctant to give up the necessary knowledge all as if it were not 
available. Is it?

Kindest regards to any helper,
Chris Sprckley

Chris,
A possible solution...you could use an "onChange" event handler within the
SELECT statement along with the JavaScript "jumpTo" function. This could be
used to reload the same page, before the submit button is pressed, bringing
along the option that had been selected. A Google search of these two
strings will yield many examples.
All for now.
Dean
PS I done this with VBScript but ran into issues running it within
Netscape...thus the use of JavaScript.  

-----Original Message-----
From: Harvey C. Spreckley [mailto:hcs@c...]
Sent: Friday, June 28, 2002 3:02 AM
To: Access ASP
Subject: [access_asp] ASP/SQL


I'm sure there must b an easy answer to this problem.. [?]

I have a DB [ADODB] filled list box. Prior to it being "Submitted" I 
require to now the text within the list box either that that has already 
been selected by the client which is the most probable or by default if 
the client finds that the first item in the list box is that which they 
require. This is in order to pass it to another SQL statement where it 
would be used in the WHERE statement prior to that SQL filling a further 
list box. I must have half a dozen books on asp, xml, html etc., but all 
are reluctant to give up the necessary knowledge all as if it were not 
available. Is it?

Kindest regards to any helper,
Chris Sprckley

Hi,

Thanks for the info.

I don't feel really that I want to use Java, can you  tell me how you ent 
about it in VBSscript?


Chris Spreckley

> Chris,
A possible solution...you could use an "onChange" event handler within the
SELECT statement along with the JavaScript "jumpTo" function. This could be
used to reload the same page, before the submit button is pressed, bringing
along the option that had been selected. A Google search of these two
strings will yield many examples.
All for now.
Dean
PS I done this with VBScript but ran into issues running it within
Netscape...thus the use of JavaScript.  



I'm sure there must b an easy answer to this problem.. [?]

I have a DB [ADODB] filled list box. Prior to it being "Submitted" I 
require to now the text within the list box either that that has already 
been selected by the client which is the most probable or by default if 
the client finds that the first item in the list box is that which they 
require. This is in order to pass it to another SQL statement where it 
would be used in the WHERE statement prior to that SQL filling a further 
list box. I must have half a dozen books on asp, xml, html etc., but all 
are reluctant to give up the necessary knowledge all as if it were not 
available. Is it?

Kindest regards to any helper,
Chris Sprckley