Passing Database Value to another page

[Viky]

Hi

I am retrieving records 3 fields out of 5 from the database in the main page.
I want when the user click on the one of the heading field record displayed in
main page.. my user should be able to go to new page where in only details of
the certain record which is clicked is displayed..

please help.. urgency.. thanks in advance

[TimMcGeary]

Do you have an id of the headline content that links from the news table to the
headlines table? For example, I would do the following:

<cfquery name="headlines" datasource="asian-db">
SELECT Headline, subheadline, Contributed, Details, headline_id
FROM news
WHERE Category = 'headlines'
</cfquery>

<cfoutput query="headlines">
<tr>
<td class="style6"><a
href="news.cfm?headline_id=6">#headlines.Headline# </a></td>
</tr></cfoutput>

With the news.cfm page reading the headline_id=6 and reporting the content
from the table with that id.

Does that help?