Alex Francis wrote: >> Mark Hughes wrote: >> >>> Hi Lyle, >>> You could try the 'INSERT ... ON DUPLICATE KEY UPDATE' syntax >>> >>> > cool but watch out for bugs with this feature > > more: > http://bugs.mysql.com/search.php?search_for=ON+DUPLICATE+KEY+UPDATE&status[]=Active&severity=&limit=30&order_by=&cmd=display&phpver=&os=0&os_details=&bug_age=0&tags=&similar=&target=&defect_class=all&workaround_viability=all&impact=all&fix_risk=all&fix_effort=all >
Just realized that this is MySQL specific, which makes future ports to MSSQL impossible. Looks like I'm going to have to do a Transaction instead... Which should be fun as I haven't done any before :) Lyle _______________________________________________ BristolBathPM mailing list [email protected] http://mailman.bristolbath.org/mailman/listinfo/bristolbathpm
