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/Code)
 SQL Server full-text searching
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 6

therookery
Starting Member

29 Posts

Posted - 13 September 2004 :  12:15:17  Show Profile  Visit therookery's Homepage
Ooops - I had some
& amp;
instead of & in the url that topic.asp builds up. I've replaced all these and it works perfectly. Thanks for your patient help.

Edited by - therookery on 13 September 2004 12:19:03
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 September 2004 :  12:16:09  Show Profile  Visit HuwR's Homepage
ok no probs
Go to Top of Page

-gary
Development Team Member

406 Posts

Posted - 15 September 2004 :  11:58:19  Show Profile
I added the change above to version F in the original post.

KawiForums.com


Go to Top of Page

Gato
New Member

Brazil
92 Posts

Posted - 30 September 2004 :  16:10:10  Show Profile  Visit Gato's Homepage
Hey, amazing code. I have an earlier version of this but I cant download the new one (f). Can you check the link please?

Thanks a lot

Get the new Gato's MultiLanguage Portal Code with 6 Languages Included and more than 70 MODs & 30 New Features
Get more information here
Go to Top of Page

-gary
Development Team Member

406 Posts

Posted - 30 September 2004 :  22:34:09  Show Profile
I guess I didn't update the zip file. It's fixed.

KawiForums.com


Go to Top of Page

Gato
New Member

Brazil
92 Posts

Posted - 01 October 2004 :  17:34:44  Show Profile  Visit Gato's Homepage
Thanks a lot

Get the new Gato's MultiLanguage Portal Code with 6 Languages Included and more than 70 MODs & 30 New Features
Get more information here
Go to Top of Page

Gargoyle
Junior Member

USA
280 Posts

Posted - 19 October 2004 :  22:59:27  Show Profile  Visit Gargoyle's Homepage
The download does not seem to be working..

Here is a link to my Snitz powered Drag Racing site.
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 30 October 2004 :  15:25:27  Show Profile  Visit dayve's Homepage
very nicely done. I too was having problems with searching, especially since I don't archive my topics/replies. I ended up relying on the integrated Google Search API that was made available which actually worked out really well too.

Thanks to all that have been involved in this mod.

Update... so I had a chance to use this all day and what a huge difference. I am going to have to implement this with my other projects at work. This is definitely a change in the way I do things from now on. Any more helpful indexing tips?


Edited by - dayve on 30 October 2004 21:19:37
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 31 October 2004 :  19:45:35  Show Profile
quote:
Originally posted by HuwR

quote:
Originally posted by HuwR

well, actually the mod works with all databases from what I can tell, but if you are using Access it just uses the existing search code.

I am going to install the code here later today so everyone can see the improvement.



The code has been running here for about a week, I have not implemented "full text" but you can still see a massive improvement in the search times. (for those that bother to use it )

Huw, I was wondering what was different with the search here. It is faster, but it doesn't return results that it should be returning. Any idea why?
Go to Top of Page

-gary
Development Team Member

406 Posts

Posted - 15 November 2004 :  14:24:36  Show Profile
Uploaded version G. search.asp and search_mssqlft.asp has changed.

New options on the search.asp page to allow the choosing of exact word matches "test" or loose matches "test", "testing", "tests" and whatnot. That would explain some of the missing returns. The old version defaulted to exact match.

One feature of SQL's FT searching is that it will only search for exact, inflectional or predicate matches. Being that it will find "test", "tests", "tested", etc but not "protest" if searching for "test". That would explain the other missing returns.

If someone has done the MySQL FT changes, could you share them so I can make this package complete? Otherwise, I'll try to start on it sometime in the near future.

KawiForums.com



Edited by - -gary on 15 November 2004 16:08:44
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 15 November 2004 :  15:03:42  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
quote:
New options on the search.asp page to allow the choosing of exact word matches "test" or loose matches "test", "testing", "test" and whatnot.

Excellent, thanks!

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

-gary
Development Team Member

406 Posts

Posted - 15 November 2004 :  16:22:06  Show Profile
Posted a demo link with FT enabled in the original.

KawiForums.com


Go to Top of Page

hitched
Starting Member

United Kingdom
7 Posts

Posted - 28 November 2004 :  08:43:26  Show Profile  Visit hitched's Homepage
Great stuff Gary - Thanks

Has anyone coverted the pages to speedball yet?

Cheers
Dean
Go to Top of Page

-gary
Development Team Member

406 Posts

Posted - 07 January 2005 :  16:09:37  Show Profile
New version H in original post for problem here.

KawiForums.com


Go to Top of Page

-gary
Development Team Member

406 Posts

Posted - 18 January 2005 :  18:18:17  Show Profile
Version I updated to correct problem here.

New dim and function FixChars() added to search.asp.
New line added to search_mssqlft.asp.

Link in original post.

KawiForums.com


Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07