|
| |
|
|
wild
Posts: 12
Joined: 9/28/2005
Status: offline
 |
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
Posts: 233
Joined: 12/18/2002
From: New Jersey!
Status: offline
|
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
Posts: 12
Joined: 9/28/2005
Status: offline
|
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
Posts: 12
Joined: 9/28/2005
Status: offline
|
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
Posts: 233
Joined: 12/18/2002
From: New Jersey!
Status: offline
|
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
Posts: 12
Joined: 9/28/2005
Status: offline
|
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
Posts: 233
Joined: 12/18/2002
From: New Jersey!
Status: offline
|
RE: multiple diplay of results when I require one result - 9/28/2005 14:18:06
Seems fine. What is the error message?
| |
|
|
|
wild
Posts: 12
Joined: 9/28/2005
Status: offline
|
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
Posts: 233
Joined: 12/18/2002
From: New Jersey!
Status: offline
|
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
Posts: 12
Joined: 9/28/2005
Status: offline
|
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
Posts: 12
Joined: 9/28/2005
Status: offline
|
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
Posts: 12
Joined: 9/28/2005
Status: offline
|
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
Posts: 12
Joined: 9/28/2005
Status: offline
|
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
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 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
|
|
|
Printable Version 
