Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Query String to Show Information?????

Apr 24, 2005 2:42AM PDT

I have a page that list many different members of a organization. The list has basic information about each member but i have another page that has detailed information about the member. I want to be able to select the member in the first page and the detailed information of that member will come up in the second page. I have a hyperlinbk that links the pages together however when i click the hyperlink it comes up to the the detailed page but not the correct member. The webpage is connected to a Access Database with Coldfusion. I want to use a MemberNumber that is located in the database to connect the pages. I am new at this, I dont know if i need a Query String or what I need to do. Please Help

Discussion is locked

- Collapse -
query string
Apr 25, 2005 8:16AM PDT

. . . would be the way to go. I am thinking in terms of ASP. The first page would have links like so

. . .
<a href="slimshady.asp?membernumber=24">Slim Shady</a>
<a href="johndoe.asp?membernumber=25">John Doe</a>
. . .

The second page would take the query string value, look for membernumber in the database and then display it.

I hope you know how to connect to a database with CF. Else google for "cold fusion tutorials"

- Collapse -
CFSet in Dreamweaver
Apr 26, 2005 2:11AM PDT

Good Morning,

I believe I explained it incorrectly before. I am new at this so I am using incorrect terminology. 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=
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfparam name="PageNum_Recordset1" default="1">
<cfquery name="Recordset1" datasource="Cprogram">
SELECT * FROM Contacts
</cfquery>

Please help...

- Collapse -
need a conditional statement?
Apr 28, 2005 2:15AM PDT

Don't you need a conditional statement in your select?

SELECT ContactId, ContactNAme from Customer
Where ContactId = <whatever variable you are passing> to page2?

Just a suggestion.