Jay,
You are absolutely right and I thank you profusely! I screwed up on the
table name. At any rate, this worked fine for me (once I realized the
err in my ways) using OLEDB drivers on CF 5, haven't tested with ODBC.
Thanks so much to all who helped.
John Venable
On Wednesday, February 5
I haven't tried this myself but I think you need a
native driver for this rather than an odbc driver. Can
someone else confirm or deny this?
In any case, you can test this sql by connecting to
your database directly (using sqlplus or other
appropriate tool) and running it.
--- "Venable, John" <[
Hmm, I do this all the time and just verified it works from both CF 4.01
using ODBC and CFMX using the native SQL driver.
Does the user/pass used in your "inforequests" DSN have sufficient rights
to the "content" db?
Jay
At 02:20 PM 2/5/2003, you wrote:
>Is this possible from Cold Fusion? If I
Is this possible from Cold Fusion? If I could do this it would be the best
although I tested it and it didn't work.
this query:
SELECT contacts.date, contacts.firstname, contacts.mi,
contacts.lastname, contacts.address1, contacts.address2, contacts.city,
contacts.state, contacts.zip
Lincoln Milner wrote:
> Within this database, you have one or more instances that live wholly on their own,
>and can only be accessed by one another via dblinks (the "db" starts the confusion).
The official name for an instances is "CATALOG" (ISO 9075).
Jochem
~~
At 12:49 PM 2/5/2003, you wrote:
>Let me narrow the focus a bit. Specifically I have a zipcode database that I
>need to use in various DBs. Is there a "best way" to keep this data current
>across all instances? Should I replicate it when I install the new one?
For something as common as a zip code
helps, I think what
I am referring to as a DB you are calling an instance.
john
-Original Message-
From: Lincoln Milner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 4:02 PM
To: CF-Talk
Subject: RE: DB Strategy
I should like to put my 2¢ in here, since I've often
Venable, John wrote:
> That's interesting, I seem to remember a thread on the list a while ago
> about the best practices for maintenance and security saying that each DB
> should be fairly narrowly focused.
I would say maybe for security, but not for maintenance. In what
scenario do you gain wh
I should like to put my 2¢ in here, since I've often heard the term "database" to be
used inappropriately in conversation, even by those persons "working in the field."
In Oracle, you have one Oracle database, typically. Within this database, you have
one or more instances that live wholly on
esday, February 05, 2003 3:12 PM
To: CF-Talk
Subject: Re: DB Strategy
You can use ColdFusion's query of a query feature to do this.
A more complex route is to write your own custom code to put two queries
together into a new query using the query functions.
However, I do question the c
You can use ColdFusion's query of a query feature to do this.
A more complex route is to write your own custom code to put two queries
together into a new query using the query functions.
However, I do question the comment that you shouldn't put everything in a
big database. Yes, I agree
Venable, John wrote:
> Over time I have created many little web apps that parts of our organization
> use. Inevitably there's time when I also want to utilize that data in the DB
> to pull it to the website, often times relating it to another table that may
> be in another DB. I know there are a va
Over time I have created many little web apps that parts of our organization
use. Inevitably there's time when I also want to utilize that data in the DB
to pull it to the website, often times relating it to another table that may
be in another DB. I know there are a variety of different reasons no
13 matches
Mail list logo