Hard coding select= statement

Report · Jun 13, 2006

I'm having difficulty with the correct way to code this...

Collections/rodeogear/rodeogear_results.asp?select=Group 1 Prints AND Group 1 Prints&Submit=search

In my database I have two categories(group 1 prints and group 2 prints) that I want to display. when I add the AND it shows blank results... when I remove the AND and just ...

Collections/rodeogear/rodeogear_results.asp?select=Group 1 Prints&Submit=search

it works fine. please advise...

thanks
fred

Report · Jun 14, 2006

Firstly, spaces in URLs are a big no-no.

After that, we need to see the code you are having problems with in order to
help debug it.
Cheers,
Rob
http://robgt.com/ [Tutorials and Extensions]
Firebox stuff: http://robgt.com/firebox
Skype stuff: http://robgt.com/skype
Dell stuff: http://robgt.com/dell
SatNav stuff: http://robgt.com/satnav

Report · Jun 14, 2006

ok, how's this. Dreamweaver will automattically put % in where there is a space.

Here is the line of code that will displays no error, but just blank results...

http://www.resistolhat.com/raw/Collections/rodeogear/rodeogear_results.asp?select=Group%201%20Prints...

Attached is the code to the "search" page.

Report · Jun 15, 2006

>Recordset1.Source = "SELECT * FROM RodeoGear"

Your recordset is not being filtered with anything.
If you want to filter the data with parameters submitted from a form, you
need to modify the recordset in the recordset builder wizard and tell it to
look for form parameters.

This stuff is in the dreamweaver help file.
If you're trying to do something else, you'll need to explain it a bit
clearer as I'm not getting it currently.

Side note:
Unless you specifically tell dreamweaver to "Server.URLEncode" querystrings,
it will not replace anything in a URL for you. Internet Explorer, on the
other hand, will replace spaces with %20 to keep the application from
falling over. Other browsers may not be so kind. This can break an
application so be on the lookout... :)

Cheers,
Rob
http://robgt.com/ [Tutorials and Extensions]
Firebox stuff: http://robgt.com/firebox
Skype stuff: http://robgt.com/skype
Dell stuff: http://robgt.com/dell
SatNav stuff: http://robgt.com/satnav