Author |
Topic  |
Andy Humm
Average Member
  
United Kingdom
908 Posts |
Posted - 16 June 2008 : 03:49:26
|
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< |
 |
|
Andy Humm
Average Member
  
United Kingdom
908 Posts |
Posted - 16 June 2008 : 04:50:11
|
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 |
 |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 16 June 2008 : 07:20:50
|
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.< |
 |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 16 June 2008 : 07:40:26
|
The issue was in strSql6, I fixed it.
The links in my earlier post have had the files replaced. Help yourself.
< |
 |
|
Andy Humm
Average Member
  
United Kingdom
908 Posts |
Posted - 16 June 2008 : 10:00:39
|
thank you... 10 out of ten!< |
 |
|
Andy Humm
Average Member
  
United Kingdom
908 Posts |
Posted - 17 June 2008 : 03:16:35
|
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 |
 |
|
Andy Humm
Average Member
  
United Kingdom
908 Posts |
Posted - 18 June 2008 : 04:41:43
|
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< |
 |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 18 June 2008 : 06:25:27
|
In both:
Change lines 183-185 to say:
In EM search, change line 107 to say: < |
 |
|
Andy Humm
Average Member
  
United Kingdom
908 Posts |
Posted - 18 June 2008 : 07:00:42
|
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 |
 |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 18 June 2008 : 07:27:40
|
I didn't just change the 0 to a double-quote, I changed the variable as well. Try using the line provided.< |
 |
|
Andy Humm
Average Member
  
United Kingdom
908 Posts |
|
Andy Humm
Average Member
  
United Kingdom
908 Posts |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 18 June 2008 : 08:15:27
|
Look at line 582, I forgot to change a value from the old sort method.
Change that bit to say: < |
Edited by - Carefree on 18 June 2008 08:20:28 |
 |
|
Andy Humm
Average Member
  
United Kingdom
908 Posts |
Posted - 18 June 2008 : 09:42:01
|
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?< |
 |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 18 June 2008 : 10:00:26
|
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.< |
 |
|
Topic  |
|