[Zope] How to replace NULL values in a database query

Jim Cain jec@mgmt-inc.com
Mon, 30 Aug 1999 23:06:22 -0400


All,

I have created a form which allows me to edit the contents of a database
table. To create the text fields I use something like this:

<input type=text name=blah value="<dtml-var column_name null="">">

The problem is that when the column is null, I get "None" in my text field.
The the discussion of the null="" attribute in the DTML document makes it
sound as though the special Python value None is taken care of.

This seems like a terribly elementary question. Am I missing something
obvious?

Thanks,
Jim



    ____________       Jim Cain, System Administrator     ___
   /  ________  \         http://jec.mgmt-inc.com        /  /
  /  / ______ \  \   _________   _______   _________  __/  /__
 /  / /  __  \ \  \ /  _   _  \ /  ___  \ /  _   _  \/_   ___/
/  / /  /_/  / /  //  //  //  //  /__/  //  //  //  / /  /___
\  \ \___,_  \/  //__//__//__/ \____   //__//__//__/  \_____/, inc.
 \  \______\____/             _____/  /
  \_______/                   \______/  http://www.mgmt-inc.com