Query Has A Syntax Error

I have modelled this query after another query which works fine and retrieves a result set. It accepts a search parameter and brings up all the websites in the database by searching on various columns for the search text.  The article search query works the same way.  I just changed the tables and parameters to match the tables.  It uses the "view" and I had to go into the query and check a few columns in the query designer to add the column to the view.

Here's the query with the syntax error: 1 set ANSI_NULLS ON
2
3 set QUOTED_IDENTIFIER ON
4
5 GO
6
7 ALTER PROCEDURE [dbo].[_spArticleSearch]
8
9 @search varchar (100),
10
11 @orderBy varchar(200)='ActiveMemberShip DESC, PageRank DESC, ArticleTitle, DateAdded DESC'
12
13 AS
14
15 EXEC('SELECT * from vArticle
16
17 where Active=1 AND ShowInDirectory=1 AND
18
19 (
20
21 Articletitle like ''%' + @search + '%''
22
23 OR Articletext LIKE ''%' + @search + '%''
24
25 OR ShortDesc LIKE ''%' + @search + '%''
26
27 OR Keywords LIKE ''%' + @search + '%''
28
29 IN (SELECT ACategoryID FROM tblArticleCategory WHERE AActive=1 AND (ACategoryName LIKE ''%' + @search + '%'' OR AParentID IN(SELECT ACategoryID FROM tblArticleCategory WHERE AActive=1 AND ACategoryName LIKE ''%' + @search + '%'')))
30
31 )
32
33 ORDER BY ' + @OrderBy )
34
35
36


 When I run the stored procedure and input a word into the search box, and it gives me this:

Msg 156, Level 15, State 1, Line 8

Incorrect syntax near the keyword 'IN'.

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near ')'.

(1 row(s) affected)

This is the query it was modelled after which works fine and retrieves all the websites.

1    set ANSI_NULLS ON
2    set QUOTED_IDENTIFIER ON
3    GO
4   
5    ALTER PROCEDURE [dbo].[_spWebSiteSearch]
6    @search varchar (100),
7    @orderBy varchar(200)='ActiveMemberShip DESC, PageRank DESC, TotalExchangedLinks Desc, SiteTitle, SiteURL, DateAdded DESC'
8   
9    AS
10  
11   EXEC('SELECT * from vWebSite
12   where Active=1 AND ShowInDirectory=1 AND
13   (
14   sitetitle like ''%' + @search + '%''
15   OR SiteURL LIKE ''%' + @search + '%''
16   OR SiteDescription LIKE ''%' + @search + '%''
17   OR CategoryID IN
18   (SELECT CategoryID FROM tblCategory WHERE Active=1 AND (CategoryName LIKE ''%' + @search + '%'' OR ParentID IN(SELECT CategoryID FROM tblCategory WHERE Active=1 AND CategoryName LIKE ''%' + @search + '%'')))
19   )
20   ORDER BY ' + @OrderBy )
21  


Does anyone know where the problem may be? Do the columns in the view have to be in order? When I added my columns, it adds them to the very far right side of the view. Does the columns to be in order in the same way it searches in the query?