| Author |
 Topic  |
|
|
bobbart
Junior Member
USA
163 Posts |
 Posted - 19 August 2002 : 21:28:29
|
After doing what was told in the other post I had. I now get this error.
ADODB.Recordset.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/default.asp, line 172
'############################## Group Cat MoD #####################################
strSql = strSql & " ORDER BY CAT_ORDER ASC, CAT_NAME ASC;"
set rs = Server.CreateObject("ADODB.Recordset")
'rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
rs.open strSql, my_Conn
if rs.EOF then
recCategoryCount = ""
else
Line 172-->allCategoryData = rs.GetRows(adGetRowsRest)
recCategoryCount = UBound(allCategoryData,2)
end if
rs.close
set rs = nothing
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 21:48:25
|
| change adGetRowsRest to -1 |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 21:49:34
|
| are you sure you tried the 1st option I gave you in the other thread? It looks as the the ADO Constants aren't defined and that may be what's causing your problem. If so, I could show you how to define them, and it would save you having to go through the file and change them manually in the code. |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 21:58:21
|
quote:
Originally posted by RichardKinser
change adGetRowsRest to -1
So take out (adGetRowsRest) and enter -1 ?
I tried that and the error was still there. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 22:04:27
|
sounds like v3.4 isn't going to work on that server then. I'm not sure why it's not supporting pretty basic things. they might be running an old version of Chili!ASP, or something isn't configured correctly.
you could try changing this:
rs.GetRows(adGetRowsRest)
to this:
rs.GetRows()
or just to this:
rs.GetRows
and see if those work, I'm not sure they will though. |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 22:07:14
|
| They said they just installed the updates for it. He says its set right. I dont know what to do. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 22:23:39
|
did you try using just:
rs.GetRows
? |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 22:30:09
|
| nop. I just changed all the pages back to the way they were. I will try this again. Man I want to get this to wrk the way it is. I hate hacking the code to force it to work when it should work the way it is. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 22:31:58
|
v3.4 was tested on a Unix/Linux server using MySQL and didn't have any problems. It must be a setting or a version problem, I can't think of any other reason it wouldn't work.
what is the URL to the server where you are trying to install this? Just need the homepage URL. |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 20 August 2002 : 04:13:24
|
| Server identified itself as: Apache/1.3.20 Sun Cobalt (UNIX) Chili!Soft-ASP/3.6.2 PHP/4.1.2 |
|
|
| |
Topic |
|
Topic Locked
