Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #21 (permalink)  
Old September 28th, 2007, 10:07 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
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
  #22 (permalink)  
Old September 28th, 2007, 11:47 AM
FT FT is offline
Authorized User
 
Join Date: Oct 2005
Location: , , .
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

  #23 (permalink)  
Old September 28th, 2007, 01:38 PM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
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
  #24 (permalink)  
Old September 29th, 2007, 04:38 AM
FT FT is offline
Authorized User
 
Join Date: Oct 2005
Location: , , .
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

  #25 (permalink)  
Old September 29th, 2007, 05:12 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
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
  #26 (permalink)  
Old September 29th, 2007, 06:04 AM
FT FT is offline
Authorized User
 
Join Date: Oct 2005
Location: , , .
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 ?

  #27 (permalink)  
Old September 29th, 2007, 06:26 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
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
  #28 (permalink)  
Old September 29th, 2007, 08:06 AM
FT FT is offline
Authorized User
 
Join Date: Oct 2005
Location: , , .
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 ?



  #29 (permalink)  
Old September 29th, 2007, 11:20 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
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
  #30 (permalink)  
Old September 29th, 2007, 11:32 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
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
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 07:22 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.