I see where I can create the linked server, but the foxpro
database and the SQL database are on the same server. When I
enter the name of the server, it says I cannot create the
local server as a linked server.
My MSSQL and MySQL servers are both on the same box and it works fine here.
--
No, but you could do three queries and end up with the same result using
query of queries.
-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 12:15 PM
To: CF-Talk
Subject: Inner Join Across Two Data Sources?
I have two databases.
Should be able to. Reference the fields like so:
SELECT dt.fieldname
FROM database1.table1 d1t1
INNER JOIN database2.table1 d2t1
ON d2t1.id = d2t1.id
!//--
andy matthews
web developer
certified advanced coldfusion programmer
ICGLink, Inc.
[EMAIL PROTECTED]
How do you setup the link between MS SQL and FoxPro? Seems like that is the
only way that could be done in a single query.
On 9/28/06, Andy Matthews [EMAIL PROTECTED] wrote:
Should be able to. Reference the fields like so:
SELECT dt.fieldname
FROM database1.table1 d1t1
INNER JOIN
Yup. I am aware of that. I was hoping to get away with one query, but
apparently I am doing it as efficiently as possible already.
Thanks
Tim
No, but you could do three queries and end up with the same result using
query of queries.
Yup. I am aware of that. I was hoping to get away with one
query, but apparently I am doing it as efficiently as
possible already.
In enterprise manager go into security Linked Servers. I have never
tried with fox pro but I have my MySQL server and MSSQL servers working
together nicely.
that they crash cf.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 11:52 AM
To: CF-Talk
Subject: Re: Inner Join Across Two Data Sources?
How do you setup the link between MS SQL and FoxPro? Seems like that is
the
only way that could
I see where I can create the linked server, but the foxpro database and the SQL
database are on the same server. When I enter the name of the server, it says I
cannot create the local server as a linked server.
To clarify, the FoxPro database is in a directory on the same server as the SQL
Maybe try by IP?
The linked server thing is neat, I'm going to have to look into it some
more.
-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 1:40 PM
To: CF-Talk
Subject: Re: Inner Join Across Two Data Sources?
I see where I
Tim Claremont wrote:
I see where I can create the linked server, but the foxpro database and the
SQL database are on the same server. When I enter the name of the server, it
says I cannot create the local server as a linked server.
To clarify, the FoxPro database is in a directory on the
A quick suggestion, write a test page with the minimum of code in. It'll
make it easier for you to debug and easier for us to help.
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 10:50
To: CF-Talk
Subject: INNER JOIN
Hi,
I've been
Hi,
I've simplified it a bit:
cfquery name=GetAuthors datasource=user020
SELECT
tbl_020authorDetails.authorID,
tbl_020authorDetails.authorFirstName,
tbl_020authorDetails.authorSurname,
tbl_020authorDetails.authorPhotograph,
tbl_020authorDetails.authorAboutMe,
You need to use something like ORDER BY authorID
if you're grouping on it.
Ian
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 12:37
To: CF-Talk
Subject: Re: INNER JOIN
Hi,
I've simplified it a bit:
cfquery name=GetAuthors
Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 12:37
To: CF-Talk
Subject: Re: INNER JOIN
Hi,
I've simplified it a bit:
cfquery name=GetAuthors datasource=user020
SELECT
tbl_020authorDetails.authorID
Stuart...
Just FYI...it'll REALLY help with readability, both for you and for us, if
you alias your tables. Like so:
You simply use the AS keyword after the table name in your FROM and INNER
JOIN statements.
FROM tablename AS alias
Or you can do it the easy way and leave off the AS keyword.
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
I am getting a 'missing operator error below'. I don't know what
operator its looking for.
You and Protoculture working the same code or what?
~|
Find out how CFTicket can
What's the deal with ( tblEmployee.EmployeeID IS NOT NULL ) ?
Shouldn't your ON clause be relating one row in one table to a row in
another table?
- Original Message -
From: Paul Ihrig [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 30, 2002 9:57 AM
Subject: INNER
What's the deal with ( tblEmployee.EmployeeID IS NOT NULL ) ?
Shouldn't your ON clause be relating one row in one table
to a row in another table?
It depends on what you're trying to accomplish with the query -- and it
turns out it doesn't work for him I _think_ because he's using Access ...
18 matches
Mail list logo