Re: [Zope] Passing multi-line field into SQL
You enter a line break by pressing the Enter key! We are using Gadfly for right now, until our Oracle db server is set up. We actually found a solution: <dtml-var "'\''"><dtml-var "_.string.replace(description ,'\n','<br>')" sql_quote><dtml-var "'\''">, Kind of ugly, but it works. I imagine there are more elegant solutions. Note that I used dtml-var to produce a single quote to avoid nasty nested quote issues. ..tony.. ================================= 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?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 In article <ADEJJHCCJLPKOFCAHEKNGELNCGAA.tony@intelligenesis.net>, Tony Mann <tony@intelligenesis.net> writes
You enter a line break by pressing the Enter key!
We are using Gadfly for right now, until our Oracle db server is set up.
We actually found a solution:
<dtml-var "'\''"><dtml-var "_.string.replace(description ,'\n','<br>')" sql_quote><dtml-var "'\''">,
I seem to recall that there is a problem with Gadfly and multiline data. I don't use Gadfly, and don't have this problem. However, I have to enter <br> in the text box to produce the effect of a line break since I only ever work with HTML formatted text. - -- 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/AwUBOSuRNbTRdIWzaLpMEQL+3ACgjzqk2zI2eLe8u3jSPAll0NyPzvQAoLTP NzXDSlxEk7/QJY6iuh+IpNXB =S1Bt -----END PGP SIGNATURE-----
participants (2)
-
Graham Chiu -
Tony Mann