We have a form with a textarea on it, that can contain line breaks. When we try to pass it into an SQL statement <dtml-sqlvar textarea_value type=string> we get a parsing error, due to the embedded newlines. We would like to convert the newlines to "<BR>" strings. Does anyone have an easy solution for doing this? We have tried using split/dtml-in and split/join in the SQL, but getting these statements past the SQL parser, with all the quotes, has proven to be tricky. ..tony..
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 In article <ADEJJHCCJLPKOFCAHEKNKELHCGAA.tony@intelligenesis.net>, Tony Mann <tony@intelligenesis.net> writes
We have a form with a textarea on it, that can contain line breaks. When we try to pass it into an SQL statement
How do you enter line breaks into a text area? What database adapter are you using? - -- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.co.nz/index.php Powered by Interbase and Zope -----BEGIN PGP SIGNATURE----- Version: PGPsdk version 1.7.1 iQA/AwUBOSphfrTRdIWzaLpMEQKc9ACg2/2B5q8Wtq0I8g6mgtbUGrWYMOIAoOp/ F4I2em/FF62qjkwoP/Ud/xG1 =2ttC -----END PGP SIGNATURE-----
participants (2)
-
Graham Chiu -
Tony Mann