Re: [Zope] Passing multi-line field into SQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In article <[EMAIL PROTECTED]>, Tony Mann <[EMAIL PROTECTED]> 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: > >')" >sql_quote>, > 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 in the text box to produce the effect of a line break since I only ever work with HTML formatted text. - -- Regards, Graham Chiu gchiucompkarori.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- ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
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: ')" sql_quote>, 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 <[EMAIL PROTECTED]>, Tony Mann <[EMAIL PROTECTED]> 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? ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Passing multi-line field into SQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In article <[EMAIL PROTECTED]>, Tony Mann <[EMAIL PROTECTED]> 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 gchiucompkarori.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- ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Passing multi-line field into SQL
We have a form with a textarea on it, that can contain line breaks. When we try to pass it into an SQL statement we get a parsing error, due to the embedded newlines. We would like to convert the newlines to "" 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.. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )