Hi Yes it is running fine.
But there are a couple of things missing.

The Filter by Category on ResultPage is missing
and the Search Tag Catalogue link is missing.

And the code for making the Search words yellow on the Showpage is also missing, so can you add them please :)

glad you got it sorted out. unfortunately, the features you mention as being missing are V2 features which i haven't yet factored out from the exisitng code. the V1.n stuff is purely the search 'engine' and presentation layer (which to be honest, was 75% of the effort). you should be able to hopefully 'guess' at how the category stuff plugs in. as for the tags, that's still a work in progress, so it could be some time before that is released on it's own.

let me know if you think of anything to add onto the existing v1.n tho!!

jimi

http://www.originaltalent.com

I just figured out that my hosting company dosen't support Text serach in the database.
Argument: It uses to much resources.

I think it is allwayes nice to give the customer and simple version and then a advanced version of a search box.

So you could add a couple of figures like date, and allso add paging.

Jim,

Here's the code to create the indexes :)

USE [SQL2005_390746_eo]
GO
/****** Object: Index [IX_TBH_Articles_Approved] Script Date: 10/07/2007 18:10:19 ******/
CREATE NONCLUSTERED INDEX [IX_TBH_Articles_Approved] ON [dbo].[TBH_Articles]
(
    [Approved] ASC
)WITH
    (
        PAD_INDEX = OFF
        , STATISTICS_NORECOMPUTE = OFF
        , SORT_IN_TEMPDB = OFF
        , IGNORE_DUP_KEY = OFF
        , DROP_EXISTING = OFF
        , ONLINE = OFF
        , ALLOW_ROW_LOCKS = ON
        , ALLOW_PAGE_LOCKS = OFF
    ) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_TBH_Articles_ReleaseDate] ON [dbo].[TBH_Articles]
(
    [ReleaseDate] ASC
)WITH
    (
        PAD_INDEX = OFF
        , STATISTICS_NORECOMPUTE = OFF
        , SORT_IN_TEMPDB = OFF
        , IGNORE_DUP_KEY = OFF
        , DROP_EXISTING = OFF
        , ONLINE = OFF
        , ALLOW_ROW_LOCKS = ON
        , ALLOW_PAGE_LOCKS = OFF
    ) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_TBH_Articles_OnlyForMembers] ON [dbo].[TBH_Articles]
(
    [OnlyForMembers] ASC
)WITH
    (
        PAD_INDEX = OFF
        , STATISTICS_NORECOMPUTE = OFF
        , SORT_IN_TEMPDB = OFF
        , IGNORE_DUP_KEY = OFF
        , DROP_EXISTING = OFF
        , ONLINE = OFF
        , ALLOW_ROW_LOCKS = ON
        , ALLOW_PAGE_LOCKS = OFF
    ) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_TBH_Posts_Approved] ON [dbo].[TBH_Posts]
(
    [Approved] ASC
)WITH
    (
        PAD_INDEX = OFF
        , STATISTICS_NORECOMPUTE = OFF
        , SORT_IN_TEMPDB = OFF
        , IGNORE_DUP_KEY = OFF
        , DROP_EXISTING = OFF
        , ONLINE = OFF
        , ALLOW_ROW_LOCKS = ON
        , ALLOW_PAGE_LOCKS = OFF
    ) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_TBH_Posts_LastPostDate] ON [dbo].[TBH_Posts]
(
    [LastPostDate] ASC
)WITH
    (
        PAD_INDEX = OFF
        , STATISTICS_NORECOMPUTE = OFF
        , SORT_IN_TEMPDB = OFF
        , IGNORE_DUP_KEY = OFF
        , DROP_EXISTING = OFF
        , ONLINE = OFF
        , ALLOW_ROW_LOCKS = ON
        , ALLOW_PAGE_LOCKS = OFF
    ) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_TBH_Posts_ParentPostID] ON [dbo].[TBH_Posts]
(
    [ParentPostID] ASC
)WITH
    (
        PAD_INDEX = OFF
        , STATISTICS_NORECOMPUTE = OFF
        , SORT_IN_TEMPDB = OFF
        , IGNORE_DUP_KEY = OFF
        , DROP_EXISTING = OFF
        , ONLINE = OFF
        , ALLOW_ROW_LOCKS = ON
        , ALLOW_PAGE_LOCKS = OFF
    ) ON [PRIMARY]

HTH, and thanks for taking the time to put this together.

Peter

http://entropia-online.blogspot.com/

Peter, thanks for that too ;)

jimi

http://www.originaltalent.com

the server for my site does not have the option available they say.

kherrerab - checkout webhost4life. they give the full range of options, including full-text search as well as allowing all standard remote sql tools to be used against their sqlserver database.

jimi

http://www.originaltalent.com

i use liquidsix.com they are great too but they say they have deactivated this option for the moment.

I have the same tools at my disposal at discountasp.net.

http://entropia-online.blogspot.com/