I guess that would mean - that you would always use Plural for naming, if
you would follow that naming convention.
Because let's face it, if you are only going store one record in it, then
its hardly worth creating a table for it.
If you use plural you will most likely run into cases where plura
> Isn't that what John was suggesting with an "all foods" flag?
No, John was originally suggesting having a food called "All foods"
> When the SP is run, it would reset the octopus thickshakes association
with your user
The SP I was thinking of would only add the new foods. ;-) I was thinking
w
Joe Celko would also disagree with your idea of singular table names.
Tables contain a set of data. What's in a table describing people? If
you ONLY store one person, then it is a person table. If it stores more
than one person, it is storing people. Typically, tables contain more
than one reco
Isn't that what John was suggesting with an "all foods" flag? The
problem with that is illustrated with your example however. Suppose you
do have the "all foods" flag and you setup a SP to automatically add
that person to the intersection table for any new food. You later
discover he doesn't lik
This was a mistake. The thread has been removed from the archive. The issue
is closed. Please do not post a response.
Thank you
> This would not happen to be you would it?
>
> YHour site looks like shit, has the worst content and attempt at correct
> English grammar, and most of all, you are a com
Oops, I did not mean for this message to be posted here, sorry for that.
I was going to sent it directly to the person who I thought was responsible
for it, I copied the address from one of the posts in this group, I must
have copied it wrong.
Once again my apologies..
Taco Fleur
Blog
http://w
Yes, that was what it was. Norton is not good for everything :)
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 25, 2004 4:32 PM
To: CF-Talk
Subject: RE: HTTP_REFERER
I *think* Norton Internet Security also blocks them.
-Original Messa
This would not happen to be you would it?
YHour site looks like shit, has the worst content and attempt at correct
English grammar, and most of all, you are a complete CF LOSER! Go back to
sales taco bell.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> Hmm, why handle it with code when it can be handled with
> relationships? I would never handle anything in code that
> could be done with the native functionality of the DBMS.
I haven't seen any suggested solution that could handle this problem with
relationships alone. (Note: triggers aren't
Hmm, why handle it with code when it can be handled with relationships?
I would never handle anything in code that could be done with the native
functionality of the DBMS.
Taco Fleur
Blog
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
0421 851 786
Te
> So I'm curious, what do you much more experienced DB guys do
> in such a case? Solve it with a stored procedure? Use a boolean
> field in the Person table for "all food eaters"? Or is there
> an actual way to model this with a field in the PersonFood table?
I would argue that this problem fal
> Thanks Stace for your suggestion - for some reason it's not
> working, I'm probably doing it wrong! And thanks Dave for
> your explanation and alternative, although it's beyond me why
> the installer sets up a shortcut in the start menu that
> doesn't work unless you take other steps. Obvious
In this instance in the past I've added simple triggers to the tables in
question and run inserts into the link tables where required. Where there is
a deletion, I've left it to the cascading deletes to take care of the link
table.
If in doubt, let the database do the work!
Paul
[Todays Thre
What Matthew is saying in regards to the flag is correct.
Add the flag "foodAll" BIT to the person table (or whatever you call it) and
as soon as you add a new food you need to scan all persons that have the
flag of "fooAll" set to 1 and add a relation for that new food.
If this is the way you need
> And I'd suggest you stick non plural naming anywhere, because as soon as
you
> start to use plural naming you will have to start thinking "now what did I
> use there, food or foods?" Stick to non-plural...
I used to use plurals all the time, and then realized that I hated dealing
with irregular
> The only CORRECT way of doing this is to store an entry for each food in
the foreign table.
Yeah that's what I was suggesting, but supplementing that with a flag to
indicate that certain people should be subscribed to new foods
automatically. Nothing sophisticated.
Regarding table naming, sure
See the easycfm.com tutorial section. They have a tutorial on ending
sessions in just a few lines of code. I believe they loop through the
code...
Rino
>From: "Stuart Kidd" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Killing clients in one
There is just no way this would work correctly, if for some reason you don't
trust my answer maybe should be asking the question in a DB mailing list or
forum?
The only CORRECT way of doing this is to store an entry for each food in the
foreign table.
And I'd suggest you stick non plural nami
What about the case where I like all foods except mushrooms? Perhaps a nice
approach would be to have a flag on the person's record saying
"automatically assume I like newly added foods". Then when you add a food,
either a stored procedure or whatever would add the relationship for all
people with
>What I usually do, since I don't need to run this utility too often, is just
>open a command prompt and enter the following:
>
>C:\jrun4\runtime\jre\bin\java.exe -jar c:\jrun4\lib\wsconfig.jar (change
>drive letters appropriately)
Thanks Stace for your suggestion - for some reason it's not workin
This example shows how to create a Word document, using "Hello World".
ACTION="">
CLASS="Word.Application"
NAME="objWord"
TYPE="COM">
ACTION="">
CLASS="Word.Application"
NAME="objWord"
TYPE="COM">
/*
Hi John,
I wouldn't add an "All foods" in the intersection table. You certainly
could have an all food boolean in the persons table (note: table names
are normally plural since they contain a set of information) You could
write a stored procedure to delete all entries for a person and add an
You would store each id of the foods in the reference table, no matter how
many there are.
You would need to apply to many hacks to do it any other way, and it would
really not be a correct relationship anymore.
BTW. who like's Taco's ;-))
Taco Fleur
Blog
http://www.tacofleur.com/index/blog/
I ran into a fascinating problem today, but I'm pretty sure it's not unique.
Surely someone on here has thought about this before:
Imagine you have a table of Person and a table of Food, and you have a
PersonFood table that models which people like which food using two foreign
keys, such as Person
If you open one of your old mails, the smtp server settings will be set to
your old IP address of the old server or the old name of the old server.
Either you can grep the files and replace the address of the smtp server
OR
If you have a server name rather than an IP address, add an a
I have another clue!
New emails go right through the system..It is only the old ones. (There
are about 4,000 of them) that are stuck.
I cleared out the coldfusion/mail/spool directory (I moved them to a temp
folder) .. then triggered an email from a feedback form, and it worked
perfectly
note that this requires M$ Word to be installed on the server. Check out www.cfcomet.com for schtuffs along this line.
I can't recall where I saw this, but there is a way to create rtf files server side, rtf is kind-of-sort-of like ps, then dump this file to the client via cfcontent. M$ Word
Hi Al, I am running BlackIce
as well.
Sometimes I have to completely reboot
the box because of some reason Blackice holds
the ports blocked. Try that and
also try if you can reach port 25 from both
sides if the sending smtp-server is outside Blackice.
(telnet ip-adress 25)
Uwe
AMD> Hi.
AMD> What
I can answer that one for you.
action=""
class="Word.Application"
name="objWord"
type="COM">
action=""
class="Word.Application"
name="objWord"
type="COM">
objWord.Visible = true;
objDoc = objWord
> I'm setting up a testing/experimentation environment with
> Win2K3 running under Virtual PC. I installed CFMX 6.1 (30 day
> trial), choosing the j2ee w/ jrun option, and that all seemed
> to go fine - am I correct in assuming that JRun is running on
> top of IIS, and CFMX is running as a J2EE
I am looking to convert some VB syntax to work with the Word Object, lines
like;
Selection.InsertBreak Type:=wdPageBreak
Is it even possible to work with every method/property of the word object in
ColdFusion? If so, how would the above translate in ColdFusion?
Taco Fleur
Blog
http://www.t
How do you create a word document in cf?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hi Kay,
Try adding C:\JRun4\runtime\jre\bin (your path might be different -
i.e. if u installed it on another drive etc) to your PATH environment
variable in your windows settings. Think that should fix you up.
Cheers,
Stace
_
From: Kay Smoljak [mailto:[EMAIL PROTECTED]
Sent: Sunday,
I *think* Norton Internet Security also blocks them.
-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED]
Sent: Monday, 26 January 2004 5:27 a.m.
To: CF-Talk
Subject: RE: HTTP_REFERER
I use it.
I get an empty string when they use a Bookmark or type in the URL. If they
click a link
Hi.
What a horrible weekend.. the ISP I co-locate my server at had to change
the IP range that we use.. (they changed providers)
I got everything working, except for some reason, I can't get cfmail to
work. I am using cf 5.0.0.0 enterprise. It was working fantastic for years
until the change
CF 5.0
I am working on a template plotting 24 hours of data collected every 5
minutes. We want hourly Tic Marks along the bottom of the graph.
The following works but the Tic Marks are not properly aligned. Plotting
form left to right the first Tic Mark (representing the start) is fairly
c
Hi Rick,
cgi variables are always defined, you just need to check if they are
populated.
you could do
Taco Fleur
Blog
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
0421 851 786
Tell me and I will forget
Show me and I will remember
Teach me and
I use it.
I get an empty string when they use a Bookmark or type in the URL. If they
click a link it works. Also I believe you can turn header info off in some
browsers.
So I use a IsDefined(CGI.HTTP_REFERER) and
Before outputting it.
Rick
-Original Message-
From: Robert Baile
On every one of our CFMX servers(18 of them!), when using this:
#CGI.HTTP_REFERER#
It never returns anything, just an empty string. Anyone have this problem at
all?
CFMX 6.01 (latest update, some are standard install, some are installed with
JRUN), IIS 6, 2003 server
[Todays Threads]
[This Mess
Michael T. Tangorre said:
> In an access db I have a table with a colum in it called
> "startDate". What I would like to do Is return all the records in
> the table where the difference between the "startDate" and the
> current date (Date() or now()) is 30 days, or whatver number of days
> for that
In an access db I have a table with a colum in it called "startDate". What I
would like to do Is return all the records in the table where the difference
between the "startDate" and the current date (Date() or now()) is 30 days,
or whatver number of days for that matter What would be the easies
That did it. Thanks guys
- Original Message -
From: Robby L.
To: CF-Talk
Sent: Saturday, January 24, 2004 7:52 PM
Subject: RE: so what am I doing wrong?
>And what is the definition of the field you are trying to update? - memo
IIRC, cf_sql_longvarchar is the datatype you'
Thanks, Michael and Ben.
Actually, I had ordered the book from Amazone.com back in November. I'll be definitely going to buy it. So far I haven't gone wrong with A Ben Forta book!
irvin
> I've heard from the technical editor that it's great. I can't speak on
> it's publishing date, but I'd su
Hi Brook, thanks.
I will find this out too, hopefully.
It looks as if Argosoft is
a great price/performance product.
Uwe
BD> I am running both IMS-SE and Argosoft. IMS-SE for bulk mailings and
BD> ArgoSoft for all other mail send by our web apps. I estimate we send about
BD> 1000-2000 emails per
I'm setting up a testing/experimentation environment with Win2K3 running under Virtual PC. I installed CFMX 6.1 (30 day trial), choosing the j2ee w/ jrun option, and that all seemed to go fine - am I correct in assuming that JRun is running on top of IIS, and CFMX is running as a J2EE application o
We have a weird problem happening with our server. I have figured out the
how, but can't figure out they why, and/or how to prevent it.
We have Win2k with CF 4.5 running. We also have our stats program run every
night (basically a scheduled CF page which CFExecutes a bunch of .BAT
files). Now
46 matches
Mail list logo
