It is not just a typo that you make in the SQL command. You often need
to do

        insert into table which has primary key
        if the insert failed, do update of the existing record

Do the update first then the insert.

Chris


---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to