RE: Stored Procedures - Am I going insane? - Here's what I want to do
Oops, one thing to complicate matters - the primary key on the tables aren't Identities > OK, here's a full description of what I want to accomplish and some > background > > We are working for a client who does Conferences - each conference has a > mini-site which has pages describing it and central "How to get > there" type > pages > > There is one core site which contains the general pages, which are copied > over when a new mini-site is created > > There will be about 200 or so active mini-sites > > Whenever some of the central copy is updated, it should be allowed to be > propogated to all active sites, updating pages which already exist and > adding pages which don't exist yet > > If I was to do this in CF it'd take absolutely ages (esp if you're > propogating 10 pages to 200 sites, checking the existance of each page to > add/update), so I'd rather do it in one Stored Procedure, but I've never > used one for anything this demanding/complex > > Hope this explains more of what I want/need > > Thanks in advance for any assistance Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedures - Am I going insane? - Here's what I want to do
OK, here's a full description of what I want to accomplish and some background We are working for a client who does Conferences - each conference has a mini-site which has pages describing it and central "How to get there" type pages There is one core site which contains the general pages, which are copied over when a new mini-site is created There will be about 200 or so active mini-sites Whenever some of the central copy is updated, it should be allowed to be propogated to all active sites, updating pages which already exist and adding pages which don't exist yet If I was to do this in CF it'd take absolutely ages (esp if you're propogating 10 pages to 200 sites, checking the existance of each page to add/update), so I'd rather do it in one Stored Procedure, but I've never used one for anything this demanding/complex Hope this explains more of what I want/need Thanks in advance for any assistance Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists