Thanks Chris, it works. It's a little more typing but that's why they created cut & paste. -----Original Message----- From: Chris Kratz [mailto:chris.kratz@vistashare.com] Sent: Tuesday, August 13, 2002 9:40 AM To: McDonnell, Larry; 'Zope@Zope. Org' (E-mail) Subject: Re: [Zope] Trapping for empty fields Hi Larry, There is probably a cleaner way to do it, but we use dtml-if's to determine whether to insert a string or a null. It's not terribly pretty, but it works. ie INSERT INTO some_table(some_field) VALUES(<dtml-if form_field><dtml-if "form_field ==''">NULL<dtml-else><dtml-sqlvar form_field type=string></dtml-if><dtml-else>NULL</dtml-if> The first test if to make sure the variable exists and is not None, so if you know it always will exist, you only need to test whether or not the string is empty. You may even have luck with sqltest in an update statement and the optional keyword. Hope that helps, -Chris On Tuesday 13 August 2002 09:23 am, McDonnell, Larry wrote:
Hi,
I am using MS Access dbs for storage (company policy). I am starting to create online forms so the company can collect data. There were some dbs already created that they want access via a web browser. Some of the fields are empty and when I try to update the record using my ZSQL Method I get the following error message:
Error Type: sql.error Error Value: ('S1000', -3702, "[Microsoft][ODBC Microsoft Access Driver] Field 'units_in_service.Hydration' cannot be a zero-length string.") How do I trap for this error? Examples and pointers will be greatly appreciated. Thanks in Advance.
Larry McDonnell
Proton Energy Systems 50 Inwood Rd. Rocky Hill, CT 06067 (860) 571-6533 ext. 531 Email:lmcdonnell@protonenergy.com www.protonenergy.com
_______________________________________________ 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 )
-- Chris Kratz Systems Analyst/Programmer VistaShare LLC www.vistashare.com