This is how I do it if this is the only area you want them to access. If I
allow a user to select the area, then we pass it in a form from a dropdown,
but the idea is the same.
JoAnn A. Schlosser
Senior Consultant
Association Management Software
Grant Thornton LLP
Washington, D. C.
703.837.4428
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 10:23 AM
To: CF-Talk
Subject: Grouping DB Data with Coldfusion ?
Hi
With Coldfusion how do you group field data together, for example.
I have a database table with id, date, summary and AREA.
The area field contains values such as 'software', 'presentations' etc in
each record.
How do you then in coldfusion pass a paramenter from a hyperlink to a
coldfusion page that would only display all the records that area.
I.E. If I clicked on a link called 'Software' it passes the parameter in the
url ie ?area=software and it takes you to a page with only the records with
software in the area field.
Any ideas on how to accomplish this, and is the above method the best and
most efficient approach of achieving this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
