RE: [CFTALKTor] Updating counter values

[terry]

You know, someone somewhere probably has a website that would teach you what
you want.  Try searching yahoo or alta-vista.com for something like "SQL
language training" or something like that.

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]


  -----Original Message-----
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Arun Persaud
  Sent: Friday, April 19, 2002 9:17 AM
  To: [EMAIL PROTECTED]
  Subject: RE: [CFTALKTor] Updating counter values


  Good advice. I'll be hitting the book store. Anyone have any
recommendations for an SQL book for newbies?


  Arun
    -----Original Message-----
    From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
    Sent: April 18, 2002 9:06 PM
    To: [EMAIL PROTECTED]
    Subject: RE: [CFTALKTor] Updating counter values


    Uh, well, your query did *exactly* what you told it to do.

    If you want the update to update more then just the record where CheckID
= 1, then you will need to change your WHERE clause.
    consider
    WHERE <primary_key_field> = <somevalue>
    will NEVER EVER update more then 1 record, because you are guaranteed to
only find 1 record (or no records) with specified primary key!!!
    (autonumber is a primary key, presumably you are using an Access
database (Ugh))

    If you want to update only records according to some rule, then, well,
you need to state that as a condition in your WHERE clause.

    I recommend you take a SQL course, or head to the library and pick up an
entry level book on SQL.  SQL is very powerful, and you could benefit
greatly from learning more about it.

    Terry Fielder
    Network Engineer
    Great Gulf Homes / Ashton Woods Homes
    [EMAIL PROTECTED]


      -----Original Message-----
      From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Arun Persaud
      Sent: Thursday, April 18, 2002 7:14 PM
      To: [EMAIL PROTECTED]
      Subject: [CFTALKTor] Updating counter values


      I've been racking my brain for the past hour. I'm having trouble
updating the values for each record in  COLUMN 3 all at once:


      TABLE2:COLUMN 1
      CheckID (autonumber)
      1
      2
      3

      TABLE2:COLUMN 2
      Reviews  (int)
      4
      2
      7

      TABLE2:COLUMN 3
      checkReviewCount (int)
      0
      0
      0


      This is the Query that I'm using:

      <CFSET NewValue = #checkCategory.ReviewCount# + 1>

      <CFQUERY NAME="UpdateCounter" DATASOURCE="DB">
      UPDATE TABLE2
      SET ReviewCount = #NewValue#
      WHERE CheckID = #checkCategory.CheckID#
      </CFQUERY>

      The problem is that it will only add 1 to the first record and not the
others. So COLUMN 3 looks like this:

      TABLE2:COLUMN 3
      checkReviewCount (int)
      1
      0
      0

      instead of this:

      TABLE2:COLUMN 3
      checkReviewCount (int)
      1
      1
      1

      Also, if this manages to work, I need to stop the addition of 1, once
the value in "Reviews" equals the value in "checkReviewCount". (i.e. 4 = 4)

      Thanks again everyone. Gonna go soak my brain.


      Arun Persaud

<<attachment: winmail.dat>>