Has anyone played around with the Yahoo CF API? I need a way to access a
database in one of my yahoo groups.is this even possible? Their
documentation doesn't say yea or nay on this, so any insight would be
helpful. Thanks in advance.
Eric
Yahoo doesn't have a CF API. They have an API. You can hit the API
with CF and you can find an example of this in the Search SDK.
If you are asking about access to Yahoo Groups, I'd check to see if it
is one of the APIs available. I'd hit up developer.yahoo.com. From
what I can see though, there
I knew what I meant Ray :-D. I didn't see anything either, so I figured I
would ask to see if I just missed it. Thanks!
Eric
/*-Original Message-
/*From: Raymond Camden [mailto:[EMAIL PROTECTED]
/*Sent: Monday, July 14, 2008 1:16 PM
/*To: CF-Talk
/*Subject: Re: CF YUI Database question
I am sorry to keep asking these questions, but I have found a lot of helpful
suggestions from this community, so this is where I turn!
I have a rather involved user survey that collects a variety of information,
including age gender, education levels, and so on. On some of the survey
Actually, I have one more database question. I have a section on my
profile-collection form that is a series of radio buttons for
hobbies/interests. What would be the best way to manage/store these values?
My initial thought was to create a table with a row for every hobby/interest
item
On 9/18/07, Joel Watson [EMAIL PROTECTED] wrote:
My initial thought was to create a table with a row for every hobby/interest
item. Then, on the profile table, I was thinking of having a column that
would collect a list of comma delimited values from the form, from 1 to the
number of the
On 9/18/07, Joel Watson [EMAIL PROTECTED] wrote:
My initial thought was to create a table with a row for every
hobby/interest item. Then, on the profile table, I was thinking of
having a column that would collect a list of comma delimited values
from the form, from 1 to the number of
rows in it.
Hope this helps,
William
-Original Message
-From: [EMAIL PROTECTED]
-Date: Sep 18, 2007 12:37
-To: CF-Talkcf-talk@houseoffusion.com
-Subj: Re: One more database question - sorry!
-
-you can create a middle table between the two that has 1 profile
key
-and 1 hobby key per
, 2007 12:19
-To: CF-Talkcf-talk@houseoffusion.com
-Subj: One more database question - sorry!
-
-Actually, I have one more database question. I have a section on my
profile-collection form that is a series of radio buttons for
hobbies/interests. What would be the best way to manage/store
, 2007 12:19
-To: CF-Talkcf-talk@houseoffusion.com
-Subj: One more database question - sorry!
-
-Actually, I have one more database question. I have a section on my
profile-collection form that is a series of radio buttons for
hobbies/interests. What would be the best way to manage/store
-Talkcf-talk@houseoffusion.com
-Subj: Re: One more database question - sorry!
-
-On 9/18/07, Joel Watson [EMAIL PROTECTED] wrote:
-
- My initial thought was to create a table with a row for every
hobby/interest item. Then, on the profile table, I was thinking of
having a column that would collect
So let's say that my form has 20 hobbies/interests. I would be creating
20 entries in this middle table, correct? Is this going to create a
problem if I have hundreds of users?
I would have one table hobby: Hobby_id, hobby_desc, etc, etc.
And another hobby_lookup: Hobby_id, profile_id
This
rows in it.
Hope this helps,
William
-Original Message
-From: [EMAIL PROTECTED]
-Date: Sep 18, 2007 12:37
-To: CF-Talkcf-talk@houseoffusion.com
-Subj: Re: One more database question - sorry!
-
-you can create a middle table between the two that has 1 profile
key
-and 1 hobby key per
Joel Watson wrote:
So let's say that my form has 20 hobbies/interests. I would be creating 20
entries in this middle table, correct? Is this going to create a problem if
I have hundreds of users?
No, you'll have twenty entries in the 'hobbies' table. The middle table
- the lookup
no problem
Let us know how it works out for you.
William
-Original Message
-From: [EMAIL PROTECTED]
-Date: Sep 18, 2007 13:02
-To: CF-Talkcf-talk@houseoffusion.com
-Subj: Re: One more database question - sorry!
-
-Scenario
-
-3 tables
-
-Profile table
--kpProfileID
-
-profile_hobby
As William pointed out, one would usually create a Hobbies table with
your 20 hobbies, then there would be a 'join' table that connects one or
more profiles to one or more hobbies with foreign keys. This is the
standard normalization practice for this type of data relationship.
With proper
On 9/18/07, Joel Watson [EMAIL PROTECTED] wrote:
So let's say that my form has 20 hobbies/interests. I would be creating 20
entries in this middle table, correct? Is this going to create a problem if
I have hundreds of users?
Since you're only storing profile IDs and hobby IDs in that
On 9/18/07, Joel Watson [EMAIL PROTECTED] wrote:
So let's say that my form has 20 hobbies/interests. I would be
creating 20 entries in this middle table, correct? Is this going to
create a problem if I have hundreds of users?
Since you're only storing profile IDs and hobby IDs in
PM
To: CF-Talk
Subject: RE: Database question
More likely when you installed SQL 2k, it installed itself as
a named instance, and possibly on a different port. Make
sure that you connect using the proper port, and proper instance
name.
Instance names are irrelevant to JDBC
Hmm... If instance names are irrelevant to JDBC connections,
then how to you connect to a second instance of SQL on the
same machine? (They would be running on the same port).
No. Each instance requires its own port. SQL Server will not allow you to
share a port between instances.
Dave
I have ColdFusion MX 7 on my local machine. I installed SQL server 2005 and
realized that I needed Sql Server 2000 so I could do DTS. After uninstalling
2005 and installing 2000, it no longer worked. I then heard to installed SQL
server 2000 SP4 and this got me back up and running. I have
What port were you using for 2005 and what port are you using for 2000?
I have both installed at the same time. The only difference is the port.
2005 Express by default assisgns a dynamic port, where as 2000 is set to
1433.
Teddy
On 9/4/06, Rusty Owens [EMAIL PROTECTED] wrote:
I have
I have ColdFusion MX 7 on my local machine. I installed SQL
server 2005 and realized that I needed Sql Server 2000 so I
could do DTS. After uninstalling 2005 and installing 2000,
it no longer worked. I then heard to installed SQL server
2000 SP4 and this got me back up and running. I
, 2006 3:32 PM
To: CF-Talk
Subject: RE: Database question
I have ColdFusion MX 7 on my local machine. I installed SQL
server 2005 and realized that I needed Sql Server 2000 so I
could do DTS. After uninstalling 2005 and installing 2000,
it no longer worked. I then heard to installed
More likely when you installed SQL 2k, it installed itself as
a named instance, and possibly on a different port. Make
sure that you connect using the proper port, and proper instance
name.
Instance names are irrelevant to JDBC connections - it's all about the
ports. But in any case, the
Isn't it though?
In an ideal world, I would have all DB access via Stored Procs, to begin with.
I'm just working with what I got.
Having to do workarounds like this is kinda scary, eh?
Laterz!
J
On 4/20/05, Ali Awan [EMAIL PROTECTED] wrote:
Thanks to everyone who responded to this
No worries, Ali... that's why some of us join these lists.
I'm interested to know, though, why you don't have your system either
use an internally regulated ID number (like an auto-increment
constraint on the column) or use something like a UUID that's
generated outside the database...
Having to
Jared,
LOL, yeah it sounds like an Access issue.
Actually we're using SQL 2k.
Another question though, by using a high isolation level will that slow the app
down significantly? I read in the docs that there's a lot of overhead
associated with it?
Thanks,
Ali
Ali,
You'd be best off to use
I'm not sure but I believe that you can't cflock cfquery's.
Ali
At 07:45 PM 19/04/2005, Ali Awan wrote:
I forgot to add that App1 and App2 are inserting to the same table.
I ended up with 2 records with the same ID.
Couldn't you use cflock to lock the table until the first app is done?
T
---
Well, you can, there is nothing stopping you ...just not very good practice.
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 16:25
To: CF-Talk
Subject: Re: CF Database Question add.
I'm not sure but I believe that you can't cflock cfquery's.
Ali
At 07
How are you generating the ID?
cfquery name=getNewID
Select Max(ID) as myNewID
From TableA
/cfquery
cfset queryname.myNewID = myNewID + 1
cfquery name=AddTableID
Insert Into TableA (tableAID) Values (#myNewID#)
/cfquery
!--- some cf processing ---
cfquery name=AddNewRecord
Insert Into TableB
good practice.
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 16:25
To: CF-Talk
Subject: Re: CF Database Question add.
I'm not sure but I believe that you can't cflock cfquery's.
Ali
Ali Awan wrote:
cfquery name=getNewID
Select Max(ID) as myNewID
From TableA
/cfquery
cfset queryname.myNewID = myNewID + 1
cfquery name=AddTableID
Insert Into TableA (tableAID) Values (#myNewID#)
/cfquery
!--- some cf processing ---
cfquery name=AddNewRecord
Insert Into TableB
Thanks to everyone who responded to this thread.
Especially Jared and Jochem, I will try out the cftransaction with a
serializable isolation level. I think that will solve the problem.
Thanks again,
Ali
Ali Awan wrote:
If you do all this in a serializable transaction, you should be
fine in
Ali,
Wow... ummm... that's a shocker.
As far as isolation levels... umm... which is worse:
A performance Drop
Perpetually Corrupted Data
I have to say that to have the DB set up so that this could happen at
all is a matter of concern for me. It doens't sound like a sound
design. I hope that
I have a question regarding ColdFusion and database requests.
I have 2 applications on different servers, Server A and Server B and they
both access a database on Server C.
The problem is that recently that App1 on Server A and App2 on Server B
ended up hitting the database at the same time.
I forgot to add that App1 and App2 are inserting to the same table.
I ended up with 2 records with the same ID.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and
I forgot to add that App1 and App2 are inserting to the same table.
I ended up with 2 records with the same ID.
This field is not an Identity Field in the DB because it is alphanumeric.
Thanks,
Ali
~|
Discover CFTicket - The
At 07:45 PM 19/04/2005, Ali Awan wrote:
I forgot to add that App1 and App2 are inserting to the same table.
I ended up with 2 records with the same ID.
Couldn't you use cflock to lock the table until the first app is done?
T
---
[This E-mail scanned for viruses by Declude Anti-Virus]
How are you generating the ID?
I forgot to add that App1 and App2 are inserting to the same table.
I ended up with 2 records with the same ID.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
Ali,
You'd be best off to use a CFTRANSACTION with a high isolation level,
like read_committed or even serializable.
I'm gonna take a stab at this and guess you're using Access?
Keep us posted!
J
On 4/19/05, Ali Awan [EMAIL PROTECTED] wrote:
I have a question regarding ColdFusion and
What is the database? SQL 7, Oracle, Access, ?
-Original Message-
From: Ali Awan
I have a question regarding ColdFusion and database requests.
I have 2 applications on different servers, Server A and Server B and they
both access a database on Server C.
The problem is that
Nick Baker wrote:
1. Size. Is a practical size one should limit the DB to.
Depends on hardware.
2. Calculating or projecting future size.
There are 9 tables in my DB. Seven tables contain static info. Using
MyPHPAdmin, I have been monitoring the two dynamic tables to get some idea
Respones inline:
On Tue, 30 Nov 2004 15:04:38 -0600, Nick Baker [EMAIL PROTECTED] wrote:
I am new to MySql and having difficulty understanding several issues.
1. Size. Is a practical size one should limit the DB to. It is my
understanding that there is no technical limit to the number of
I am looking for a way to post information directly to a database from a csv, excel or text delimited file.
I am looking for one of two options.
Option one would give a user the ability to email the file to a specific email address and the server/web app would pull the data from the file
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Michael Grove
To: CF-Talk
Sent: Monday, November 24, 2003 8:44 AM
Subject: CF - post to database question
I am looking for a way to post information directly
this.. Figure it out...haha Arent you the instructor at fig
leaf?
Joe
Certified Advanced ColdFusion Developer
[EMAIL PROTECTED]
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 12:26 AM
To: CF-Talk
Subject: RE: Client Database question
Single point
The only security gained by placing the includes and so forth in an
inaccessible directory, really, is protection against source
code browsing exploits - and a simple application of permissions
can be used to prevent this anyway.
Well, I don't agree totally
I include all of my fuses
of doing
things over another...
Cheers
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 1:02 AM
To: CF-Talk
Subject: RE: Client Database question
If you *keep* them in a web accessible directory then yes,
they're accessible.
Even if you
On 7/25/02, Stacy Young penned:
Sorry Bud but I'm lost dude...restrict INSERT at the CFADMIN level on the
client datasource?
Hi Stacy. Hey! A response to the actual thread. :)
Yes. If you know the datasource name of a client storage database, it
can be queried and updated just like any other
To: CF-Talk
Subject: RE: Client Database question
On 7/25/02, Stacy Young penned:
Sorry Bud but I'm lost dude...restrict INSERT at the CFADMIN level on the
client datasource?
Hi Stacy. Hey! A response to the actual thread. :)
Yes. If you know the datasource name of a client storage database
Basically, this is why I've never set usernames and passwords as
client variables. However, not allowing SELECTs would stop anyone
from stealing them in this manner. I just always figured that
restricting SQL operations would also restrict CF from SELECTing, and
UPDATEing. But some testing
One way hash on passwords definitely the way to go...
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 10:05 AM
To: CF-Talk
Subject: RE: Client Database question
Basically, this is why I've never set usernames and passwords as
client
On 7/25/02, Stacy Young penned:
Ah ok now I get it! ;-)
As for whether you'd have any problems, not sure give it a whirl! Another
suggestion might be to use a dedicated userid/pass for that datasource. Also
I wouldn't necessarily keep users passwords in these tables...For most
occasions I've
AM
Subject: RE: Client Database question
Basically, this is why I've never set usernames and passwords as
client variables. However, not allowing SELECTs would stop anyone
from stealing them in this manner. I just always figured that
restricting SQL operations would also restrict CF from
I've been testing this on my development box and it seems to work.
But before I do it live, does anyone see a problem with restricting
SQL operations to Stored Procedures (which obviously there aren't
any) or INSERT to stop people from querying a client storage
database? I've always tried to
Fusebox and SQL Procedures defnitely provides a good solutions to
Security.
Joe
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 8:06 PM
To: CF-Talk
Subject: Client Database question
I've been testing this on my development box and it seems to work
Fusebox and SQL Procedures defnitely provides a good
solutions to Security.
How exactly does Fusebox affect security? I don't see why it would affect it
in either a positive or negative way.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
Database question
Fusebox and SQL Procedures defnitely provides a good
solutions to Security.
How exactly does Fusebox affect security? I don't see why it would affect it
in either a positive or negative way.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax
: [EMAIL PROTECTED]
-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 9:16 PM
To: CF-Talk
Subject: RE: Client Database question
Single point of entry, lock down few places rather than many...I guess
more
the traits of incorporating
Single point of entry, lock down few places rather than
many...I guess more the traits of incorporating a
controller rather than FB itself...
Unless the controller is actually doing something to heighten security that
wouldn't be done by individual scripts, or being used in such a way to
On 7/25/02, Stacy Young penned:
Single point of entry, lock down few places rather than many...I guess more
the traits of incorporating a controller rather than FB itself...
LOL
This has certainly strayed off of my original question which has
nothing do do with Stored procedures or Fusebox.
If you *keep* them in a web accessible directory then yes, they're
accessible.
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 12:17 AM
To: CF-Talk
Subject: RE: Client Database question
If though FuseBox applications have a single point
]
-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 9:26 PM
To: CF-Talk
Subject: RE: Client Database question
If you *keep* them in a web accessible directory then yes, they're
accessible.
-Original Message-
From: Matt Liotta
Bud wrote:
LOL
This has certainly strayed off of my original question which has
nothing do do with Stored procedures or Fusebox. I'll re-post the
question, which is concerning client database access:
Nice Try.
__
Ladies and gentlemen there you have it! ;-)
I'm out...too tired,
Cheers
Stace
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 12:29 AM
To: CF-Talk
Subject: RE: Client Database question
Which is what every FuseBox application I have ever
Sorry Bud but I'm lost dude...restrict INSERT at the CFADMIN level on the
client datasource?
Stace
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 12:24 AM
To: CF-Talk
Subject: RE: Client Database question
On 7/25/02, Stacy Young penned:
Single
If you *keep* them in a web accessible directory then yes,
they're accessible.
Even if you place them in an inaccessible directory (a good practice for any
file not meant to be invoked directly via the URL, such as Application.cfm,
OnRequestEnd.cfm, custom tags, includes, etc), they will
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?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Pooh Bear [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 15:01
To: CF-Talk
Subject: Database Question
hey guys, I'm working with triggers, how do i make the variable in the
trigger
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)
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 triggers, how do i make
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 insert
How would you handle this?
I have a database table for sales tax that has the following fields:
State, TaxRate
I was using individual tax tables for each store so each table would have 51
records (includes the 50 states + Washington D.C.).
I would like to run multiple stores through the same
[EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 9:33 PM
Subject: Database Question??
I would like to run multiple stores through the same database. This is
why
I added the a storeid field making the fields State, TaxRate, StoreID.
The
only problem is that I would need to add 51 records for each
-
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
: 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 CA the rate
varies
depending on where the business is located. (Or, at least, I think
: 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 CA the rate varies
depending on where the business is located. (Or, at least, I think it
works like this. I could be mistaken).
Jay
-Original
hi,
i've created a database to handle an insurance form which deals with the insurance of
money. it has a number of different tables such as 'cust', which lists details of
customers, 'prem', which lists details of where the money is stored, and 'safe' which
lists details of the safes in
i've created a database to handle an insurance form which
deals with the insurance of money. it has a number of
different tables such as 'cust', which lists details of
customers, 'prem', which lists details of where the money is
stored, and 'safe' which lists details of the safes in
-Talk
Subject: Access database question: how to structure a link between two
tables
hi,
i've created a database to handle an insurance form which deals with the
insurance of money. it has a number of different tables such as 'cust',
which lists details of customers, 'prem', which lists details
Also, don't confuse a safe type - such as a model designation, with a safe
serial number. You would use a safe's serial number as a primary key in
the safe table, as well as a foreign key in the intersection table Dave
described below. To figure out what type of safe it is, you would need
another
, March 20, 2001 7:32 PM
To: CF-Talk
Subject: OT: Database Question
Fellow Listers!
All the talk about @@identity encouraged me to ask this question:
Say I:
UPDATE Table2
SET City = 'Oakland'
WHERE ID IN
(SELECT ID FROM MyTable1 WHERE SpecialID = 3)
This is done all within SQL7, and
SELECT ID
Fellow Listers!
All the talk about @@identity encouraged me to ask this question:
Say I:
UPDATE Table2
SET City = 'Oakland'
WHERE ID IN
(SELECT ID FROM MyTable1 WHERE SpecialID = 3)
This is done all within SQL7, and
SELECT ID FROM MyTable1 WHERE SpecialID = 3
is a comma-delimited list of
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 the
Hi all. Question:
To stop people from accessing a client storage database, how would I
do that? If I set Restrict SQL Operations to INSERT, will
applications still be able to use the database? I'm just trying to
avoid having people read any variables from the database.
Thanks,
--
Bud
htmlDIV
PBRok all you CFMasters.I think i have a relatively simple CF question
concerning databases and CFQuery. But for the life of me am stumped (4 hours to put it
exactly).nbsp; I am trying to build a page with a pull down select menu of different
towns in the state of connecticut.nbsp;
Well, you can't have ALL towns selected.
You need a /select at the end.
And try:
CFQUERY NAME="GetResults" DATASOURCE="Reminder"
SELECT town, organization, headline, body, event_date
FROM GetResults
WHERE town = '#Form.SelectName#'
/CFQUERY
best, paul
At 08:17 PM 12/29/00 -0500, you
You need to put an onChange attribute in your SELECT
tag, so that whenever you select an option from the
list, that name/value pair is submitted to whatever
you specify in your onChange event.
script language=javascript
function doSub{
this.form.submit;
return true;
}
/script
select action=xyz
I am setting up a website in which people are creating records and storing
them in a database (Access 2000 at this time). Am I better off with a
single table that includes all of the records of all users or should I set
up a seperate table for each user? I am pretty sure that the seperate
authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 06 November 2000 14:54
To: CF-Talk
Subject: Database Question
: Database Question???
I am setting up a website in which people are creating records and storing
them in a database (Access 2000 at this time). Am I better off with a
single table that includes all of the records of all users or should I set
up a seperate table for each user? I am pretty sure
CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, November 07, 2000 12:53 AM
Subject: Database Question???
I am setting up a website in which people are creating records and storing
them in a database (Access 2000 at this time). Am I better off with a
single table that includes all of the records of all u
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
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
ithout our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 06 November 2000 14:54
To: CF-Talk
Subjec
: 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 table
:[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 store relevant info on
them
-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 table which holds user information which you can
use to log people
1 - 100 of 109 matches
Mail list logo