thank you for the prompt reply. I am also running this with Oracle and have been working on moving things over. Things are going smoothly except when there is nothing in the tables i dont get the following error...however...when there is something in the table i get the error. I have declared Cat_id in forum_forum as a number. from 3.4.01 to 3.4.03 were there any types in the database changed?
I am real confused as to why this might be occuring, as I Dont understand the error. What does this do?
I am not at all familiar with Oracle. I don't even know of Oracle supports GetRows.
Line 244 gets all of the data specified in the query and loads it into an array. That is how GetRows works. It gets all of the data from the query at once, so you can close the connection sooner.
when I put an On Error Resume Next...the whole default.asp page loads but...the tables are not being drawn properly. All the data values are there from the database...but the columns are wrong sizes and dont line up. the last column heading "Moderators" is cut short and there is a big black box after the moderators column.directly below the black box is the last post column contents...but the last post header is shifted to the left.
so getrows is an asp function. so i should check if oracle supports it and if it doesnt what the equivalent is. But thats strange because the data from the oracle database comes back properly and is displayed in the correct columns...
Edited by - Rahanini on 19 September 2002 20:11:22
the data mismatch error was comming in several places on the page...i just put the on error resume next and it loaded up. the other places they were comming up was in the statements :
if ModerateAllowed = "Y" and ForumTopicUReplies > 0 then...
and anywhere else the above variables were...again there werent that many. But what i dont get is that when you declare something like intpostcount...its just declared in vbscript as dim...so why is there a datatype mismatch?
so getrows is an asp function. so i should check if oracle supports it and if it doesnt what the equivalent is. But thats strange because the data from the oracle database comes back properly and is displayed in the correct columns...
This is an ADO method. I don't think it depends on the provider. I can't be sure about this, though.
the data mismatch error was comming in several places on the page...i just put the on error resume next and it loaded up. the other places they were comming up was in the statements :
if ModerateAllowed = "Y" and ForumTopicUReplies > 0 then...
and anywhere else the above variables were...again there werent that many. But what i dont get is that when you declare something like intpostcount...its just declared in vbscript as dim...so why is there a datatype mismatch?
Sometimes there are problems mixing string and numeric types. I've also found that comparing strings using '=' sometimes gives errors. Could never understand why though, since it seems to work well other times. Anyway because of this I always use strComp() to compare strings.
Topic Locked
Posted - 16 September 2002 : 23:09:58
