What's wrong with my criteria? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Guest -> What's wrong with my criteria? (11/30/2001 20:01:00)

Hello everyone, I'm having a heck of a time as to why the DRW is not retrieving SOME of my access database records.
For example I have a static page with a hyperlink that goes to the results page of the database records.....and it works fine when the criteria for the city is say "pittsburgh" or "atlanta" which I specified as CITY EQUAL TO PITTSBURGH etc.
However I am noticing that any city I hyperlink to the page that will contain all the records for that city is that if a city has two names for example "NEW YORK" or "LOS ANGELES" it returns zero results....does anyone have any ideas why this is happening?

Would love to know




rdouglass -> RE: What's wrong with my criteria? (11/30/2001 20:47:00)

Just guessing since I don't know all the details...

Maybe your browser is 'hiccuping' on the space between words. Try replacing your spaces (in the hyperlinks) with '%20'. So your link would look something like:

<a href="myPage.asp?City=Los%20Angeles">Los Angeles</a>

(You did say your first page was static, didn't you?) Hope this helps....




Guest -> RE: What's wrong with my criteria? (11/30/2001 20:33:00)

but the hyperlink on the static page is just linked to a asp page with no parameters in it. The query results are defaulted to pull out the correct info.....such as the atlanta page is linked to /atlanta_results.asp....
I appreciate your input....and I do hope someone can tell me how to correct this



rdouglass -> RE: What's wrong with my criteria? (11/30/2001 20:58:00)

Can you post your current results page code???

EDIT: I just built a similar scenario and it worked fine for me:

2 links going to 'defaulted' results page. One page going to a 'single word' criteria page and one page going to a 'double word' criteria page.

[This message has been edited by rdouglass (edited 11-30-2001).]




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625