Did I say that?
I said may be an option
I just hate ayatollahs and never do and always do
Good practice is a harmonious combination of common sense and intelligence,
both being the fruit of experience, not just a
set of black or white rules.
On the other hand, if someone's posting a
Robert:
Personally, I would use a Many to Many lookup table, such as your
suggestion # 1 below.
This lookup table (e.g. userPolls ) would contain two (2) columns that are
Foreign Keys. The columns userID and pollID hold the Primary Keys of
the Users table and Polls table, respectively.
Some
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
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.comwrote:
Avoid the delimited list idea; it always bites you on the arse
Thanks. Delimited list nixed.
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
Agree... we did that for years and we realized that using delimited lists
was a bad approach. Sent some time to undo all that. What a pain.
-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com]
Sent: Monday, August 01, 2011 7:57 AM
To: cf-talk
Subject: Re: Method
I would take a look at using the MINUS union operator, and a table of poll/user
IDs that have completed the poll. MINUS should return only the records in the
first part of the query that are not in the second part of the querythe
first part being the list of candidates and the second part
A cross table is definitely THE standard way to do it.
Although it is not considered good practice by database ayatollah,
a delimited list may be an option when a reasonable number of possible values
is involved.
there are several advantages:
1º it is simpler to update in the database in case
And I was almost going to say, but Claude will post that a delimited list
is a great idea to save you the trouble.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 2 August 2011 02:43, wrote:
A cross table is definitely THE standard way to do it.
Although it is not
a delimited list is a great idea
Did I say that?
I said may be an option
I just hate ayatollahs and never do and always do
Good practice is a harmonious combination of common sense and intelligence,
both being the fruit of experience, not just a set of black or white rules.
I'm not sure how your religious prejudices come into this, but whatever.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 2 August 2011 08:08, wrote:
I just hate ayatollahs
~|
Order the Adobe
Option one is definitely the way to go. If you use a delimited list
you lose the speed and flexibility of indexed SQL, as the list forces
you to do a hierarchical search for the user id each time.
On Mon, Aug 1, 2011 at 6:46 AM, Robert Harrison
rob...@austin-williams.com wrote:
Curious as to
12 matches
Mail list logo