Re: inserting or updating appropriately

2013-10-08 Thread Ben Finney
Νίκος Αλεξόπουλος writes: > Error is: ProgrammingError(ProgrammingError(1064, "You have an error > in your SQL syntax; check the manual that corresponds to your MySQL > server version for the right syntax to use near 'WHERE counterID = 1 > and cookieID = '3815'' at line 3"),) This is an error fr

Re: inserting or updating appropriately

2013-10-08 Thread Νίκος Αλεξόπουλος
Στις 8/10/2013 12:15 μμ, ο/η Νίκος Αλεξόπουλος έγραψε: Hello, i'am trying to insert a new record or update an existing one in case counterID(stands for the page's URL) and cookieID(random number) is the same: try: # if first time for webpage; create new record( primary key is autom

inserting or updating appropriately

2013-10-08 Thread Νίκος Αλεξόπουλος
Hello, i'am trying to insert a new record or update an existing one in case counterID(stands for the page's URL) and cookieID(random number) is the same: try: # if first time for webpage; create new record( primary key is automatic, hit is defaulted ), if page exists then update reco