Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 28th, 2007, 10:07 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

FT - to be honest, i think you prolly could run them from vs2005 but i've never done that, so couldn't confirm that. as for the error, again didn't have issues on either of the machines that i use here, so can't really suggest too much, other than checking out the error message via a google search.

as i said in the little readme file, anything to do with sqlserver really will have to be investigated by the user as i'm not expert on that area (and of course, there are so many variables involved re installations). however, i'll see if i can dig any info out based on what you've mentioned so far.

jimi

http://www.originaltalent.com
 
Old September 28th, 2007, 11:47 AM
FT FT is offline
Authorized User
 
Join Date: Oct 2005
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi again
I found a solution.
But now when I run the script I get this error.

Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'ASPNETDB'. No entry found with that name. Make sure that the name is entered correctly.
Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.
Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.


And I how installed the Microsoft SQL Server 2005 Express Edition with Advanced Services
http://msdn2.microsoft.com/en-gb/express/bb410792.aspx

 
Old September 28th, 2007, 01:38 PM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

FT, make sure that you attach your ASPNETDB and give the node that name.

you may have figured this by now, but just in case :)

jimi

http://www.originaltalent.com
 
Old September 29th, 2007, 04:38 AM
FT FT is offline
Authorized User
 
Join Date: Oct 2005
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

So far so good :)
How do I create indexes on these...?
I can't find any other sql files to run

files in SQL Server Management Studio Express. Also, create indexes on:

Articles:
IX_tbh_Articles_Approved
IX_tbh_Articles_ReleaseDate
IX_tbh_Articles_OnlyForMembers

Posts:
IX_tbh_Posts_Approved
IX_tbh_Posts_LastPostDate
IX_tbh_Posts_ParentPostID

 
Old September 29th, 2007, 05:12 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

FT,

go into SQL Server Management Studio Express and then click on the ASPNETDB node. from there, click on the tables node then select the tbh_articles table. Next, click on 'design'. now, go onto the design pane and right click. select the 'indexes/keys' menu item. when the dialogbox comes up, click on add and give the index the name that you want, then select the appropriate column for that index. that should be it really.

phew, this sqlserver management malarkie is more intense than c# coding :).

hope this sorts it all out for you and soon you'll be able to run the search from your app ;)

jimi

http://www.originaltalent.com
 
Old September 29th, 2007, 06:04 AM
FT FT is offline
Authorized User
 
Join Date: Oct 2005
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi again
Yes I am almost there :-)

I keep getting this error

MB.TheBeerHouse.TheBeerHouseSection' dosent contain a definition for 'Search'

What am I missing ?

 
Old September 29th, 2007, 06:26 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

FT - not sure, but check that if you've changed your default namespace stuff, then the problem may lie within that are. in the search.ascx file at the top you have:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="search.ascx.cs" Inherits="MB.TheBeerHouse.UI.Controls.Search" %>

so you may have to match the Inherits part with whatever you have in other controls (open up the RatingDisplay.ascx for example and check the name on the Inherits section there).

other than that, not 100% sure. let me know how you get on, tho' i'll be out for the rest of today now.

jimi

http://www.originaltalent.com
 
Old September 29th, 2007, 08:06 AM
FT FT is offline
Authorized User
 
Join Date: Oct 2005
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK.
I am still getting these errors.

Missing a property called Search in the ConfigSection.cs file

I try to at this property
Code:
public SearchElement Search
        {
            get { return (SearchElement)base["Search"]; }
        }



Missing a definition for RemoveSpacesFromString in Helpers

So how do I fix this ?



 
Old September 29th, 2007, 11:20 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

FT - did you copy the stuff from ConfigSection.cs (copy out to your version).txt??

also, as you've noticed, the public SearchElement Search defintion was missing, so copy that into the ConfigSection.cs as well (well spotted!!).

        [ConfigurationProperty("search", IsRequired = true)]
        public SearchElement Search
        {
            get { return (SearchElement)base["search"]; }
        }

the RemoveSpacesFromString method is like this:

        public static string RemoveSpacesFromString(string content)
        {
            content = Regex.Replace(content, "[^A-Za-z0-9 ]", "").Trim();
            content = Regex.Replace(content, "\\s+|\\s+$", " ").Trim();
            return content;
        }

sorry about these ommissions, i'll update the zip file with the things you've found to be missing!!



jimi

http://www.originaltalent.com
 
Old September 29th, 2007, 11:32 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

FT - made changes to zip file and have uploaded new version:

http://www.originaltalent.com/downloads/searchv1.5.zip

this should correct all issues mentioned above. Thanks for finding those few code issues, you've helped future 'downloaders' immensly!!

thanks.

jimi

http://www.originaltalent.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Announce: Site Generator V2 now available jimibt BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 56 October 2nd, 2009 01:06 PM
[Announce] Intellium For Web is released Intellium ASP.NET 1.0 and 1.1 Basics 0 April 3rd, 2008 03:23 AM
TBH Search Engine Optimization retroviz BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 3 November 5th, 2007 04:55 PM
Anyone created a search module? doanhvu BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 6 August 12th, 2007 12:19 AM
Search module vantoko BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 6 August 7th, 2007 07:48 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.