Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
07-11-2007, 11:59 AM #1
- Join Date
- Dec 2005
- Thanked 0 Times in 0 Posts
ado/sql: WHERE and VALUE are the same ?
how to program
A table has lastname, firstname, salary,...
WHERE and VALUE are the same ? how I use VALUE ? Tell me for the two statements how use two conditions[eg lastname= "tom" firstname="smith" , AND or OR between] ? building a record set including records of names only of lastname, firstname ....
tell me also what to use with oRS.Filter=.... to get same result ?
07-11-2007, 01:08 PM #2
- Join Date
- Mar 2007
- Thanked 19 Times in 19 Posts
WHERE and VALUE are NOT the same.
WHERE is a conditional statement used in SQL. VALUE is used when inserting data into your database via SQL _OR_ an HTML attribute to the INPUT object.
As to AND & OR, it depends on what you are looking for. If you are looking for people with First Name TOM who also have a Last Name of Smith, then use AND. If you are only looking for people who's First Name is TOM, but also people who have a Last Name of Smith, then use OR.
Google 'SQL Statement Syntax' to learn more. Also, you can use the MySQL Documentation on SQL Statements to learn more. Here's the linkTo say my fate is not tied to your fate is like saying, 'Your end of the boat is sinking.' -- Hugh Downs