Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 01, 2007 06:36 PM by darkknight187
Aug 01, 2007 09:51 AM|LINK
How can a use a separate search facility for searching an item number? The text i will use is "The easiest way to find your advert is by using the itemnumber" i would use a textbox and an search button.
Aug 01, 2007 06:36 PM|LINK
You have two basic options, one:
You can have what ever number or adid is entered into the textbox you could have it work as a .navigateurl button.
The other is modifying the search procedure, I think there's three files you need to change,
First is where the page is coming from, make your textbox, and at the bottom in the object database add a control parameter
The control id and the textbox id need to match.
Then the object database is pointing to your App_Code/BLL/Ads.vb folder (asumming you are coding in VB)
You will find a file in the GET section GetActiveAdsByQuery, you will need to modify that and the file next to it GetAllAdsByQuery.
And finally the stored procedure GetAllAdsByQuery,
This is untested but I think maybe in the top part
and the bottom select statement try
(@AdId = 0
Like I said, it's not tested, but if it's not right it's close.