[Zope] How to insert NULL values

[Jose Soares]

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 )