| Author |
 Topic  |
|
|
Rahanini
Starting Member
35 Posts |
 Posted - 24 September 2002 : 19:47:07
|
My question is regarding a datatype mismatch error. The error is coming back in default.asp when
CatID = allForumData(fCAT_ID, iForumCheck)
it seems that CatID is a number and the value returned by allForumData is also a number. HOwever I am getting this type mismatch error.
I searched for the Function allForumData however did not find any subroutine declaration. i am very confused as to how allForumData is being passed values without it being a function. Is this a VB script thing that I am not understanding?
the closest thing I found that gave allForumData a value was the following:
allForumData = rs.GetRows(adGetRowsRest)
but Now this confuses me cause it seems like allForumData is a variable...however it is not declared anywhere.
Help would be very appreciated. Thank You.
samir. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Rahanini
Starting Member
35 Posts |
Posted - 24 September 2002 : 20:26:20
|
| i am using 3.4.03 |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 September 2002 : 21:12:23
|
| is this a brand new install? If so, did you run setup.asp ? |
|
|
|
Rahanini
Starting Member
35 Posts |
Posted - 24 September 2002 : 21:32:11
|
yes i did run setup.asp...
could you tell me anything about allforumdata? is it a function, variable??...and if its a function how is it declared...and if its a variable how does it get passed values...
thank you |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 September 2002 : 21:33:39
|
| it's an array that holds all of the data from the Database Query. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Rahanini
Starting Member
35 Posts |
Posted - 24 September 2002 : 22:33:08
|
yes it did work correctly. I did some stuff to the database and these problems are happening.
so when the forum says this:
CatID = allForumData(fCAT_ID, iForumCheck)
and allForumData is an array...is it placing the values fCAT_ID and iForumCheck inside the array allForumData then CatID becomes a new array...or something else. basically what happens to CatID.?
thank you |
Edited by - Rahanini on 24 September 2002 22:37:40 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 September 2002 : 22:42:46
|
| What exactly did you do to the database? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Rahanini
Starting Member
35 Posts |
Posted - 25 September 2002 : 05:47:53
|
Well I have been attempting to port this Forum to Oracle. I am getting close but while debugging I just need to know what various functions in the forum are doing. This is why I am asking how allForumData etc is getting values. I now understand how this works though with your help.
The problem I am facing with datatype mismatch errors is that for some reason, though I have set up the database in Oracle identical to that in access, when the forum brings information back from the Oracle Database, it always brings it back as a string....even when sometimes i need a number. So this is why this error is happening. I need to figure out what is going on that makes the data coming from Oracle always be a string and how to change this so that it brings back the correct type, a string or a number.
I think it has to do with the way i have set up the tables in oracle...i might be missing something somewhere....i have been posting questions on various sites trying to figure this out. but for these forum specific questions, rather that spending all this time trying to understand it, i figure why not just ask you guys, the developers. =) |
|
|
|
Rahanini
Starting Member
35 Posts |
Posted - 26 September 2002 : 22:22:43
|
i fixed this problem by forcing the variables comming back from the database to numbers using the vbscript function CLng
thought id just end this topic with a solution |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
