>>>Avoid the delimited list idea; it always bites you on the arse eventually.
Yeah, what James said. Been there, did that, and arse was summarily bitten. G! On Mon, Aug 1, 2011 at 10:57 AM, James Holmes <james.hol...@gmail.com>wrote: > > Avoid the delimited list idea; it always bites you on the arse eventually. > Use the first option. > -- > WSS4CF - WS-Security framework for CF > http://wss4cf.riaforge.org/ > > > On 1 August 2011 21:46, Robert Harrison <rob...@austin-williams.com> > wrote: > > > > > Curious as to what you all think is the best method for something. I > have > > a table that contains a list of polls. I have a user table that contains > a > > list of possible persons who may complete the poll (it requires log-in > > access). I want to present a poll only one time so users can't complete a > > poll more than once, so I need to maintain a list of users who have > > completed a poll. > > > > I see two ways I can do this: > > > > 1. I can create a cross reference table that keeps users ID and Poll IDs > > (of users/polls completed), then use an SQL NOT IN to select polls for > users > > who are NOT IN the completed poll table. > > > > 2. I can add a field in the POLLs record and put a delimited list of User > > IDs who've complete the poll, then not select any polls where the > COMPLETED > > field contains the user ID of a given user. > > > > There are about 1,500 users. There will probably be not more than 10 > polls > > going on at any one time. Poll history will be maintained for about 60 > days. > > Thus, there may be thousands of COMPLETED records. > > > > Given that, is one of these methods better than the other, and if so, > why? > > > > Should I use a delimited list in the POLL record, or should I use a > > cross-reference table with a join and NOT IN select... or should I do > > something different. > > > > Thanks > > > > > > Robert B. Harrison > > Director of Interactive Services > > Austin & Williams > > 125 Kennedy Drive, Suite 100 > > Hauppauge NY 11788 > > P : 631.231.6600 Ext. 119 > > F : 631.434.7022 > > http://www.austin-williams.com > > > > Great advertising can't be either/or. It must be &. > > > > Plug in to our blog: A&W Unplugged > > http://www.austin-williams.com/unplugged > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm