using our own membership db on SQL Server

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply Posted: 18 April 2003 at 3:58am
	I opted for the join simply to rid myself of the need to continue to sync the two tables as the more overlap there is between the tables the more chances exist for an unseen bug to crawl into the system. Since you opted to keep both tables intact, I would suggest creating a stored procedure to sync them on a regular basis (once a day) just to be certain.

ralphuk100 Members Profile Find Members Posts Newbie Joined: 08 April 2003 Status: Offline Points: 10	Post Options Post Reply Quote ralphuk100 Report Post Thanks(0) Quote Reply Posted: 18 April 2003 at 4:05am
	I really don't think I need to do this. The ONLY way to change tblAuthor is through the site registration process. Everytime a change is made to this it also updates tblAuthor. To be honest, this solution will only be in place for a month or so while we build our bespoke shell that will include a fully integrated forum

Post Reply	Page <12

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.