This has got me baffled to no end...
I have a numeric column, say TypeID in a table.
I write the query to retrieve the ID into the recordset.
I do a loop and compare the id against 1 -(number one)
It throws a data type mismatch and it goes off if i wrap both of them in a cint or cdbl function.
Any idea why it is giing an error.
BTW.. I'm using sql2k and IIS6
I did dome R&D and found this link..
There is a know issue for oracle db.. but any one knows of such a problem with sql??