Re: SQL insert dupe prevention problem

2006-09-23 Thread Oliver Jato
Am Samstag, den 23.09.2006, 11:06 -0400 schrieb Ben Breslauer: > You really want to use a primary key or unique constraint on table.a in > order to prevent duplicates from being entered. The documentation for > your database should tell you how to set one up. in addition to that you may want to

Re: SQL insert dupe prevention problem

2006-09-23 Thread Ben Breslauer
Dirk wrote: I have a SQL problem INSERT INTO table (a, b, c, d, e, f) VALUES ( "72fa545b9cc60c3b0af851c155128a9d", "a", "b", "c", 1158935640, "f" ) IF NOT EXISTS ( SELECT * FROM table WHERE ( table.a = "72fa545b9cc60c3b0af851c155128a9d" ) ) ; what I'm doing wrong? I want to check table.a