[Zope] How to insert NULL values

[Farrell, Troy]

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 )