Question on form handling - select multiple.
In the IE DHTML model, the select object has an options collection. Each
item in the collection is an option object. The option object has a
(true/false) selected property.
See:
http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/...
d.asp
--
Michael Harris
I am quite new at scripting, and have looked at several sets of
documentation for some help, to no avail.
I have two sets of problems.
1. I have a drop down menu with multiple option selections possible. I
haven't quite figured out how to determine which options were selected. I
think that a loop of the type 'for each' (?) will work, but I haven't found
any examples.
2. I want to take the values associated with the multiple selected options,
from the above mentioned drop down menu, and feed them into an SQL query to
return all intersecting rows for these values. The table layout is as
follows:
PKEY - Feature (query will match against selected option values from drop
down menu)
SKEY - Resort
I am trying to return all resorts that match all selected features from drop
down menu.
I understand that I can use parameters in the SQL query, but I don't know
how to construct the SQL statements to allow for an unknown number of
selections, nor do I know how to reference the multiple occurrences of the
singular field from the form.
I hope this makes sense to someone out there - I can try to explain the
situation better, if needed.
THANKS BIGTIME if anyone can help me with this.
