How about submitting to a DTML method that calls some python to split() on ',' then mung the parts back together, and call the zSQL to insert the float? -- David On Aug 31, 2004, at 2:16 PM, hpinson@indepthl.com wrote:
Hi. I'm not sure if this is a zope question, but...
I have a client who is insisting on being able to enter numeric data into an HTML form (dtml-method in this case) using commas or not:
9999.00 or 9,999.00
I can output float information from the database ok, using the thousands_commas directive, however input and submission of a form using commas causes an error.
I've even tried to strip commas in the ZSQL Method update statement:
UPDATE ... total_area=TRIM(',' FROM <dtml-sqlvar total_area type=float>), ...
but that does not seem to work either.
Any suggestion on how to allow this behavior?
BTW, this is legacy DTML. I cannot use ZPT here easily.
Harlow Pinson Indepth Learning Email: hpinson@indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )