1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

quick easy database query help

Discussion in 'Databases' started by retrocode0071, Jan 18, 2008.

0
  1. #1
    I want this in one query and yes it is ms access which I’m growing to loath.

    UPDATE Tanks SET Tanks.[Paragraph #] = 3 WHERE Tanks.Secondary=-1;
    UPDATE Tanks SET Tanks.[Paragraph #] = 4 WHERE Tanks.Secondary=0;

    thanks everyone
     
    retrocode0071, Jan 18, 2008 IP
  2. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #2
    I think this will work:

    UPDATE Tanks SET Tanks.[Paragraph #] = 4+Tanks.Secondary WHERE Tanks.Secondary=0 or Tanks.Secondary=-1;
     
    Kuldeep1952, Jan 18, 2008 IP
  3. retrocode0071

    retrocode0071 Banned

    Messages:
    719
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I am not sure it would update one to be 3
     
    retrocode0071, Jan 18, 2008 IP