I am using the Znolk Input Wizzard with postgresql tables. One of the variables in the table is an integer and can have null values. However, in the update and insert forms, if I attempt to leave the value null, I get the following error from Zope: "Invalid integer value for weight.bcs" The variable is defined throughout as :<dtml-var bcs null=""> Any help would be appreciated.
How about <dtml-var bcs null=0>? (Just a guess, but I would expect a zero length string to be an invalid integer value).
I am using the Znolk Input Wizzard with postgresql tables. One of the variables in the table is an integer and can have null values. However, in the update and insert forms, if I attempt to leave the value null, I get the following error from Zope:
"Invalid integer value for weight.bcs"
The variable is defined throughout as :<dtml-var bcs null="">
I will fix this for the next release (est. next week). This happens when nothing is entered in the textfield for the integer value. In the meanwhile you have to do the check in the insert/update SQL method: <dtml-if "_['btest.val']!=''"> <!--#sqlvar btest.val type=int --> <dtml-else> null </dtml-if> *********** REPLY SEPARATOR *********** On 13.08.2000 at 10:31 Herring, William O. wrote:
I am using the Znolk Input Wizzard with postgresql tables. One of the variables in the table is an integer and can have null values. However, in the update and insert forms, if I attempt to leave the value null, I get the following error from Zope:
"Invalid integer value for weight.bcs"
The variable is defined throughout as :<dtml-var bcs null="">
Any help would be appreciated.
_______________________________________________ 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 )
participants (3)
-
Herring, William O. -
Philipp Auersperg -
Richard Folwell