Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 01, 2007 06:36 PM by darkknight187
Member
2 Points
22 Posts
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.
Contributor
2674 Points
1040 Posts
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
@AdId
and the bottom select statement try
(@AdId = 0
Like I said, it's not tested, but if it's not right it's close.
Good Luck
rudip
Member
2 Points
22 Posts
item number
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.
darkknight18...
Contributor
2674 Points
1040 Posts
Re: item number
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
such as:<
asp:ControlParameter ControlID="AdIdTB" DefaultValue="0" Name="AdId" Type="Int32" />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
@AdId
int = 0,and the bottom select statement try
(@AdId = 0
OR AdId = @AdId) ANDLike I said, it's not tested, but if it's not right it's close.
Good Luck
Please remember to mark the post as answer that solves your issue.
This will be greatly benificial for other users.