that TQL statement in your db for use later on. That's just one
application for TQL that I have personally found and loved.
Just my two cents.
Doug Boude :0)
On Mon, Jun 15, 2009 at 1:28 PM, Cameron Childress camer...@gmail.comwrote:
So, I've been toying with Transfer off and on since CF.Objective
, you can easily write your join queries and then have
Transfer execute them for you! This is my preferred approach, anyway.
Doug Boude
On Thu, Jun 11, 2009 at 1:37 AM, jarthel jart...@gmail.com wrote:
Is it possible to use transfer.get to retrieve fields from multiple
table?
something along
Just to add some concrete examples, here is a function I have in a model
object that uses TQL to retrieve a query of users (optionally only active
users), joined to the security table so that I know what groups a user is
part of:
cffunction name=getAllUsers access=public output=false
I think you hit the nail on the head, Brian, with the keyword being
personally. Myself, I haven't used those tools and don't feel like I have
the need or the time to invest in learning them when my own methodology of
troubleshooting works very well for me, personally. I use different tools at
Good info, Bob. Had I known that little trick yesterday, I never would have
asked that Transfer give it to me. :)
On Tue, Jan 20, 2009 at 4:42 PM, Bob Silverberg bob.silverb...@gmail.comwrote:
One can actually get at this information programmatically, so it
doesn't really need to be added
Hi all.
I looked through the wiki docs, googled it, but couldn't find an example of
this...
can someone show me a snippet of TQL that uses LIKE with percent signs
around the parameter value? I'm not sure if they belong in the statement
string or in the parameter value.
Thanks in advance.
Doug
Okay, one final question for the evening.
I have built a TQL statement that executes just fine, but I'm not getting
any results back when I know that I should. What I want to do is take a look
at the final sql statement that was executed. Is there a method on one of
the objects involved that will
at 2:13 AM, Doug Boude wrote:
Hi all. Probably old hat to some of you (actually I'm hoping that it is),
but I'm needing a solid little snippet illustrating/representing a blurb I
found in a Transfer group post from back in July. The scenario is that I
have two tables who have a many to many
On Wed, Dec 3, 2008 at 9:29 AM, Doug Boude [EMAIL PROTECTED] wrote:
Ah, now here's an odd thing (that took me way too long to uncover):
Trying to do a TQL join
(select S.id, S.server, S.port, S.maxSend,
S.username,S.password,S.isdefault, S.isActive,ST.name as typeName,ST.MTA
as
MTA from
! :)
Doug Boude (formerly anti-ORM, in the process of finding my faith again)
--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message
10 matches
Mail list logo