multiple diplay of results when I require one result

multiple diplay of results when I require one result (Full Version)

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

Message

wild -> multiple diplay of results when I require one result (9/28/2005 11:01:00)
I am building a news type database system for a website. I have title, intro, author, and date. What i would like is to click onto the link which i put into the title and then to get the details of that one specific news item. Instead I get a list of all of the deatails of all the news items, rather than the details of the one news item.......... any help would greatly appreciated.

Sandalwood -> RE: multiple diplay of results when I require one result (9/28/2005 11:39:22)
Wild, Are you using DRW? Also, what type of database?

wild -> RE: multiple diplay of results when I require one result (9/28/2005 11:52:31)
thanks, access database. I am trying to use drw..............results come out as a long list of entries I have just read about osmething about inserting code into the hyperlink, but the entries dont come out as a single unit, to be quite frank, my head is wrecked here

wild -> RE: multiple diplay of results when I require one result (9/28/2005 11:55:08)
web address is www.harveywasserman.net/test.asp

Sandalwood -> RE: multiple diplay of results when I require one result (9/28/2005 12:09:35)
1) On your main page, the link could just include the ID field and you would be fine: result.asp?ID=<%= FP_FieldVal(fp_rs,"ID")%> 2) On your results page, the query should be as follows: fp_sQry="SELECT * FROM *TableName* WHERE (ID = ::ID::)"

wild -> RE: multiple diplay of results when I require one result (9/28/2005 12:58:06)
hey thanks thats great, h6 is the table name, but an error message comes up. is the below edit ok? fp_sQry="SELECT * FROM h6 WHERE (ID = ::ID::)"

Sandalwood -> RE: multiple diplay of results when I require one result (9/28/2005 14:18:06)
Seems fine. What is the error message?

wild -> RE: multiple diplay of results when I require one result (9/28/2005 14:35:01)
thanks again,,,,, check out 1. http://www.harveywasserman.net/test.asp Check out 2 When I paste the code into the custom query editor I get the following: ---------------------------- Server error: Unable to retrieve schema information from the query: fp_sQry="SELECT * FROM h6 WHERE (ID = 1)" against a database using the connection string DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=database2/bd1.mdb. The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. -------------------

Sandalwood -> RE: multiple diplay of results when I require one result (9/28/2005 15:04:36)
I tried to go to the page, but it won't come up?

wild -> RE: multiple diplay of results when I require one result (9/28/2005 15:11:49)
I cant tell you how much I appreciate this help, its fantastic........I am really in a fix here. The page wont come up when i put this code into one of the values in the recordset as link........ just to be clear, I right click on one of the regions that present the data. I go to hyperlink properties in the bottom field I paste the code. I upload the file and it doesnt show up on the internet. The second piece of code will werify a connection to the database......... This is perplexing because fronpage connects to my database typically............. hope this helps

wild -> RE: multiple diplay of results when I require one result (9/28/2005 15:13:24)
i dont think theres an id section in the database also

wild -> RE: multiple diplay of results when I require one result (9/28/2005 16:06:30)
Still figuring this out. I got the first page hyperlink page to correctly to go to the results page becuase the ID was actually scd........woops....... still working on the results page/................

wild -> RE: multiple diplay of results when I require one result (9/28/2005 17:11:10)
Almost there I think, does anybody know hwy the results appear in the title bar????>..........and the results stay stable for all of the entries on the database???>

BeTheBall -> RE: multiple diplay of results when I require one result (9/28/2005 17:49:37)
What does the code look like for the first page, the one that is showing more than it should in the title bar?

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.046875