preserver newline in select field 1

[brianpercival]

Hi,

not exactly a cf question, but how can I have a form "select" field which goes multiple lines. which I later store in a database table field. When I cfoutput it, how do I retain the new lines?

 

[Signit]

Are you asking how to store which value is selected in the database i.e. I have options 1, 2, and 3. When I select 2 store 2 in the database. Upon record retrieval select 2 in the drop down?

 

[TruthInSatire]

I think you mean textarea, not select, correct? the line breaks ARE saved in the DB you just have to turn them into HTML when you output it.

<cfoutput>#replace(yourQuery.colName, chr(10), "<br>", "All")#</cfoutput>

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[brianpercival]

TruthInSatire,

thanks a lot. I mistyped.. textarea. not select I apologize.thanks for the ans. it works.

regards,
Brian