Skip to main content
T
tacomafred
Participating Frequently
June 13, 2006
Question

Hard coding select= statement

  • June 13, 2006
  • 1 reply
  • 321 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
June 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



N
Newsgroup_User
Inspiring
June 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



Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices