need help for writing a Sql query for Search
-
Hello everyone, i m using Sql Server 2000, i have a problem :
i want to make Search on my WebProject.On my webpage i have a Grid, i make serach on this grid on Code level now i want to make a serach that search from Database(not involving code level). I have 2 types of search simple search that search from all columns (CompanyName, Login, Registrationdate ) and i have 1 dropdown list for filtering in this i have (Status::
ending Approval, Approved,cancelled and Blocked).Now i have Advance Serach Option in this i have check boxex for each above + some more fields (CompanyName,Login,ContactTitle,Email.ContactName,Phone,Mobile)
plz tell me how i do this as i have a SP for displaying that grid (column fields with values) now in that SP i write code for Search also.
i have no idea how to write commands for this.i have an idea 1)involve search on All mean to say select companyname , login,ContactTitle,Email.ContactName,Phone,Mobile)where companyname=abc or login=aa pr so on....
and other is involving bitwise operator e.g serch(serchstring, 11000) leftside 1 means get compnayname , login but not contacttile so on..........
as i have a filter also (dropdownlist) smae case for tehse abv Seraches
plz tell me how i do this
as i never make any kind of search plz of u have any SP or code for search share with me may be i get help form this or reply me with my solution.
wait for replies
Thanx in Advance.
-
Isa - I'm not completely sure I understand your question...but if it is what I think it is then you need to capture the user selection into variables....pass those variables as parameters to your stored procedure and then exec the stored procedure using the parameters to filter your result set...
Is this what you want to know how to do...?!?!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply