Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Hard coding select= statement

New Here ,
Jun 13, 2006 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
TOPICS
Server side applications
338
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 14, 2006 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



Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 14, 2006 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.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 15, 2006 Jun 15, 2006
LATEST
>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



Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines