Just to toss in a way that I use TQL that I didn't see mentioned yet...
Some apps I write have an area where the user is able to "build" data sets
by selecting/entering multiple criteria. In order to store these data set
definitions/queries for future use, I could store the individual choices
that
user criteria selections in your form, then
store 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 wrote:
>
> So, I'v
cal to SQL, 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 wrote:
>
> Is it possible to use transfer.get to retrieve fields from multiple
> table?
>
> som
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:
;t do anything magical to character
> encoding, it should just flow through.
>
> I can't remember.. do you need to change your collation on the DB side?
>
> Mark
>
> On Thu, Jan 22, 2009 at 8:07 AM, Doug Boude wrote:
> > Hi all. forgive me if the answer to this already
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
dif
Hi all. forgive me if the answer to this already exists somewhere, but I
couldn't find it via google or in the documentation.
What is a very nutshell example for properly inserting unicode values into a
table using Transfer? Is there any special attribute values in the config
file I need to set? M
I'm not familiar enough with Mach II to tell you specifically, but I do know
that most of the frameworks have a method available whose purpose in life is
to take the incoming event arguments and automatically populate a bean.
Model Glue has it's "makeEventBean" method, Coldbox has it's
"beanfactory
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 wrote:
>
> One can actually get at this information programmatically, so it
> doesn't really need to be added into Transfer.
>
> To get
It isn't reinventing the wheel for me. I am developing an app, I am doing it
a certain way (personal choices, approaches, methodologies, etc.), and in
order to debug an ajax call I was making, the most convenient and easiest
thing for me at the time would have been if I had an easy way of simply
re
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
Okay, maybe I'm trying to do something silly here, but it is a technique
I've employed extensively "pre-ORM", so can anybody tell me if this is
'legal' with Transfer?
"... WHERE 1=1 AND "
I'm getting an error that seems to point to that bit of TQL, but is that
truly illegal in TQL? It could
Thanks! That's what I needed.
On Mon, Jan 19, 2009 at 4:31 PM, Ezra Parker wrote:
>
> Hi Doug,
>
> The percent signs should be in the parameter value:
>
> objectName.propertyName LIKE :parameterName
>
>
>
> Ezra Parker
>
> On Jan 19, 2:09 pm, "Do
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 adva
ons (clearPermission())
> c) loop over the list (changed to an array) of IDs
> d) if the ID is persisted, add it
>
> Then save the object. Done.
>
> HTH
>
>
>
> On Thu, Jan 8, 2009 at 2:13 AM, Doug Boude wrote:
>
>> Hi all. Probably old hat to some of you (ac
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 relationship... users to
preferences.
fer are you using?
>
> Mark
>
> 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,
r.xml.cfm'." error.
If, however, I simply change my package name from 'smtp' to 'SMTP' WITHIN
THE ONETOMANY DEFINITION ONLY (I didn't touch the defined package name
itself, NOR the TQL statement), it executes flawlessly. Everywhere else I
refer to the package as
would be MOST
appreciated! :)
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
19 matches
Mail list logo
