| Author |
 Topic Search  Topic Options
|
WebWiz-Bruce 
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 25 January 2006 at 5:34pm |
|
It's a sticky post at the top of this support forum entitled, Access to SQL step by step, or something like that.
|
|
|
 |
Slov
Newbie
Joined: 24 January 2006
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 5:39pm |
|
OK, I found the post. But is it possible to remove 4 characters limitation in the search? At least is it configurable?
Also is the search case insensitive or not and is there a way to configure it?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 6:14pm |
|
The searchon this forum is completly different to the 7.97 version you will be using.
This forum is currently running an alpha version which uses a different searching engine and is not yet completed so chnages will be made.
Searchs use SQL like queries, so whether it is case sesitive or not depends on how the server is setup.
In version 7.97 there is no limtation on search word lengths.
|
|
|
|
Slov
Newbie
Joined: 24 January 2006
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 8:01pm |
|
OK, thank you for the support.
By the way, I have a proposition that may be interesting for you.
We offer a product called ISAPI_Rewrite - this is analog of mod_rewrite but for IIS, you may be know what is it. With this product it is possible to make this forum search engines friendly. For example instead of http://forums.webwiz.net/forum_posts.asp?TID=18128&PN=2 URL we can get http://forums.webwiz.net/forum_posts_18128_2.asp or something. This will require changing links in the forum engine. You may offer it as add-on. The good news is that there is a free Lite version of ISAPI_Rewrite that many peaple can use.
If you are interested please write me an e-mail so we can discuss technical questions.
|
|
Slov
Newbie
Joined: 24 January 2006
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 January 2006 at 12:13pm |
|
We found the problem. It is a bug in Access migration script. It has created tblEmailNotify table and filled Forum_ID field for all records by the ID of the forum where initial post was made. We can send you data example if you want.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 January 2006 at 5:48pm |
|
Thanks for the info about ISAPI_Rewrite, it is something that I have considered but at the moment it is not an important consideration, also I have to think about the extra support time required to support a version with the altered URL's.
The Access Migration Tool was written about 2 years ago by someone else and I wouldn't even know now how or even if they could be contacted to fixed the issue.
As version 6.x was superceded over 2 years ago, most users have now already upgraded to a 7.x version, although it is recommended for security reasons to always be running the latest satble release.
|
|
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 January 2006 at 12:57am |
|
I haven't found to many webhosts that support ISAPI_Rewrite. Nothing against the product AFAIK, but they're reluctant to add any isapi dlls. Windows is flakey enough.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
