problem pulling text file from database

[quiero mas]

Please keep it simple - noob in the house

Hi everyone - im trying to display a text file that i have save as a
hyperlink.

I cant seem to get the contents of the file just the hyperlink address

<cfif isdefined("id")>
<cfif isnumeric(id)>
<cfquery name="qGetItem" datasource="#application.ds#">
SELECT *
FROM oshimi_products
WHERE frn_category_id = frn_category_id</cfquery>
<cfif qGetItem.recordcount gt 0>



<table class="symtable"width="360px" >

<cfoutput query="qGetItem">


<tr>
<td>#ProductName#</td>
<td>#qGetItem.ProductDescription#</a></td>

</tr>
</td>

</cfoutput>
</table>
</cfif>
</cfif>
</cfif>



* the product description contains the hyperlink to the file.

Any ideas would be most appreciated

Mark

[vkunirs]

Hi


* the product description contains the hyperlink to the file.

what do you mean by this word. do you mean to say that you want to display
a link to the file or you want to display the file contents as text which will
have the link?
can you post it clearly?

if the description is having the link then display it directly like this.

<td><a
link="#qGetItem.ProductDescription#">#qGetItem.Pro ductDescription#</a></td>

[quiero mas]

Hi
In my database there is a field which has links to articles - these articles
have been saved as simple text.
When a user selects the month in which the article corresponds to i want the
text from the article to be displayed in a cfm page so that the user can read
it.

example
archive page
months - october november december
choose - october
october 's article is displayed.


Im sorry i wasnt very clear

Thank Mark

[efecto747]

To retrieve the contents of a file, you could use the cfcontent tag - If you
don't know how to use this tag have a look on LiveDocs for more information:
[url]http://livedocs.macromedia.com/coldfusion/[/url]

cheers.

[quiero mas]

Thanks for the advice - actually I found a tutorial at easycfm.com which seems to be what i need - if i run into trouble I be posting again.

Thanks for the Advice
Mark