Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Admin Email List - Sorting Option
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 3

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 16 June 2008 :  03:49:26  Show Profile  Reply with Quote
Carefree Well done I like the work. Thank you
Just an observation, in the IP search, you have saved the IP text file as admin_ip_search including all the references/links to admin_ip_search.asp. The filters and links will not work unless they are changed to the original file name of admin_search_ip.asp<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 16 June 2008 :  04:50:11  Show Profile  Reply with Quote
Carefree
I have noticed you get an error when you select a pull down page on the option box Page: 1 of 12 (admin_search_ip.asp)

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/forum/admin_search_ip.asp, line 245


The block of code around line 245 (245 in red)
set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize = strPageSize
if strSql6 > "" then
rs.open strSql & strSql2 & strSql3 & strSql6, my_Conn, adOpenStatic
else
rs.open strSql & strSql2 & strSql3, my_Conn, adOpenStatic
end if
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



Incidentally the same error occurs on admin_em_search.asp

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/forum/admin_em_search.asp, line 245


Carefree to help with the investigation.
If you open either the Email Search or IP search and have all the members listed selecting the pull down you will receive the error above. However, prior to selecting the page pull down, if you click on one of the sort headers ie members name, then select the pull down page option do do not get the error.

<

Edited by - Andy Humm on 16 June 2008 06:28:18
Go to Top of Page

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 16 June 2008 :  07:20:50  Show Profile  Reply with Quote
quote:
Originally posted by Andy Humm

Carefree Well done I like the work. Thank you
Just an observation, in the IP search, you have saved the IP text file as admin_ip_search including all the references/links to admin_ip_search.asp. The filters and links will not work unless they are changed to the original file name of admin_search_ip.asp



Sure they will. I changed 100% of them (including for the filtering and sorting links/routines); so none of them should be looking for the old file name.<
Go to Top of Page

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 16 June 2008 :  07:40:26  Show Profile  Reply with Quote
The issue was in strSql6, I fixed it.

The links in my earlier post have had the files replaced. Help yourself.

<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 16 June 2008 :  10:00:39  Show Profile  Reply with Quote
thank you... 10 out of ten!<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 17 June 2008 :  03:16:35  Show Profile  Reply with Quote
Carefree, I thought we had it sorted, excuse the pun! Since the fix was done regarding the pages pulldown (strsql6) I have noticed te column headers are not sorting????
I have taken the ID column out to allow the page to show in the older computer screens without seeing the text all jam up.
Could I ask you to have a butchers at my admin_search_em.txt to see what is glaringly wrong..Incidentally the same has occurred on the admin_search_ip.asp (since the strsql6 fix)
Sorry for hinderance
Ps I have also tried your latest file (admin_em_search.asp, with no changes) too, and the same occurs ..<

Edited by - Andy Humm on 17 June 2008 03:25:23
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 18 June 2008 :  04:41:43  Show Profile  Reply with Quote
Carefree I have tried the updated mods on snitzbitz, are you aware that the header sorting will not work on these downloads too.. Email and IP
kindest regards andy<
Go to Top of Page

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 18 June 2008 :  06:25:27  Show Profile  Reply with Quote
In both:

Change lines 183-185 to say:

	if strSql6 = "" then
			strSql6 = " ORDER BY M_NAME ASC"
	end if


In EM search, change line 107 to say:

SearchEM = trim(Request.QueryString("M_EMAIL"))
<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 18 June 2008 :  07:00:42  Show Profile  Reply with Quote
Carefree, removing the 0 and placing "" has led us back to
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/forum/admin_search_em.asp, line 248


With the "" every header sort works except Posts M_LEVEL

search ip line 370
if Request.QueryString("method") = "M_LEVEL ASC" then Response.Write("M_LEVEL DESC") else Response.Write("M_LEVEL ASC")
Response.Write """" & dWStatus("Sort by Post Count") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Posts</font></b></a></td>" & vbNewLine & _


I believe this should work looking at the style of the other sort routines..

Only an novice but will the strsql3 have anything to do with it..

from line 157
if isNumeric(varFilter) then
if varFilter > 0 then
strSql3 = strSql3 & " AND M_LEVEL=" & varFilter

then strsql3 is used lines 172, 176 180 for M_DATE M_LASTPOSTDATE etc( sorry if this is a red herring)


That strsql6 is upsetting something!<

Edited by - Andy Humm on 18 June 2008 07:05:39
Go to Top of Page

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 18 June 2008 :  07:27:40  Show Profile  Reply with Quote
I didn't just change the 0 to a double-quote, I changed the variable as well. Try using the line provided.<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 18 June 2008 :  07:43:53  Show Profile  Reply with Quote
Hi Carefree
I have cut and paste the two suggestions, as seen, and as soon as you open the admin_search and select another page from pull down, the result is the error. However, strange, if you do a sort before the page pull down its okay

Initially opening adminsearch the resultant urls;
http://www.domain.com/forum/admin_search_em.asp
Do page pull down
http://www.domain.com/forum/admin_search_em.asp?method=postsdesc&whichpage=3with error
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/forum/admin_search_em.asp, line 248


Reopen a fresh admin search page
http://www.domain.com/forum/admin_search_em.asp
select member sort (members sorted asc)
http://www.domain.com/forum/admin_search_em.asp?link=sort&mode=search&MEMBER_IP=&method=M_NAME%20ASC
Select another pull down page 3 (redirected to page 3 of 12)
http://www.domain.com/forum/admin_search_em.asp?method=M_NAME+ASC&mode=search&whichpage=3
page reads ok but in both occasions the Number of Posts will not sort

<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 18 June 2008 :  07:58:46  Show Profile  Reply with Quote
Notice the following sorting/selecting the various Header Links
Member Name
http://www.domain.com/forum/admin_search_em.asp?link=sort&mode=search&MEMBER_IP=&method=M_NAME%20ASC
Email Search
http://www.domain.com/forum/admin_search_em.asp?link=sort&mode=search&M_EMail=&method=M_EMAIL%20ASC
IP sort
http://www.domain.com/forum/admin_search_em.asp?link=order&mode=search&method=M_LAST_IP%20ASC
Posts
http://www.domain.com/forum/admin_search_em.asp?link=order&mode=search&method=M_LEVEL%20ASC
Last Post
http://www.domain.com/forum/admin_search_em.asp?link=sort&mode=search&MEMBER_IP=&method=M_LASTPOSTDATE%20ASC
Joined
http://www.domain.com/forum/admin_search_em.asp?link=sort&mode=search&MEMBER_IP=&method=M_DATE%20ASC
Country
http://www.domain.com/forum/admin_search_em.asp?link=sort&mode=search&MEMBER_IP=&method=M_COUNTRY%20ASC
Last Visit
http://www.domain.com/forum/admin_search_em.asp?method=M_LASTHEREDATE%20ASC


Looking at the way members.asp sorts (which all work and page pull down too) Members.asp sorting member name
http://www.domain.com/forum/members.asp?UserName=&FirstName=0&LastName=0&INITIAL=&link=sort&mode=search&M_NAME=%20&method=nameasc
Posts
http://www.domain.com/forum/members.asp?UserName=&FirstName=0&LastName=0&INITIAL=&link=sort&mode=search&M_NAME=%20&method=lastpostdatedesc

any clues?<

Edited by - Andy Humm on 18 June 2008 08:00:21
Go to Top of Page

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 18 June 2008 :  08:15:27  Show Profile  Reply with Quote
Look at line 582, I forgot to change a value from the old sort method.

Change that bit to say:

		if SortMethod = "" then
			sMethod = "M_NAME asc"
		else
			sMethod = SortMethod
		end if
<

Edited by - Carefree on 18 June 2008 08:20:28
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 18 June 2008 :  09:42:01  Show Profile  Reply with Quote
Thank you carefree for your patience and endeavour.
I resolved the 'Number of Posts' sort, the sqlstr had M_LEVEL instead of M_POSTS

Did you notice that on the members.asp if your filter all the database names beginning with a letter ie 'D', then with these ouputed names, you sort a heading, say Posts, then only the outputed names beginning with D are sorted.

Wheresas with the Admin_Search_Email and Admin_Search_IP if you filter the names 'D' and then sort by a header again Posts, the complete database is sorted by Posts instead of the filtered output..????? Is this the next puzzle?<
Go to Top of Page

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 18 June 2008 :  10:00:26  Show Profile  Reply with Quote
So the question becomes - has the admin changed his mind and selected a different sort or does he want a multiple-level filter & sort? Whichever way it's programmed, there'll be some who want the other.<
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.59 seconds. Powered By: Snitz Forums 2000 Version 3.4.07