RE: Inner Join Across Two Data Sources?

2006-09-29 Thread James Smith
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. --

RE: Inner Join Across Two Data Sources?

2006-09-28 Thread loathe
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.

RE: Inner Join Across Two Data Sources?

2006-09-28 Thread Andy Matthews
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]

Re: Inner Join Across Two Data Sources?

2006-09-28 Thread Aaron Rouse
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

Re: Inner Join Across Two Data Sources?

2006-09-28 Thread Tim Claremont
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.

RE: Inner Join Across Two Data Sources?

2006-09-28 Thread James Smith
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.

RE: Inner Join Across Two Data Sources?

2006-09-28 Thread Porter, Benjamin L.
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

Re: Inner Join Across Two Data Sources?

2006-09-28 Thread Tim Claremont
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

RE: Inner Join Across Two Data Sources?

2006-09-28 Thread loathe
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

Re: Inner Join Across Two Data Sources?

2006-09-28 Thread Jim Wright
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

RE: INNER JOIN

2005-09-29 Thread Adrian Lynch
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

Re: INNER JOIN

2005-09-29 Thread Saturday (Stuart Kidd)
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,

RE: INNER JOIN

2005-09-29 Thread Ian Tait
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

Re: INNER JOIN

2005-09-29 Thread Saturday (Stuart Kidd)
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

RE: INNER JOIN

2005-09-29 Thread Andy Matthews
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.

RE: inner join help

2005-01-15 Thread Michael T. Tangorre
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

Re: INNER JOIN

2002-06-29 Thread Matthew Walker
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

Re: INNER JOIN

2002-06-29 Thread S . Isaac Dealey
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 ...