| Author |
 Topic  |
|
|
wolv
Starting Member
13 Posts |
 Posted - 13 February 2006 : 19:41:44
|
I receive this crash, after clicking on the Members page link from the top right hand menu. The members page loads, but when I try to locate a user using the A-Z listing, the page crashes.
I am using Snitz version 3.4 with MS SQL...
Here is the error message:
Technical Information (for support personnel)
* Error Type:
Microsoft JET Database Engine (0x80040E14)
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/forum/members.asp, line 233
* Browser Type:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.9) Gecko/20050711 Firefox/1.0.5
* Page:
GET /forum/members.asp
* Time:
Monday, February 13, 2006, 5:41:23 PM
* More information:
Here is the code that is referenced. Can anyone tell me what to edit or change?
else 'end MySql specific code
set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize = strPageSize
rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic (LINE 233-referenced in error message)
If not (rs.EOF or rs.BOF) then
rs.movefirst
rs.pagesize = strPageSize
rs.absolutepage = mypage '**
maxpages = cLng(rs.pagecount)
arrMemberData = rs.GetRows(strPageSize)
iMemberCount = UBound(arrMemberData, 2)
else
iMemberCount = ""
end if
rs.Close
set rs = nothing
end if
Thanks guys.
-Wolv |
Edited by - wolv on 13 February 2006 19:44:53 |
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 13 February 2006 : 20:12:02
|
| You'll have to show us the lines that define strSql, strSql2, strSql3 & strSql4, or just upload a text version of your members.asp page. |
eXtremeGossip  |
 |
|
|
wolv
Starting Member
13 Posts |
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 13 February 2006 : 20:48:14
|
On second thought, do a Response.Write strSql & strSql2 & strSql3 & strSql4 right before line 233 - That would probably make spotting the error easier  |
eXtremeGossip |
|
|
|
wolv
Starting Member
13 Posts |
Posted - 13 February 2006 : 21:10:52
|
Jorrit,
This text shows up at the top of members.asp after implementing your line of code, saving the file and reuploading to the server:
SELECT MEMBER_ID, M_STATUS, M_NAME, M_LEVEL, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_PMRECEIVE FROM FORUM_MEMBERS WHERE M_NAME <> 'n/a' ORDER BY M_POSTS DESC, M_NAME ASC
-Wolv |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 13 February 2006 : 21:17:02
|
Hm, I don't see anything wrong with that at first glance. Maybe someone sharper can spot the error  |
eXtremeGossip |
|
|
|
wolv
Starting Member
13 Posts |
Posted - 13 February 2006 : 22:11:18
|
Joritt,
I scanned the first SELECT statement and it was fine. The one below that one however, had TWO commas in it, and I deleted the extra comma, resaved and reuploaded and voila! She works!!
I took out the response.write statement that you had me add, and now everything is fine.
Thanks for your help, once again!
-Wolv |
|
|
| |
Topic |
|
|
|
Topic Locked
