datatype mismatch error
Hello ,
I am running an ASP Application from which I am calling my Oracle 8i Database. I have created all my tables declaring variables number, char, varchar2, etc
The problem I am having is that when I bring information back from the database it only comes back as strings when I want to bring back numbers. I am confused because the database types for the particular variables I am bringing back are declared as Number(5,0) or Number(10,0).
My asp application is developed using vbscript. One such example of this is:
dim temporary
temporary = 0
if temporary = allforumdata(a,b) then do something....
the error happens when it tries to compare temporary to allforumdata(a,b) which is an array that contains data that was brought back from the database.
I have the application running correctly in access but in oracle these problems show up, So im not sure if it is something wrong with my code, or some setting that i am not doing in the database. Any help would be very much appreciated.
Thank you.