[Zope-DB] optional argument, can it be an empty string

[Kevin Gill]

I have a table with forty fields. I use a single Z SQL Method, from different places in my code, passing different parameters.

<params>AccountId ControlClientId:optional  Mobile:optional </params>

update MyAccount 
set
    <dtml-if ControlClientId>
        ControlClientId = <dtml-sqlvar ControlClientId type=int>,
    </dtml-if>
    <dtml-if Mobile>
        Mobile = <dtml-sqlvar Mobile type=string>,
    </dtml-if>
    accountid = <dtml-sqlvar accountid type=int>
where 
    accountid = <dtml-sqlvar accountid type=int>


When I pass in an empty 'Mobile', the above code does not distinguish this from an empty string, and the database column is not updated.

Can I detect whether an string was passed in, even if it is empty?

Thanks in Advance

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20041105/6c4df0ab/attachment.htm