Reply to Re: How do you conditionally fire a trigger (mimic replication)

Your name:

Reply:


Posted by Kart on 10/19/06 21:56

Hi,

You can't switch off triggers

Cant you have one more column to the changes table to tell which server
has inserted that data?

Kart

samh wrote:
> Alex,
> Thanks for suggestion. Replication is not possible, the client this is
> being developed for is insisting on not using it so I don't have much
> choice.
>
> The problem I have is that the example I gave is a basic version. I
> have 1 central server and 6 local servers so giving odd/even isn't
> possible. All the local servers are replicating their changes to the
> central server and it's in turn replicating back down to the local
> server which sent the data. The problem that I described above is
> still essentially the problem I need to solve.
>
> I thought there would of been a very easy way to turn of triggers but
> this seems not the case?
>
> Cheers,
> Steve.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация