[Zope] Passing multi-line field into SQL

[Graham Chiu]

-----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-----