| Author |
 Topic  |
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
 Posted - 04 January 2001 : 20:18:39
|
How about this
New members.asp Demo
Paging is relative to the search results, to clear search results and show all members, just do a blank search against usernames.
Pressing the letters A..Z will search for membes whos username starts with the selected letter
<font color=blue>'Resistance is futile'</font id=blue>
Edited by - huwr on 23 January 2001 21:06:19 |
 |
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 04 January 2001 : 21:42:45
|
HuwR,
is the link : srchmembers.asp (4jan) the same file as the later: New members.asp Demo (4jan01)?
Thanks,
Wedont
snitz ver3.1 sr2 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 04 January 2001 : 22:31:14
|
The new link uses the existing members.asp, at the moment it is just a link for feedback, will post code later
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
hamb0n3z
Starting Member
USA
44 Posts |
Posted - 04 January 2001 : 23:19:04
|
Trying out different combinations I came across this:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression '(FORUM_MEMBERS.M_NAME LIKE '%hambon3z%' OR FORUM_MEMBERS.M_USERNAME LIKE '%hambon3z%'FORUM_MEMBERS.M_LASTNAME LIKE '%hambon3z%' )'.
/mushroomgrove/members2.asp, line 183
I had member and last name checked with hambon3z as the input. The key I think was doing the search after having selected a letter from the index.
So if you select a letter from the index and then do a search you should be able to recreate this error.
<img src=icon_smile_cool.gif border=0 align=middle>
"Hold on pickle." - Out of the blue while watching TV my 31/2 yr old niece pretends to drive fast with half eaten pickle in hand.
Edited by - hamb0n3z on 04 January 2001 23:20:24 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 January 2001 : 03:23:21
|
Fixed that, it was a problem with the checkboxes not the letters.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 05 January 2001 : 03:47:54
|
HuwR.. I like what you did with the search can you post or email me the code?
Thanks
Rick
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 January 2001 : 09:06:33
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
HuwR.. I like what you did with the search can you post or email me the code?
Thanks
Rick
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Code will be posted soon, still testing bits and pieces, have added an Icon so that if you are admin it allows you to set the user as a moderator, or remove their moderator status.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 05 January 2001 : 12:45:14
|
good job HuwR.
I got one question though, if you don't require your users to enter their names and then a user decides to search by names instead by usernames, what kind of error or result would pop up?!
ô¿~ |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 January 2001 : 13:02:49
|
It just wouldn't find anything
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 05 January 2001 : 13:33:02
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
How about this
New members.asp Demo
Paging is relative to the search results, to clear search results and show all members, just do a blank search against usernames.
Pressing the letters A..Z will search for membes whos username starts with the selected letter
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Huw,
The only thing I can see that would need to be different is the actual list of letters and different characters that are used... so you don't end up with blank pages :)
<center>Reinsnitz (Mike)
<font color=red>><)))'></font id=red>
"The glory of young men is their strength, and the honor of old men is their gray hair." - Proverbs 20:29
</center> |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 January 2001 : 14:03:35
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
How about this
New members.asp Demo
Paging is relative to the search results, to clear search results and show all members, just do a blank search against usernames.
Pressing the letters A..Z will search for membes whos username starts with the selected letter
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Huw,
The only thing I can see that would need to be different is the actual list of letters and different characters that are used... so you don't end up with blank pages :)
<center>Reinsnitz (Mike)
<font color=red>><)))'></font id=red>
"The glory of young men is their strength, and the honor of old men is their gray hair." - Proverbs 20:29
</center>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<img src=icon_smile_question.gif border=0 align=middle>
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 05 January 2001 : 14:44:11
|
in your example page, you have a hard coded list from A-Z... and if there are no members with the letter clicked... you get a page that says "No Members Found"... this can be espeicaly detering when you have a new forum... and not many users.
what I'm saying is that you also miss the other characters that can be used in names such as !@#$%^&*() etc... so a general parse of all the names for first letters would be needed
then to list tehm and make them links that actualy search for names begining with those characters.
<center>Reinsnitz (Mike)
<font color=red>><)))'></font id=red>
"The glory of young men is their strength, and the honor of old men is their gray hair." - Proverbs 20:29
</center> |
|
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 07 January 2001 : 09:21:23
|
Always thinking! I like that <img src=icon_smile.gif border=0 align=middle>
One problem with that, although a small one. What if you have 30,000 members? Wouldn't that degrade performance fairly seriously while someone is browsing the mambers?
Scott LeMieux
Ready... Fire... Aim!! <img src="http://www.thepercussionist.com/adf/dance2.gif" border=0> |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 07 January 2001 : 09:35:36
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Always thinking! I like that <img src=icon_smile.gif border=0 align=middle>
One problem with that, although a small one. What if you have 30,000 members? Wouldn't that degrade performance fairly seriously while someone is browsing the mambers?
Scott LeMieux
Ready... Fire... Aim!! <img src="http://www.thepercussionist.com/adf/dance2.gif" border=0>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
it is not really doing anything differently than the search.asp, which would proably have the same problems if you had 30000 users and their subsequent posts. It would probably help matters to index the members DB on the fields that are used in the search, theis would greatly increase the search performance.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 07 January 2001 : 09:36:14
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
in your example page, you have a hard coded list from A-Z... and if there are no members with the letter clicked... you get a page that says "No Members Found"... this can be espeicaly detering when you have a new forum... and not many users.
what I'm saying is that you also miss the other characters that can be used in names such as !@#$%^&*() etc... so a general parse of all the names for first letters would be needed
then to list tehm and make them links that actualy search for names begining with those characters.
<center>Reinsnitz (Mike)
<font color=red>><)))'></font id=red>
"The glory of young men is their strength, and the honor of old men is their gray hair." - Proverbs 20:29
</center>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
That sounds sensible, I'll fix it today
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
Topic |
|
Topic Locked
