|
| |
|
|
snowpick
Posts: 2
From: Milford, PA, USA
Status: offline
 |
employment ad posting site problem - 4/7/2001 23:11:00
I'm currently in a project where I'm building a job posting site based on Monster.com's design.
When a user makes a search, each job is posted on a list. That list is then linked to a separate page that they can view the details.
I'm able to get everything working! but I'm also getting ALL of the results from the database...
Could someone please let me know how I can change that so it only shows the details for the ONE position that I'm trying to view. In other words, I'm getting the list of jobs and their description one after another down the page. I only want the one job that I clicked on to show the details. ------------------
|
|
|
|
kevin1000
Posts: 60
From: allen park, mi, usa
Status: offline
|
RE: employment ad posting site problem - 4/7/2001 23:19:00
I'm new but I'm thinking a link like this:re_training.asp?Date=<%=FP_FieldURL(fp_rs,"Date")%>&ClassName=<%=FP_FieldURL(fp_rs,"ClassName")%> I'm working on a site that user can get a list of classes. When they want to see the details of a class, they can click on the class name and get details. I did this by creating a link off of the class name and adding the parameters listed above. Hope I'm in the ballpark ![]("http://www.frontpagewebmaster.com/ubb/smile.gif") Kevin
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: employment ad posting site problem - 4/8/2001 20:39:00
Id really need to see the site, but if you are trying to return 1 record, you need to be able to select it with the unique ID that it has (the autonumber field)So a link would be something like : results.asp?ID=12 Results.asp would search like: Select * from table where ID = "&Request.Querystring("ID")
------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
|
|
snowpick
Posts: 2
From: Milford, PA, USA
Status: offline
|
RE: employment ad posting site problem - 4/8/2001 17:51:00
Okay,
I got it...(I had the records returned to 250..., I changed it to 1 and everything works...) SORT OF!
When I get the list of links, I can click on the first link. Everything works great. It shows one record. Thanks Kevin, it really helped seeing that search string. Thanks Spooky, Now I understand how it all works together.
Here's my new problem. When I click on link 1, everything is fine. When I click on link 2, the search string is correct, the data is from link #1 though! What have I done to only make it show link 1?
Incidently, If I set the search results to 5, I can see record #1-#5 so I know the data is there. Here is a sample search string:
jobview.asp?ID=2&recruiter_name=Maria+Romanoff&jobid=MR101%2D250
That search is supposed to show me id#2. It shows me id#1 instead. Any thoughts?
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: employment ad posting site problem - 4/9/2001 20:23:00
Im not sure why you change the records returned?You should be setting your SQL string up to receive 1 record eg SELECT * FROM TABLE WHERE ID=::ID:: and forget about all the extra parts of the string.
The important, and unique part, is the ID
| |
|
 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 
