Jim Lyons wrote:
can you not use referential integrity for this - assuming the tables are or can be made to be innodb?
The tables are myISAM. These could be changed to innodb but I want to see if i can get this trigger work.
Does the jobposts table have a jobpost_id field, or is it just "id"? Maybe
Yes. Jobpost_id. No, not a typo. It's primary key, jobposts.adsource_id is foreign key while adsource.adsource_id is primary key.
-- Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/ "In rivers, the water that you touch is the last of what has passed and the first of that which comes; so with present time." - Leonardo da Vinci (1452-1519) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]