- a big problem i am dealing with is that the data is coming back from my database as strings all the time. As a result whenever the forum code tries to make a comparison (ie. if a=b then...) i get a datatype mismatch error. SO the way i fixed this was by manually converting all the data to numbers using the vbscript function CLng. so that worked.
Actually, all number fields from Oracle are being returned as Decimal variables in VBScript (You can check this using the VarType function).
The odd thing is that when you compare two Decimal variables in VBScript it returns back a Type Mismatch Error. So you either need to convert both variables to Integers or Stiings when you need to compare them.
This seems to be a problem with VBScript and will require a lot of CLng adding in a lot of places throughout the ASP code.<
I have been reading these messages. I can not tell if there is a "finished" version using Oracle or not. Can anyone summarize the status? Can we 'divide up' what is left to do?<
pweighill that was the problem i was having. I keep using cInt everytime i encounter a type mismatch error which is pretty often...i've changed alot of them, but im sure more will pop up as the forum is used.<
I think it would be better to use cLng rather than cInt since cInt will only work for numbers up to 32768.
I got a bit sick of going through all the asp code and adding cLng to the code so I gave up at that point. (I didn't NEED an oracle version, I was just trying to see if it could be done)<
Forum Locked
Posted - 25 November 2002 : 18:39:30
