Hi everyone.
I have a little search thing going on on one page.
web based application.
now its searching for students from different place and according to race and age etc.
i have 5 dropdown list boxes, that all have been bound to the database
like Province, education, race etc
now i used a SELECT statement to search those specific field and show results in a gridview.
and once they click select on the gridview a forms view opens with the students details.
The problem is that the select statement always only take the first dropdownlist's text and searches, and say i didnt take the first dropdownlist which is PROVINCE and take the second one which is RACE, then no data is returned.
here is the query
[CODE=sql]
SELECT name,surname,fi eld, FROM cvInformation WHERE (field=@field) or ([province]=@province) or (education=@edu cation)
[/CODE]
I have a little search thing going on on one page.
web based application.
now its searching for students from different place and according to race and age etc.
i have 5 dropdown list boxes, that all have been bound to the database
like Province, education, race etc
now i used a SELECT statement to search those specific field and show results in a gridview.
and once they click select on the gridview a forms view opens with the students details.
The problem is that the select statement always only take the first dropdownlist's text and searches, and say i didnt take the first dropdownlist which is PROVINCE and take the second one which is RACE, then no data is returned.
here is the query
[CODE=sql]
SELECT name,surname,fi eld, FROM cvInformation WHERE (field=@field) or ([province]=@province) or (education=@edu cation)
[/CODE]