For some reason I always use Cint() function to convert the number-looking strings. I always think that "int" is same as the one in SQL. The other day, one of the web site blew up after a year: Overflow: 'Cint'
The increasing number in the database was passed by querystrings. In the ASP I was converting it using Cint(). When the number reached at 32769 in the database, BOOM! I try to use CLng() from now on. Cint() is like a time bomb for this kind of applications.
The increasing number in the database was passed by querystrings. In the ASP I was converting it using Cint(). When the number reached at 32769 in the database, BOOM! I try to use CLng() from now on. Cint() is like a time bomb for this kind of applications.
I used to write w/ the CInt(), but now I only do it if I know there isn't ever going to be a big number.