i have the exact same problem, i would like to see if you
get any help, please email me at (e-mail address removed)
thank-you,
Ned Miller
Well, suppose you have this form.
<form method="POST">
<p><select size="4" name="direction" multiple>
<option value="n">North</option>
<option value="s">South</option>
<option value="e">East</option>
<option value="w">West</option>
</select></p>
<p><input type="submit" value="Submit" name="btnSub"></p>
</form>
The code to build a SQL statement would look like this:
<%
dim sql
dim pos
if request.form("btnSub") <> "" then
sql = "SELECT * FROM mytable "
for pos = 1 to request.form("direction").count
if pos = 1 then
sql = sql & " WHERE "
else
sql = sql & " OR "
end if
sql = sql & " (direction = '" & request.form("direction")(pos) & "') "
next
end if
%>
If, for example, you select North and West, you get:
SELECT * FROM mytable WHERE (direction = 'n') OR (direction = 'w')
You would then need to open a database connection, use this SQL
statement to open a recordset, and then loop through each returned
record, writing an HTML table row into the response stream for each
one.
Note that you'll need to write all the ASP (or ASP.NET) code for this
page yourself. This isn't something you can feed into the Database
Results Wizard.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
