Update problem - "&"

[swordfish123]

Hi, I have problems when I update text that contains the letter/symbol "&". For exameple, a text like: Music & movies..
The data loads into a dynamic textfield. I use Flash MX, Access Database and ASP.

The SQL String:

SQLstmt = "UPDATE about SET aboutText='" & replace(about, "'", "''") & "'"

Thankful for some advise
/S-fish

[oldnewbie]

The & indicates the start of a new variable in Flash.

Urlencoding...

Replace the & with %26

http://www.macromedia.com/support/fl...l_encoding.htm