| Oracle Number data type [message #372207] |
Thu, 18 January 2001 17:12 |
Tam
Messages: 6
Registered: January 2001
|
Junior Member |
|
|
I'm querying from Oracled db and one of my table have a field with a data type with size 38, Number(38). When i display the recordset from the query in a grid control on an ASP page, it also displays the leading 0's (38 times) up to the number. How do i go about deleting this?? Is this normal in Oracle? It displays the right number if i do:
checkfield = recSet.fields("mgcplog_id")
msgbox checkfield
Please help!!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
