Keep them in one table.
What you should have is one table which holds user information which you can
use to log people in. Then create other tables to store relevant info on
them. For example. I have a table which store username, password, +
general details of user. I then have a table called
Just use one table. Your application will be difficult to code &
maintain otherwise. I don't think there's any performance benefit
from using multiple tables.
Nick
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 2:54 PM
To: CF-Talk
Subject: Data
I have a similar structure in my database where advertisers can create their
own ads on my accommodation website. I have 7 different categories of
advertisers on my site eg: accommodation businesses; tourist attraction
businesses; local transport businesses etc
Each advertiser chooses their spec
A single table with a column for "user" is much better. Put an index on the "user"
column to speed it up.
If you created new tables for each user you would have to alter your database (create
table and drop table) for every new user and deleted user. You would have to come up
with a naming sch
Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 10:13 AM
To: CF-Talk
Subject: RE: Database Question???
Keep them in one table.
What you should have is one table which holds user information which you can
use to log people in. Then create other tables to
ner.
To add to what Andy said...you should also create primary keys for each
table you create and relate the tables through these keys.
Shane Witbeck
www.digitalsanctum.com
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 10:13 AM
To: CF-T
-
From: Auction Hard Drive [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 11:25 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Database Question???
Each user will have many records, that is why I thought it would be better
to have multiple tables. Otherwise I will wind up with one
al Message-
>From: Andy Ewings [mailto:[EMAIL PROTECTED]]
>Sent: Monday, November 06, 2000 10:13 AM
>To: CF-Talk
>Subject: RE: Database Question???
>
>
>Keep them in one table.
>
>What you should have is one table which holds user information which you can
>use to
he performance right?
>
> Rich
>
> -Original Message-
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 06, 2000 10:13 AM
> To: CF-Talk
> Subject: RE: Database Question???
>
> Keep them in one table.
>
> What you should have is one t
als. its a great book to
learn DB relationships.
Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions
--_=_NextPart_001_01C04845.E43A68E0
Content-Type: text/html;
charset="iso-8859-1"
RE: Database Question???
You could try the book Data
I have an access (2000) table with 75 000 records. More of an experiment
than anything I guess, but it seems to be holding up ok.
I am using it to store all the IP numbers of visitors, then I do a select
distinct IP by day, and spit out a list of pages people looked at.
Suprisingly, it works ok.
d a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--_=_NextPart_001_01BF9A8A.CB93F920
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
RE: Database question.
Microsoft clearly explains that Access is
hawn Regan
-Original Message-
From: Bogesdorfer, Dan L. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 12:59 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Database question.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of thi
Shawn,
Just stay away from Access. You will start out with access fine, but will
have to move to SQL later.
lol
Jacob
At 12:48 PM 3/30/00 -0800, you wrote:
>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be leg
I think you're looking for:
INSERT INTO MtTable3 (ID)
SELECT ID FROM MyTable1 WHERE SpecialID=3
It's as simple as that,
Bob
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 8:32 PM
To: CF-Talk
Subject: OT: Database Question
Fellow Listers!
Thanks!
best, paul
At 09:26 PM 3/20/01 -0500, you wrote:
>I think you're looking for:
>
>INSERT INTO MtTable3 (ID)
>SELECT ID FROM MyTable1 WHERE SpecialID=3
>
>It's as simple as that,
>Bob
~~
Structure your ColdFusion code with Fusebox. Get t
There is no one-line SQL statement that will do that.
You would use some looping structure if you were passing in a list of IDs,
but if this is all occurring in the same batch, you can select your values
into a temp table, then use an INSERTSELECT statement to insert based on
your tempTable v
Umm . . . why does each store need its own sales tax rate for each state?
Does the sales tax vary from store to store?
Scott
-
Scott Brady
http://www.scottbrady.net/
- Original Message -
From: "Rich Tretola" <[EMAIL PROTECTED]>
To: "CF-Talk"
-
From: Scott Brady [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:34 PM
To: CF-Talk
Subject: Re: Database Question??
Umm . . . why does each store need its own sales tax rate for each
state? Does the sales tax vary from store to store?
Scott
ot; <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 9:45 PM
Subject: RE: Database Question??
> Hi Scott -
>
> I think it could vary from store to store - because in some states
the
> sales tax varies from county to county. I know in C
, I think it
works like this. I could be mistaken).
Jay
-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:34 PM
To: CF-Talk
Subject: Re: Database Question??
Umm . . . why does each store need its own sales tax rate for each
s
Triggers, by definition, aren't called by CF, they are automatically
triggered when an action occurs on a table in your db (Insert,update,delete)
so you can't pass data back as CF didn't initiate the trigger
--
Andrew Ewings
Project
> hey guys, I'm working with triggers, how do i make the
> variable in the trigger pass the data back to CF? do i
> need a COM object or somthing?
You can simply return a resultset by building a SELECT within the trigger.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202)
ou are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 16:01
To: CF-Talk
Subject: RE: Database Question
> hey guys, I'm working with trigg
> I don't follow this...can you further explain. If you can't
> call a trigger form within CF (as it is fires automatically by
> the DB when a specific action occurs on a table) then how do
> you get it to return the data to CF?
That's the beauty of it - it'll do it automatically. If you inse
25 matches
Mail list logo