New line in a memo field... 1

[KevinFSI]

Let's say I have a database full of poems or songs. I have a table with a memo field to hold the lines to the poem, and want to query the DB and output the text. If the text is all one word after another, how can I output it with carriage returns in the proper places? Can I do something like put semi-colons in the memo field and tell coldfusion to give me a <BR> when it encounters a semi-colon? Obviously, I'm not sure what to do, but hopefully you all know what I'm getting at.

For example: If the text in the memo field is like so:

This is a poem; I know it is a really bad one; It doesn't even rhyme; I shouldn't quit my day job

How can I output it like this:

This is a poem;
I know it is a really bad one
It doesn't even rhyme
I shouldn't quit my day job

Clear as mud? Thanks in advance guys!
Kevin
slanek@ssd.fsi.com

 

[GunJack]

Hey Kevin,

You can use the CF replace function like this:

<cfoutput>#replace(q1.Field1,&quot;;&quot;,&quot;<br>&quot;,&quot;all&quot#</cfoutput>

If your poems already have the proper line breaks in them, you can use the line feed character (ascii value 10) to trigger <br> tags like this:

<cfoutput>#replace(q1.Field1,#chr(10)#,&quot;<br>&quot;,&quot;all&quot#</cfoutput>

Let me know if you have any problems,
GJ

 

[KevinFSI]

I've said it before, I'll say it again, you're the man. That's exactly what I was looking for.

Thanks!
Kevin
slanek@ssd.fsi.com

 

[GunJack]

You bet! Glad to help,

GJ