Results 1 to 2 of 2

Thread: sp_PagedResults

  1. #1
    Join Date
    Dec 1969

    Default sp_PagedResults

    I am following the instructions from the article "Searching 4guysFromRolla.com" to create a search page for my Intranet. I&#039;m on Part 3 and am having problems with the Stored Procedure and how to implement the WHERE clause using the @strWhereClause.<BR><BR>Here is the part I&#039;m working on. Can anyone tell me what I&#039;m doing wrong?<BR><BR>INSERT INTO #TempItems (Title, Description, URL) <BR>SELECT Title, Description, URL FROM Tbl_Article_Index WHERE Contents Like &#039;%&#039;+(@strWhereClause)+&#039;%&#039;<BR>O RDER BY Title <BR><BR><BR>Thanks,<BR>Michelle

  2. #2
    Join Date
    Dec 1969

    Default RE: sp_PagedResults

    You should use & instead of +<BR>dunno if that solves anything though...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts