| Author |
 Topic  |
|
Kenno
Average Member
Cambodia
846 Posts |
 Posted - 21 January 2001 : 05:48:07
|
Thanks for the icons. 
÷§÷ Kenno ÷§÷ |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 21 January 2001 : 06:57:58
|
You were right Richard, missed out a comma, I had fixed the zipped file, but didn'y upload the change to my own forum.
'Resistance is futile' |
|
|
|
bpatti
Starting Member
USA
11 Posts |
Posted - 21 January 2001 : 16:17:32
|
The file I downloaded does not list properly when searching on the letters only (A,B,C,D...)
I thought it's supposed to list all members that start with that specific letter, but it doesn't.
The members search at The Mushroom Grove works correctly.
Am I missing something?
Thanks |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 21 January 2001 : 16:37:41
|
Redownload the file now, there was a check missing in an if then
'Resistance is futile' |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 21 January 2001 : 16:38:30
|
* Scratching head *
I'm still getting this error using a default of SR4:
<------------- yuck ----------->
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/Snitz_Forums_SR4/members.asp, line 224
<----------- /yuck ------------>
Am I perhaps dl'ing the wrong file? ( http://195.149.32.155/tools/uploads/members2.txt )
-Kerry
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 21 January 2001 : 16:41:56
|
Line 224 is this rs.cachesize=20 try commenting out to see if it removes your error
'Resistance is futile'
as a check, above this line rs.open strSql, my_conn, 3
plut response.write strSQL
could you post the string it produces, it will help to track down the prob
Edited by - huwr on 21 January 2001 16:45:46 |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 21 January 2001 : 16:50:45
|
I think our line numbering is a bit different - it may be 226 for you.
The sting I get back is:
SELECT FORUM_MEMBERS.MEMBER_ID, FORUM_MEMBERS.M_STATUS, FORUM_MEMBERS.M_NAME, FORUM_MEMBERS.M_LEVEL, FORUM_MEMBERS.M_EMAIL, FORUM_MEMBERS.M_COUNTRY, FORUM_MEMBERS.M_HOMEPAGE, FORUM_MEMBERS.M_ICQ, FORUM_MEMBERS.M_YAHOO, FORUM_MEMBERS.M_AIM, FORUM_MEMBERS.M_TITLE, FORUM_MEMBERS.M_POSTS, FORUM_MEMBERS.M_LASTPOSTDATE, FORUM_MEMBERS.M_LASTHEREDATE, FORUM_MEMBERS.M_DATE, FORUM_MEMBERS.M_PMRECEIVE FROM FORUM_MEMBERS WHERE FORUM_MEMBERS.M_STATUS = 1 ORDER BY FORUM_MEMBERS.M_POSTS DESC, FORUM_MEMBERS.M_NAME ASC
Thanks!
-Kerry
|
|
|
|
bpatti
Starting Member
USA
11 Posts |
Posted - 21 January 2001 : 18:22:27
|
HuwR,
it's working fine now!!!
Thanks for the quick response (as always) |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 23 January 2001 : 00:10:23
|
Any ideas on what I'm doing wrong here? - I'm still stumped on this one. 
-Kerry
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 23 January 2001 : 04:54:52
|
Hmm, there is nothing wrong with the SQL produced, so why it should fail, I don't know. try redowloading the file again
'Resistance is futile' |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 January 2001 : 05:01:23
|
Kerry,
Do you have the Private Messages Mod installed?
If not, you need to take out the reference to MEMBERS.M_PMRECEIVE |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 23 January 2001 : 05:08:37
|
good point Richard, missed that one
'Resistance is futile' |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 23 January 2001 : 10:20:33
|
quote:
just download the linked file, and replace your members.asp with the new one.
coded using 3.1 sr4.
'Resistance is futile'
Hi,
Would this mod work with 3.1 sr3.? If not would it be reasonable to get it working for sr3?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 23 January 2001 : 15:08:10
|
As far as I can tell it should be OK, there were no major changes to the MEMBERS table.
'Resistance is futile' |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 23 January 2001 : 16:17:56
|
quote:
Do you have the Private Messages Mod installed...
* BINGO! *
That was it, Richard - thank you!
-Kerry
|
|
|
|
Topic |
|
Topic Locked
