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
tables
text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Database question.
Hey guys,
I need to know how much an Access database can =
handle, like hits per hour type of information. I need to know when I =
build an application which database I can u
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 da
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
http://www.fusionauthority.com/bk
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
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
F-Talk
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 users or should I set
up a seperate table for each user? I am pr
quot;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
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
ted without 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
S
-
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.
C
Voice 412.244.6628
-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 3:48 PM
To: '[EMAIL PROTECTED]'
Subject: Database question.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of t
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
application which
>database I can use. Access or MS SQL. If anyone has any docs or sites that
>state this type of information, please let me know.
>
>TIA
>Shawn Regan
>
>--_=_NextPart_001_01BF9A89.3FBB16A0
>Content-Type: text/html;
> charset="iso-8859-1&quo
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 IDs
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
Fell
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
, 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
gt;
To: "CF-Talk" <[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 probl
-
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
D]>
Sent: Wednesday, July 18, 2001 8: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
sed to disclose, 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 vari
> 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
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.
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
> 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) 7
06
P: [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 gue
> 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. I
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
PROTECTED]
> -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.
>
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.
__
Str
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
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:
&g
> 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 sti
ou do 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 quest
> 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 fus
one way 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 acc
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
5, 2002 9:51 AM
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
> 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 testi
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 pass
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'v
t;
Sent: Thursday, July 25, 2002 10:05 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
Hello,
I have a question regarding database design. I have an application that
will take information for orders. This application will have certain
required fields and certain optional fields. I am wondering what the best
table structure breakdown will work best for this application, as you wi
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 Schnee
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 documentin
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 lea
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 datab
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 rece
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 us
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 wasn
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 o
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 automati
mance considerations.
Hope this is what you were looking for,
Bob
-Original Message-
From: Craig A. Zingerline [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 27, 2000 4:12 PM
To: CF-Talk
Subject: Slightly OT -- Database Question
Hello,
I have a question regarding database design. I ha
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: 28 September 2000 13:03
To: CF-Talk
Subject: RE: Slightly OT -- Database Question
It
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
applica
I'm not sure but I believe that you can't '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 's.
Ali
>
>How are you generating the ID?
>
Select Max(ID) as myNewID
>From TableA
Insert Into TableA (tableAID) Values (#myNewID#)
Insert Into TableB (TableBID, columns...) VALUES (#myNewID#, columnValues...)
Ali
>>I forgot to add that App1 and App2 are inserting to the same table.
>>
>>I ende
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 s
Ali Awan wrote:
>
>
> Select Max(ID) as myNewID
> From TableA
>
>
>
>
>
> Insert Into TableA (tableAID) Values (#myNewID#)
>
>
>
>
> Insert Into TableB (TableBID, columns...) VALUES (#myNewID#, columnValues...)
>
If you do all this in a serializable transaction, you should be
fine i
Thanks to everyone who responded to this thread.
Especially Jared and Jochem, I will try out the 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 MS SQL Ser
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
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 respond
media.com
-
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
ok 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). I am trying to build a page with a pull down select menu of different
towns in the state of connecticut. When the user sele
Well, you can't have ALL towns selected.
You need a at the end.
And try:
SELECT town, organization, headline, body, event_date
FROM GetResults
WHERE town = '#Form.SelectName#'
best, paul
At 08:17 PM 12/29/00 -0500, you wrote:
>ok all you CFMasters.I think i have a relatively si
First off, the select should be generated dynamically something like:
SELECT distinct town FROM GetResults
order by town
#Town#
the next page just looks up the town info:
SELECT town, organization, headline, body, event_date
FROM GetResults
WHERE town = #town#
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.
function doSub{
this.form.submit;
return true;
}
klm
ijk
Hope that helps
Hassan Khawaja
www.com
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 whic
> 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
7:56 AM
To: CF-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 customer
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
anot
85 matches
Mail list logo