Thanks! I really appreciate the help. I couldn't have done it without you.
The only problem now becomes if they enter more than one word into the search. Any ideas???
GENIUS!<br /><br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />This did the trick:<br /><br />INSERT INTO #TempItems...
Ok Bambola....that gives me: SELECT ProductID FROM Products WHERE ModelNumber LIKE %business% AND Disable IS NULL OR ModelName LIKE %business% AND...
There was no output....not that I could see. How could I possibly be passing the @Search as NULL??
Bambola....replacing the code as directed returns "The stored procedure executed successfully but did not return any records" I've tried passing...
That is the whole SP. I use the following to test @Page = 1 @RecsPerPage =10 @Search = business I know it's probably something simply you all can...
no. Same error either through the query analyzer or the script.
calling the procedure this way: SaleSQL = "sp_simplesearch " & currentpage &", "& iRecordsPerPage &", '"& SearchText&"'" Error: Line 2 =...
Thanks. I'll check that link. This sp works: ( @Search nvarchar(255) ) AS SELECT * FROM Products WHERE ModelNumber LIKE '%' +...
Soo....Bambola.... With your code suggestion I can give the users the option to search by product id, model name, description etc.....very...
hmmm...... All I'm trying to do in that exec statement is selectany productId where any part of the product description or whatever matches/includes...
Hi all! I got some wonderful help in here the other day to get some paged query results out of my sp. Now I'd like to use the same idea and modify...
Hey folks...<br /><br />I didn't want to start a duel. <img src='/community/emoticons/emotion-5.gif' alt=';)' /><br /><br />Absolutley, thanks for...
BEAUTIFUL! I was able to get it to work with one RS. All I did was add the orginal MoreRecords = ( SELECT COUNT(*) FROM #TempItems TI WHERE...
Naturally, one rs would be better. I'm still working on it. Thanks.
Thanks so much for your help! A very slick routine which I think will help my problem. The only last issue relates to the "MoreRecords". How do I...
Hi all. I'm able to limit the columns to Identity & ProductID for the table....but I'm not sure where I should be putting the Join. Thanks!
Thanks babola! OK....I think I understand that what you are getting at. I appreciate your offer of help when you get home. In the meantime I'll...
<sigh!> I'm afraid this is all over my head. Products are added to our db throughout the day & night, so with the base data changing at any time,...
Separate names with a comma.
