[no subject]

2008-11-25 Thread Kevin Roche
Mark, That sounds good to me, because I wouldn't have to remember to do it in every TQL statement. Kevin -Original Message- From: transfer-dev@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: 24 November 2008 21:21 To: transfer-dev@googlegroups.com Subject:

[transfer-dev] Re: cross-database join question

2008-11-25 Thread Dan O'Keefe
Caveats: The databases have to be on the same physical server (or accessible using this dot notation from query analyzer anyway) I believe you can overcome this limitation by configuring a linked server, so you can then prepend the server name as in:

[transfer-dev] Re: Railo 3.0 and Transfer ORM

2008-11-25 Thread Gert - Railo
Hi all, Transfer ORM should run on Railo 3.0.1.x. Luis Majano has tested Canvas Wiki against it lately. And as far as I know there are only the following known issues: Quote from Luis: 1) Transfer cannot validate the datasource.xml with the datasource.xsd, I have no clue why. I had to turn

[transfer-dev] Re: cross-database join question

2008-11-25 Thread Kurt Wiersma
On one of the projects I am working we got around the cross database issue by creating a set of views on the primary database that simply does a select against the the table in another database using the dot notation that Jared mentioned. This has worked well so far. Note this is SQL Server 2005

[transfer-dev] Re: cross-database join question

2008-11-25 Thread Jared Rypka-Hauer
I knew there was a way to do that, it's just been long enough since I did it that I couldn't remember what it was. Thanks, Dan. J On Nov 25, 2008, at 8:28 AM, Dan O'Keefe wrote: Caveats: The databases have to be on the same physical server (or accessible using this dot notation from query

[transfer-dev] Re: cross-database join question

2008-11-25 Thread Jaime Metcher
And a caveat on *that* (while we're doing a SQL Server tutorial) is that under some circumstances joins to tables on linked servers are done by issuing a prepared statement (i.e. stored procedure) against the remote table for *every row* in the local table, which obviously scales like...well,

[transfer-dev] Re: cross-database join question

2008-11-25 Thread Jared Rypka-Hauer
A fish? No, wait, they're easy to scale. A very tall, very smooth tree, coated with grease, while you're wearing vinyl gloves and jellies flip-flops. :) On Nov 25, 2008, at 8:41 PM, Jaime Metcher wrote: And a caveat on *that* (while we're doing a SQL Server tutorial) is that under some

[transfer-dev] Re: cross-database join question

2008-11-25 Thread Bob Silverberg
Combine that with Paul's suggestion and you get something I'd rather not see ;-) On Tue, Nov 25, 2008 at 9:45 PM, Jared Rypka-Hauer [EMAIL PROTECTED] wrote: A fish? No, wait, they're easy to scale. A very tall, very smooth tree, coated with grease, while you're wearing vinyl gloves and