27
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born"
the Scottish Rogues
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 12:37 pm
To: CF-Community
Subject: Re:
>> :)
>>
>> Do not be afraid, Tongue Tongue is just tasting you. But
>> to not
>> struggle for the tongue is a powerful muscle and he could
>> crush you
>> quite easily. Tongue Tongue is all tongue, I am Dr. Mung
>> Mung.
> You know, I think I'd be even more disturbed if I knew
> what the hell
> t
> :)
>
> Do not be afraid, Tongue Tongue is just tasting you. But to not
> struggle for the tongue is a powerful muscle and he could crush you
> quite easily. Tongue Tongue is all tongue, I am Dr. Mung Mung.
You know, I think I'd be even more disturbed if I knew what the hell
that meant.
--Ben
S.Isaac Dealey wrote:
>>Geez. Aren't you kinda embarrassed, having to
>>learn this stuff from a vanilla straight man?
>>And no jokes about how I taste!
>
>
> I can taste your baaack!
Hope you like the taste of hair.
--Ben
~|
> Geez. Aren't you kinda embarrassed, having to
> learn this stuff from a vanilla straight man?
> And no jokes about how I taste!
I can taste your baaack!
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
> No, no, no. Nylons go on lamps. Not LAMPs, lamps.
> Haven't you seen _A
> Christmas Story_? That's electrical work, not carpentry.
Oh yes, how silly of me. :)
> Geez. Aren't you kinda embarrassed, having to learn this
> stuff from a
> vanilla straight man? And no jokes about how I taste!
No, no, no. Nylons go on lamps. Not LAMPs, lamps. Haven't you seen _A
Christmas Story_? That's electrical work, not carpentry.
Geez. Aren't you kinda embarrassed, having to learn this stuff from a
vanilla straight man? And no jokes about how I taste!
--Ben
S.Isaac Dealey wrote:
> Sex and c
Sex and carpentry? ... umm... gee Ben, I never knew you were so kinky.
:) But then, a good table leg is always long and hard. :P I wonder if
there's a market for nylons for table-legs for guys with a carpentry
fetish?
> You forgot about carpentry and ALTERing TABLES.
> Pay attention!
> --Ben
>
With any DB so long as you truncate in the correct order you shouldn't have
a problem anyway.
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 28, 2005 11:15 AM
> To: CF-Community
> Subject: Re: Relations in the db
>
&
Neener neener neener. :P The point is that there are ways around it -
if one needs to use them.
On 7/28/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
> Deanna Schneider wrote:
> > When I need to truncate a table, I just temporarily suspend the
> > constraint...
>
> I just use a database that
Deanna Schneider wrote:
> When I need to truncate a table, I just temporarily suspend the constraint...
I just use a database that can truncate tables and maintain constraints...
Jochem
~|
Find out how CFTicket can increase your
You forgot about carpentry and ALTERing TABLES.
Pay attention!
--Ben
S.Isaac Dealey wrote:
>>Ok - everytime I see this thread I think "Relations in the
>>DB? Someone is having sex in a database?"
>
>
>>:D
>
>
> Well, you know, a lookup triggers us and we have to drop our drawers
> and perfor
elopment phase is over?
>
> You should NEVER be truncating a linked table in a production DB.
>
> > -Original Message-
> > From: Marlon Moyer [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, July 27, 2005 4:02 PM
> > To: CF-Community
> > Subject: Re: R
CF-Community
> Subject: Re: Relations in the db
>
> That's the angle I'm trying to use, but as it stands now, there's no
> other app creating the data aside from the VB app. I've found out
> that the reason it was left out originally was that the designer
&g
When I need to truncate a table, I just temporarily suspend the constraint...
-- Alter table and truncate
alter table mytable disable constraint myconstraint;
truncate mytable;
alter table mytable enable constraint myconstraint;
On 7/27/05, Marlon Moyer <[EMAIL PROTECTED]> wrote:
> That's the ang
> Ok - everytime I see this thread I think "Relations in the
> DB? Someone is having sex in a database?"
> :D
Well, you know, a lookup triggers us and we have to drop our drawers
and perform and insert on the table... it's a real procedure, we've
kicked over the LAMP a few times, but at least the
Drity Dirty girl
-Original Message-
From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 5:44 PM
To: CF-Community
Subject: RE: Relations in the db
Ok - everytime I see this thread I think "Relations in the DB? Someone
is having sex in a database?
Ok - everytime I see this thread I think "Relations in the DB? Someone
is having sex in a database?"
:D
/me runs
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusi
ways count on a single
application being the only interface into the database. You should keep
the rules as far down as possible.
M!ke
-Original Message-
From: Jennifer Larkin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 2:20 PM
To: CF-Community
Subject: Re: Relations in the d
groups of data, and keep the
integrity.
It is the sign of developers that are more worried about getting it done
fast than getting it done right.
> -Original Message-
> From: Marlon Moyer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 27, 2005 4:02 PM
> To: CF-Community
>
Marlon Moyer wrote:
>
> Aside from the obvious reason of keeping the db logic inside of the db
> and built in referential integrity, I was stumped. I thought given
> the relationships, sqlserver gets hints as to how to speed up joins
> and such.
No it doesn't. The indexes that get created on keys
That's the angle I'm trying to use, but as it stands now, there's no
other app creating the data aside from the VB app. I've found out
that the reason it was left out originally was that the designer
thought it would be faster and having a defined relationship precludes
the use truncating a table.
What about multiple application interfaces? Sure right now it's all
going through a VB app, but what happens when you want to use the VB
app for the internal business side but have parts of the data tied in
to a CF web app for extranet customers or something?
-Kevin
On 7/27/05, Marlon Moyer <[EMA
> Aside from the obvious reason of keeping the db logic
> inside of the db
> and built in referential integrity, I was stumped. I
> thought given
> the relationships, sqlserver gets hints as to how to speed
> up joins
> and such. I've already suggested that different programs
> that use the
> dat
Sure,
The keys can help speed and many other things. But I've also noticed that
people leave this stuff in the code to prevent others from figuring out how
all the data ties together.
As for my personal opinion, yes, there should be relationships defined in
the DB, it will make things faster and
TECTED]
> Sent: Wednesday, July 27, 2005 3:20 PM
> To: CF-Community
> Subject: Re: Relations in the db
>
> Does he have defined primary keys at all? Primary keys are a huge
> performance benefit. Foreign keys are probably a benefit too, but I
> don't know that for sure.
>
&g
Sadly almost all of our projects here are done this way with the exception
of they rely on CFM instead of VB. The project I am trying to finish up
right now I put the ref. int. checking in the database and to help sell the
idea I made a custom tag and stored procedure that makes it a no brainer
Does he have defined primary keys at all? Primary keys are a huge
performance benefit. Foreign keys are probably a benefit too, but I
don't know that for sure.
The main reason that I would define it is referential integrity. You
can't be guaranteed that the VB application is flawless.
On 7/27/05,
I like doing both.
But the difference (to me) is that in one case, your application is
preventing itself from inserting bad data. In the other case, the
database is preventing ANY application from inserting bad data.
I can't tell you how many times I've had to fix data because someone
hand-tweake
29 matches
Mail list logo
