[EMAIL PROTECTED] wrote:
In a Python script, how can I break up a SQL statement over more than
one line? For example, to transform
#generate the sql statement
sql="DELETE FROM tblUsers WHERE user_name LIKE '%'"
to:
#generate the sql statement
sql="DELETE FROM tblUsers WHERE user_name LIKE '%'"
...does not work. Is there a way to break lines?
Any example would be appreciated.
Python allows you to you triple-quotes to include line breaks in the
string::
sql="""DELETE FROM tblUsers
WHERE user_name LIKE '%'"""
Take a look at the python.org tutorial or diveintopython.org.
--jcc
_______________________________________________
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )