WEB php queries not applying?

Discussion in 'OT Technology' started by Slid., Apr 29, 2010.

  1. Slid.

    Slid. I'm a guy.

    Joined:
    Oct 25, 2001
    Messages:
    1,928
    Likes Received:
    0
    Location:
    NH
    This is the second time I've encountered this, I have no idea what's causing or how / why it's happening. I have an import script which reads in a data file and makes a series of inserts into my mySql db. After all is said in done I run an update which combines data from two tables into one. Well, the update query works but it doesn't actually run when I have it in my code sequence.

    My fix for this previously was to use a delay, but that's retarded.

    So I'll basically do:

    INSERT
    INSERT
    INSERT
    UPDATE

    The update never runs. Has anyone else run into this issue? Is there something I should do with table locking? If I run the UPDATE function after the fact it works but it won't work in sequence.

    Thanks.
     
  2. Slid.

    Slid. I'm a guy.

    Joined:
    Oct 25, 2001
    Messages:
    1,928
    Likes Received:
    0
    Location:
    NH
    Okay, it looks like I had a second UPDATE that was reverting my first.

    I was comparing two strings with [string] <> [string], which shouldn't be a problem .. but when I changed it to [string] NOT LIKE [string] everything was fine.
     

Share This Page