easy one?

Results 1 to 3 of 3

Thread: easy one?

  1. #1
    Join Date
    Dec 1969

    Default easy one?

    I&#039;m sorry I know this will be somewhat of an easy one. Up till now I have been pulling my 1 recordset from the db based off of the primary key(each one being unique) I was wondering how you syntax the statement if you want to bring multiple records from the db. For instance I want to see all [ID]&#039;s from the db where employee = &#039;john&#039;, or some variable that I want to put in it. Or for that matter, how would I set up my table to contain the everchanging information. Again sorry for the slackness.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default select [id] from table

    where name like &#039;John%&#039;<BR><BR>R&D "LIKE" operator.

  3. #3
    Join Date
    Dec 1969

    Default Maybe start here...

    http://w3.one.net/~jhoffman/sqltut.htm<BR><BR>But one of the best ways to learn is to just play with the Access query design tool. When you get it doing what you want, copy/paste the SQL into your ASP code and just change it so that &#039;John&#039; is replaced by a variable, instead.<BR><BR><BR>

Posting Permissions

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