|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Creating Select statement from multiple input fields |
|
From: |
Tomas Wallentinus |
|
Date: |
12/22/1999 5:05:57 PM |
|
IP: |
195.17.73.84 |
Yeah I have the same question.
My search engine look like this:
> <FORM enctype="multipart/form-data" ACTION="result.asp" METHOD=GET>
> Hårfärg: <SELECT name="haircolor">
> <OPTION SELECTED> %
> <OPTION> Annan
> <OPTION> Blond
> <OPTION> Ljusbrun
> <OPTION> Mörkbrun
> <OPTION> Röd
> </SELECT><BR>
> Ögonfärg: <SELECT name="eyecolor">
> <OPTION SELECTED> %
> <OPTION> Annan
> <OPTION> Grön
> <OPTION> Blå
> <OPTION> Brun
> </SELECT>
> <p><INPUT TYPE=SUBMIT VALUE="Sök">
And the output-thing looks like this:
> haircolor=REQUEST.QUERYSTRING("haircolor")
> eyecolor=REQUEST.QUERYSTRING("eyecolor")
> Set conn = Server.CreateObject("ADODB.Connection")
> conn.Provider = "Microsoft.Jet.OLEDB.4.0"
> conn.ConnectionString = "Data Source=" & Server.MapPath ("/cgi-bin/nr1.mdb")
> conn.Open
> sql= "select * from tabell1 where haircolor like "& haircolor & " or"
> sql= sql & " eyecolor like "& eyecolor &" order by fnamn"
Please help me someone. |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
