RE: Witango-Talk: Numeric Field Formatting??

[Michael Dittbrenner]

The code is pasted from app and I tried both of the formats that you list and neither of them worked..... Cecilia C. Cos Data Analyst Newsweek | 251 W 57th Street | New York, NY | 10019 212-445-4309 [EMAIL PROTECTED] "Wilcox, Jamileh (HSC)" <[EMAIL PROTECTED]> 06/18/2004 01:29 PM Please respond to [EMAIL PROTECTED] To <[EMAIL PROTECTED]> cc Subject RE: Witango-Talk: Numeric Field Formatting?? According to the docs, your setup should work as long as your packet key is an integer, as in your example.  I'm not sure why it's adding zeroes - is the code here pasted from your app or retyped?   If your value is an integer, try one of these for your format & see if they work better:   num:simple-integer num:,,0,,,,-,     -----Original Message----- From: Cecilia Cos [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 12:12 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Numeric Field Formatting?? Hello, So I have a numeric field in SQL 2000 and have the info below in an updatable record detail <TR VALIGN=TOP ALIGN=LEFT>        <TD>                Packet Key #:        </TD>        <TD>                <@COLUMN "PELog.KeyNo" FORMAT="num:,,,'@@decimalChar',,,'-',">        </TD> </TR> but for some reason....the field keeps getting formatted and it comes out like this Packet Key #: 123,123.00 but in the table it is 123123 which is what I want.... Any thoughts or suggestions? Cecilia C. Cos Data Analyst Newsweek | 251 W 57th Street | New York, NY | 10019 212-445-4309 [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf How about something like   <@COLUMN "PELog.KeyNo" format=num:comma-integer>   **************************************** Educational Directories Unlimited, Inc.   Michael Dittbrenner Programmer http://www.StudyAbroad.com http://www.GradSchools.com A service of EDU, Inc... http://www.EDUdirectories.com A partner of EDU Internet Strategies: http://www.EDUInternetStrategies.com/   [Phone]  610-499-9200 [Fax]    610-499-9205 [E-mail] [EMAIL PROTECTED]  or [EMAIL PROTECTED]   -----Original Message----- From: Cecilia Cos [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 2:27 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Numeric Field Formatting??     ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf