| Author |
 Topic  |
|
mortioli
Average Member
United Kingdom
898 Posts |
 Posted - 06 April 2002 : 07:35:38
|
Hi.
I run version 3.3.03 of the Snitz Forum, and wondered if its possible to have the inc_topmembers.asp file on my home page.
When I do put it on, it shows up, but where the members should be, it says this:
Microsoft JET Database Engine error '80040e14'
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
line 128
Line 128 is this:
set rstopmem = my_conn.execute (query)
Thanks for your help!
Oli
www.mortioli.co.uk |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 06 April 2002 : 11:00:41
|
the SELECT query uses a variable that you don't have
Crash's Site | Crash is from 
|
 |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 06 April 2002 : 13:42:10
|
So how would I get this to work?
Oli
www.mortioli.co.uk |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 06 April 2002 : 18:19:57
|
the SELECT query requests a number of variables from the DB. to make this work, make sute to have them in the DB.
Crash's Site | Crash is from
|
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 07 April 2002 : 05:53:56
|
Well could you say which variables, and how I can add these to make the MOD work!?
Oli
www.mortioli.co.uk |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 07 April 2002 : 06:20:25
|
mortioli, could you post the lines leading up to line 128 please?
It might also help if you inserted this right above line 128 and posted what it spits out at you.
response.write strsql
response.end
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 07 April 2002 : 06:21:28
|
try this
find this:
app = "Members"
apptitle = "Members"
strShow = "strShow" & app
strSize = "strSize" & app
window = app & "Window"
add below that:
Dim intMemberItems
intMemberItems = "5"
Crash's Site | Crash is from
|
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 07 April 2002 : 06:36:33
|
I tried Crash's idea, and it showed the members fine, but gave me this error at the end:
Type mismatch: 'displayDate'
line 191
Line 191 is:
Response.Write "<font face=" & strDefaultFontFace & " size=" & strFooterFontSize & " color=" & strDefaultFontColor & ">Date: " & displayDate(rstopmem("M_DATE")) & "</FONT>"
Nathans idea gave out this:
SELECT count(UserID) AS [ActiveCount] FROM FORUM_ONLINE WHERE Right(M_BROWSE, 8) = 'chat.asp'
Thanks for the help!
I really appreciate it!
Oli
www.mortioli.co.uk
www.mortioli.co.uk/forum |
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 07 April 2002 : 07:57:37
|
Also, where does it look for the stars images?
I have them in the forum folder, in forum/images, and in forum/include, but they still don't show up.
Oli
www.mortioli.co.uk
www.mortioli.co.uk/forum |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 07 April 2002 : 10:40:36
|
that is only in my own version of the include. the standard top 5 members include does not show stars. i modded the file.
could you post your SELECT query?
Crash's Site | Crash is from
Edited by - crash on 07 April 2002 10:46:35 |
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 07 April 2002 : 16:12:55
|
I'm not which you wanted, so here they all are:
query = "SELECT MEMBER_ID, M_NAME, M_POSTS, M_DATE FROM " & strMemberTablePrefix & "MEMBERS WHERE M_STATUS=1 ORDER BY M_POSTS DESC LIMIT " & intMemberItems
query = "SELECT TOP " & intMemberItems & " M_LEVEL, MEMBER_ID, M_NAME, M_POSTS, M_DATE FROM " & strMemberTablePrefix & "MEMBERS WHERE M_STATUS=1 AND M_POSTS >=1 ORDER BY M_POSTS DESC"
query = "SELECT MEMBER_ID, M_NAME, M_POSTS, M_DATE FROM " & strMemberTablePrefix & "MEMBERS WHERE M_STATUS=1 ORDER BY M_DATE DESC LIMIT " & intMemberItems
query = "SELECT TOP " & intMemberItems & " M_LEVEL, MEMBER_ID, M_NAME, M_POSTS, M_DATE FROM " & strMemberTablePrefix & "MEMBERS WHERE M_STATUS=1 AND M_POSTS >=1 ORDER BY M_POSTS DESC"
Cheers!
I've got the stars working!
Heres the page if you need to see whats up with it:
Testing Top Members
Ignore lack of images, etc etc. Its only testing!
Thanks again!
Oli
www.mortioli.co.uk
www.mortioli.co.uk/forum |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 07 April 2002 : 16:47:34
|
it looks like the new members cannot be listed.
find the very last SELECT query and remove the red part from it:
query = "SELECT TOP " & intMemberItems & " MEMBER_ID,
Crash's Site | Crash is from
|
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 07 April 2002 : 16:56:21
|
Same error!
Oli
www.mortioli.co.uk
www.mortioli.co.uk/forum |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 07 April 2002 : 17:01:31
|
post a link to a zipped version of this file
Crash's Site | Crash is from
|
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 07 April 2002 : 17:07:08
|
Zipped File
Thanks for all the help!
Oli
www.mortioli.co.uk
www.mortioli.co.uk/forum |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 07 April 2002 : 17:16:13
|
alright. you have my version of the inc_topmembers.asp
as said in my FL, this does not function on your version of the code. why doesn't anyone read the info that is written there?!?!
Crash's Site | Crash is from
|
|
|
|
Topic |
|
Topic Locked
