Behind the scenes Leatherlips and I have been observing a few little areas of the forum that need tweaking for 100% accuracy. If you have incorporated the searchlog.asp mod and have it working, did you notice the General Statistics statement "55 searches have been performed since 08 June 2008 at 06:21:37." The date that has been extracted from the database, is in fact the last date of a recorded search and not the first date. The page code has a dim FirstSearchDate which currently pulls the last date. To rectify the problem: Searchlog.asp line 75 find: strsql = "SELECT SLS_DATE FROM " & strTablePrefix & "SEARCHLOG_SEARCHES ORDER BY SLS_DATE DESC"
replace with: strsql = "SELECT SLS_DATE FROM " & strTablePrefix & "SEARCHLOG_SEARCHES ORDER BY SLS_ID ASC"
Now the statement will pull the first stored search date. Happy editting.. Oops 'editing', thats better! Andy
Searchlog Observation /error
Posted - 08 June 2008 : 03:35:55
