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
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
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
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
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
: 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
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
state? Does the sales tax vary from store to store?
Scott
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
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
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
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:
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
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
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-Talk
S
: 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
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C04845.E43A68E0
Content-Type: text/plain;
charset="iso-8859-1"
You could try the book Database design for mere mortals. its a
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
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01BF9A8A.CB93F920
Content-Type: text/plain;
charset="iso-8859-1"
Microsoft clearly explains that Access is really a development
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 this m
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
31 matches
Mail list logo