# Dynamic text from database and textareas query

**URL:** https://forum.kirupa.com/t/dynamic-text-from-database-and-textareas-query/65758
**Category:** flash
**Created:** [September 29, 2004, 11:30am UTC](https://forum.kirupa.com/t/dynamic-text-from-database-and-textareas-query/65758 "2004-09-29T11:30:16Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Carlos](https://avatars.discourse-cdn.com/v4/letter/c/ecae2f/32.png) [@Carlos](https://forum.kirupa.com/u/Carlos)
#### Post date: [September 29, 2004, 11:30am UTC](https://forum.kirupa.com/t/dynamic-text-from-database-and-textareas-query/65758/1 "2004-09-29T11:30:16Z")

</div>

I have text being inserted into a textarea component dynamically from a MySQL database. The problem is getting characters like the ampersand (&) to show. Also the carriage returns are being processed twice (or the carriage return and newline characters are both being processed).

Is there any way around these problems?

Cheers,  
c

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [September 29, 2004, 12:17pm UTC](https://forum.kirupa.com/t/dynamic-text-from-database-and-textareas-query/65758/2 "2004-09-29T12:17:21Z")

</div>

try the textField.condenseWhite=true; property.

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [September 29, 2004, 10:14pm UTC](https://forum.kirupa.com/t/dynamic-text-from-database-and-textareas-query/65758/3 "2004-09-29T22:14:56Z")

</div>

Doesn’t do much unfortunately :(.

Surely a fair few people have encountered this problem, it seems to be something that would crop up countless times.

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [September 30, 2004, 12:04am UTC](https://forum.kirupa.com/t/dynamic-text-from-database-and-textareas-query/65758/4 "2004-09-30T00:04:05Z")

</div>

OK have realised the problem is what I stated initially where flash read the “  
” as two line breaks. I’m guessing the ampersand problem is due to it being an invalid character in XML …?
