Is it possible to use transfer.get to retrieve fields from multiple
table?
something along the lines of:
select a.project_id, b.client_id, b.client_name, a.project_manager
from projects a, clients b where a.client_id = b.client_id and
a.project_id = xxx
I see happening in almost every program
http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Auto_Joins
Mark
On Thu, Jun 11, 2009 at 4:37 PM, jarthel jart...@gmail.com wrote:
Is it possible to use transfer.get to retrieve fields from multiple
table?
something along the lines of:
select a.project_id, b.client_id,
Hi Jarthel.
More than likely there is more than one way to accomplish what you're
asking, but for me the approach I typically take is to leverage one of
Transfer's most beautiful features (to me, anyway): TQL
Using the Transfer Query Language, which you will find to be nearly
identical to SQL,
With TQL you can do a readByQuery() which returns an object, or you can do
listByQuery() which returns a record set. Take your pick.
You cannot do transfer.get() and do custom joins. That will instead
simply return a composed object.
--~--~-~--~~~---~--~~
Before
With readByQuery, I suppose I need to create new entries in transfer
to correspond to my new dataset? (new because the fields are
combination of fields from multiple tables)
something like: http://www.pastebin.ca/1456294 (Please look at the
last object which is applications_users)
Thanks again
Hey Mark,
I started playing with the transfer.codegen functionality in the BER
in an attempt to replace my current usage of TransferConfig+Illudium
PU-36 (riaforge) by implementing a chain of Coldbox Interceptors that
have my special layer to do some *active* codegen during a CB+Transfer
+CS app
Ah very nice!
This would be easier, if we had ColdDoc for the BER release, but I haven't
worked out the best way to do that...
Where you want to be looking is the AbstractBaseGenerator - as this is what
you will be extending.
Writing your own Generators, you will have to look through the code a
This is why your the man.. because you knew what i wanted and you gave
it right to me..
The two things you should probably take note of :
In the init() of the AbstractBaseGenerator, you can see where I have:
setCommentStart(! ---);
setCommentEnd(---);
THANKS.
On Jun 11,
No worries!
Let me know if you run into any issues.
Mark
On Fri, Jun 12, 2009 at 9:12 AM, Adam Drew epne...@gmail.com wrote:
This is why your the man.. because you knew what i wanted and you gave
it right to me..
The two things you should probably take note of :
In the init() of the
ColdDoc..? Is this a Mark+Luis project happening under my radar? What
i mean is who is the *we* you reference with the ColdDoc and what is
the problem with the BER? I have been playing with some java SVN
component that lets me introspect Trunks, Branches and Tags and the
whole self documenting
On Fri, Jun 12, 2009 at 9:44 AM, Adam Drew epne...@gmail.com wrote:
ColdDoc..? Is this a Mark+Luis project happening under my radar? What
i mean is who is the *we* you reference with the ColdDoc and what is
the problem with the BER? I have been playing with some java SVN
component that lets
nvm.. i know what codldoc is cause i am using it...I was over reading
your statement but seriously now.. with thinking about this
quickly ... couldn't I set up a lightweight coldbox app to introspect
my SVN repsoitory, check out the latest trunk to a secured current
ber folder, in order to
But what IF you have the cb app redirect the client to the static
ColdDoc URL no matter what.. the afterConfigurationLoad interceptor
would *update* the ColdDoc's static BER folder before redirecting the
client there... and all you would have to do after a significant API
change was restart the
13 matches
Mail list logo