navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

What's wrong with my criteria?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> What's wrong with my criteria?
Page: [1]
 
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

 

Posts: 9186
From: Biddeford, ME USA
Status: offline

 
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....


(in reply to Guest)
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

(in reply to Guest)
rdouglass

 

Posts: 9186
From: Biddeford, ME USA
Status: offline

 
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).]


(in reply to Guest)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> What's wrong with my criteria?
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts