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
|
|
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
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
