Alright, what you're going to want to do in this case is use the query designer. Start first by doing a super simple query and see if you get anything from the database. If you do, then next thing to do is add a condition to the query like:
where dete = @dete AND isApproved = true
If that works, then we add another variable to the mix, namely Category:
where Category = @Category AND dete = @dete AND isApproved = true;
Since your boss is being tough about allowing you to show more details, this is the best I can do under the circumstances. If those queries return values, then we can try doing some more refinement.
bbcompent1
All-Star
32974 Points
8500 Posts
Moderator
Re: Query problem - returns no details.
Apr 11, 2012 11:16 AM|LINK
Alright, what you're going to want to do in this case is use the query designer. Start first by doing a super simple query and see if you get anything from the database. If you do, then next thing to do is add a condition to the query like:
where dete = @dete AND isApproved = true
If that works, then we add another variable to the mix, namely Category:
where Category = @Category AND dete = @dete AND isApproved = true;
Since your boss is being tough about allowing you to show more details, this is the best I can do under the circumstances. If those queries return values, then we can try doing some more refinement.