Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Dec 2005
    Posts
    702
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ado/sql: WHERE and VALUE are the same ?

    ado/sql
    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 ?

  • #2
    Regular Coder
    Join Date
    Mar 2007
    Posts
    505
    Thanks
    1
    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 link
    To say my fate is not tied to your fate is like saying, 'Your end of the boat is sinking.' -- Hugh Downs
    Please, if you found my post helpful, pay it forward. Go and help someone else today.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •