This one insert the string "NULL" into the field. "Farrell, Troy" wrote:
First of all, shouldn't the last line be )"> instead? Also, try <dtml-call "qry.ins_introduzioni( codice_fiscale=CODICE_FISCALE, distretto=DISTRETTO, marca_precedente='NULL' )">
Good luck, Troy
-----Original Message----- From: Jose Soares [mailto:jose@sferacarta.com] Sent: Monday, February 12, 2001 10:22 AM Cc: zope@zope.org Subject: [Zope] How to insert NULL values
Hi all,
I'm trying to insert NULL values into a column of a table using the ZSQL-Method without success.
I tried the following:
<dtml-call "qry.ins_introduzioni( codice_fiscale=CODICE_FISCALE, distretto=DISTRETTO, marca_precedente='' >")
also:
<dtml-call "qry.ins_introduzioni( codice_fiscale=CODICE_FISCALE, distretto=DISTRETTO, marca_precedente=_.None >")
Please may somebody tell me the right syntax?
Thank you.
Jose'
_______________________________________________ Zope maillist - Zope@zope.org 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 maillist - Zope@zope.org 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 )