Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

Query String to show Detailed Information on Member??

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
0
misnstt
Asked:
misnstt
  • 3
  • 3
1 Solution
 
Ryan ChongCommented:
>>I dont know if i need a Query String or what I need to do
Basically, we can using "Query Strings" or Session to archive what you trying to do.

Many web pages are development in such way treated "Query Strings" at the parameters for a web page, so that the web page can process and display according to the parameters. Of course, the web page itself must handle the situation where when invalid "Query Strings" are received, an error page (message) or page redirection will be executed.

For Session, it's good when the web page need login authentication, where the unique identifier of login user is saved into session, but session is only suitable for single info (record) of the login user (like user detail page), and it's not suitable if there is more than 1 record for a single user (like the user's purchases info).

For your situation, i think "Query Strings" + Necessary verification is what you can look forward.

regards
0
 
misnsttAuthor Commented:
Thank you for your answer.  I am very new at this.  Could you please provide a written example for the query string and verification in this situation.  Thank You
0
 
Ryan ChongCommented:
So is Access + ColdFusion? Do you have table structures can post here?

regards
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
misnsttAuthor Commented:
I am using Access + ColdFusion.  Do I need to put a CFQuery in the Detailed Information Page which states to show information concerning the member selected from the first page?  If so how would the CFQuery be structured?
0
 
misnsttAuthor Commented:
Good Morning,

I hope this will help better.  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.
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfparam name="PageNum_Recordset1" default="1">
<cfquery name="Recordset1" datasource="Cprogram">
SELECT * FROM Contacts
</cfquery>

Please help...
0
 
Ryan ChongCommented:
Sorry for being so late....

You can try like:

<cfparam name="MbrID" default="0">

then...

<cfquery name="Recordset1" datasource="Cprogram">
SELECT * FROM Contacts Where mbrID = #MbrID#
</cfquery>

<cfif Recordset1.RecordCount eq 0>
         <cflocation url="error.cfm?err=invalidMbrID" addtoken="no">
</cfif>

...

where your link should include the querystring of "MbrID", like:

<a href="viewdetail.cfm?MbrID=1">View Detail</a>

Hope this helps, regards
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now