Help [Woody] Decimal Format incorrect from binding

[JD Daniels]

This is probably and easy fix.. I am very tired....

I have in a mysql table:

assetRetail DECIMAL (9,2)

My woody Definition:
       <wd:field id="assetRetail">
           <wd:label>Assest Retail $</wd:label>
           <wd:datatype base="decimal"/>
           <wd:convertor variant="number">
               <wd:patterns>
                   <wd:pattern>#########.##</wd:pattern>
               </wd:patterns>
           </wd:convertor>
       </wd:field>
My Woody Binding:
   <wb:value id="assetRetail" path="InventoryItem/assetRetail">
       <wd:convertor datatype="decimal" type="formatting">
           <wd:patterns>
               <wd:pattern>#########.##</wd:pattern>
           </wd:patterns>
       </wd:convertor>
   </wb:value>
The Problem is, when i load a form, the values are formatted incorrectly...
value one 800.00
value two 5984.00
Loads into the input with 800 and 5,984 not 800.00 and 5984.99 as i 
would expect
which means if the user just hits save, 5.00 gets entered into the database.

where in the heck do I stop woody from being so (un)helpful?

JD

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]