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
