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

Return only certain records

P: 2
Hi,

New to all this.

I'm returning records by first letter, works fine by returning all records but I want to only return the records where notes=b but I just can't get it to work

I'm using this :

Expand|Select|Wrap|Line Numbers
  1. set rscatlist=db.execute("SELECT * FROM products WHERE left(name, 1) = '" & (Request("list")) & "'")
What do I add to just just the records where notes = b ?

The output is being displayed in a ASP page.

Thanks in advance.
Mar 22 '10 #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.