By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,627 Members | 1,916 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,627 IT Pros & Developers. It's quick & easy.


P: 374
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

Expand|Select|Wrap|Line Numbers
  1. SELECT name,surname,field, FROM cvInformation WHERE (field=@field) or ([province]=@province) or (education=@education)
Feb 5 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.