| Author |
 Topic  |
|
|
FIRLAMA
Starting Member
29 Posts |
 Posted - 23 April 2001 : 08:21:47
|
Ok, i got i problem..im using my forum on my webserver for testing purposes, but today i got a weird problem when i was looking at the members page (members.asp). Everything wors fine untill i try to look at page 2 of my memberslist. i thought i messed up the code again so i put back the original members.asp from "Snitz_Forums_2000_V3_1_SR4.zip"..checked and again i got the same problem, so pls anyone help??? my webserver aint online all the time so im also gonna write the problem here
[size=1]
Technische informatie (voor ondersteunend personeel)
Soort fout:
Microsoft JET Database Engine (0x80040E14)
De component ORDER BY bevat een syntaxisfout.
/members.asp, line 125
Soort browser:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Pagina:
GET /members.asp
Tijd:
Monday, April 23, 2001, 2:26:28 PM
[/size]
my webserver url = http://212.120.101.189/members.asp
|
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
Posted - 23 April 2001 : 08:33:28
|
what is line 125 of members.asp?
|
 |
|
|
FIRLAMA
Starting Member
29 Posts |
Posted - 23 April 2001 : 08:37:52
|
quote:
what is line 125 of members.asp?
if not rsCount.eof then
maxpages = (rsCount("PAGECOUNT") \ strPageSize )
if rsCount("PAGECOUNT") mod strPageSize <> 0 then
maxpages = maxpages + 1
end if
maxRecs = cint(strPageSize) * maxPages
else
maxpages = 0
end if
rsCount.close
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
end if
But im sure of it i didnt mess up this part, cause this one is taken from the original wich also wont work!
the green text is line 125
Edited by - FIRLAMA on 23 April 2001 08:38:57 |
|
|
|
FIRLAMA
Starting Member
29 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 23 April 2001 : 11:24:25
|
Could you translate the error into english please.
Also the code you posted is MySql specific. So I would think you are using MySql as your database type then, right?
|
|
|
|
FIRLAMA
Starting Member
29 Posts |
Posted - 23 April 2001 : 13:57:59
|
quote:
Could you translate the error into english please.
Also the code you posted is MySql specific. So I would think you are using MySql as your database type then, right?
hey, a lot of kisses to youuu DAVIO !!! 
i just checked my config.asp and noticed that i had checked mysql instead of access ! and this all thanks to your reply! tnx again!
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 23 April 2001 : 16:41:43
|
 Well I'll only take the kisses if you're female.
And You're Welcome. Someone else had the exact same problem.
|
|
|
| |
Topic |
|
Topic Locked
