December 4th, 2004, 02:29 PM
|
|
Registered User
|
|
Join Date: Dec 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
drop down prices
hi im trying to make a form where you can choose between a highest price and a lowest price and then the database returns the results but i cant see what i have done wrong for it not to work can anyone help?
ill post the part that i think iv'e done wrong
Quote:
Dim HIGHbid, LOWbid
<%
IF request.queryString("Submit2")="searchprice" THEN
Connect = true
HIGHbid = request.form("highestprice") 'variable equals the value of the highest price box
LOWbid = request.form("lowestprice") 'variable equals the value of the lowest price box
SQL="SELECT Title,Artist,Price,DOR,Image FROM table1 WHERE Price BETWEEN '"&HIGHbid&"' AND '"&LOWbid&"' ORDER BY price"
END IF
%>
<%
Send "<FORM METHOD=""get"" ACTION="""" NAME=""form2"">"
Send " £ <SELECT NAME=""lowestprice"">"
Send "<OPTION VALUE=""1.00"">1.00</OPTION>"
Send "<OPTION VALUE=""2.00"">2.00</OPTION>"
Send "<OPTION VALUE=""3.00"">3.00</OPTION>"
Send "<OPTION VALUE=""4.00"">4.00</OPTION>"
Send "<OPTION VALUE=""5.00"">5.00</OPTION>"
Send "<OPTION VALUE=""6.00"">6.00</OPTION>"
Send "<OPTION VALUE=""7.00"">7.00</OPTION>"
Send "</SELECT> Min<BR>"
Send " £ <SELECT NAME=""highestprice"">"
Send "<OPTION VALUE=""8.00"">8.00</OPTION>"
Send "<OPTION VALUE=""9.00"">9.00</OPTION>"
Send "<OPTION VALUE=""10.00"">10.00</OPTION>"
Send "<OPTION VALUE=""11.00"">11.00</OPTION>"
Send "<OPTION VALUE=""12.00"">12.00</OPTION>"
Send "<OPTION VALUE=""13.00"">13.00</OPTION>"
Send "<OPTION VALUE=""14.00"">14.00</OPTION>"
Send "<OPTION VALUE=""15.00"">15.00</OPTION>"
Send "</SELECT> Max<BR>"
Send " <INPUT TYPE=""submit"" NAME=""submit2"" VALUE=""SearchPrice"">"
Send "</FORM>"
%>
|
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
