Discussion Locked

Manipulation of CFSET in Dreamweaver

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Good Morning,

What I have is a page with a CFSET which list several members of the orgainzation. I want to be able to select whichever of the members and detailed information of that member appears on a different page. Here is the information on the CFset page. I have the results page set up with a table and the Recordset but I dont know how to get the results page to show the proper member when it is selected from the first page. The site is connected to a Access Database via Cold Fusion.

Here is the information on the CFset page=

SELECT * FROM Contacts

Please help...

3 replies

by oz_media

Either in technical Q&A (not the discussion forum) or on MAcromedia's Cold Fusion forum, it's fast and you get great replies.

by chief elephant

I'm not certain I understand what you are trying to do, so let me summarize back what I think you're up to ---and an idea to accomplish that.

On Page 1 you run a query name="Recordset1" and ouput the results to a table. I'm guessing your results would be something like:

#name# #email_address#

And you're saying you want to be able to "select" any particular contact (record row) and have thet full set of detailed information about that "contact" appear on a second page.

Right?

If I am correct in guessing what you want to do, this is fairly easy and there are a number of ways to do it. But I need to know which version of ColdFusion you are writing it (the server is running) Reply with this answer and I'll suggest a way to get what you want.

Chief Elephant

by gadsfasdfasfadfs

Assuming you have a unique ID in the database for each employee, called contactID:

#contactFName# #contactLName#

SELECT * FROM Contacts WHERE ContactID = #URL.contactID#

#contactFName# #contactLName#

Good luck.

This discussion is closed to new replies.