Text only input drops leading zeros
Idomeneo | Posted 1:36pm 18. October 2007 Server Time |
I am working with lesson 21 (moddata.asp).
I have a text field in the form 00-001.
These fields are stored in an ACCESS table that is set to TEXT.
Using moddata.asp and the link UPDATE, when I change a field such as 00-031 on refresh the new data changes to -31.
Next I tried to get rid of leading zeros by changing the number to 2000-001.
Upon refresh I got 1961... it subtracted the text.
Any thoughts on this?
|
|
|
