I hadn't tried this before, so I was curious and gave it a shot... WHERE 1 = :parameter does not appear to work, but it looks like you can create an always-true "dummy" clause by doing objectName.propertyName = objectName.propertyName, e.g.:
WHERE siteUser.ID = siteUser.ID Ezra Parker On Jan 19, 3:45 pm, "Chris Peterson" <overrid...@gmail.com> wrote: > now i have to dig through source code, maybe I mis-remembered this, could > have sworn... gonna write a quick test case... > > On Mon, Jan 19, 2009 at 6:40 PM, Chris Peterson <overrid...@gmail.com>wrote: > > > > > Sorry, I only laugh because I was in the same situation, where somefield > > IS NULL, or blah = false, and I had to add params for those as well =) Not > > laughing at you, just remembering my frustration > > > Chris Peterson > > > On Mon, Jan 19, 2009 at 6:39 PM, Chris Peterson <overrid...@gmail.com>wrote: > > >> haha, you have to do WHERE 1 = :one > > >> then setparam one = 1, otherwise Transfer tries to parse it =) > > >> Chris Peterson > > >> On Mon, Jan 19, 2009 at 6:27 PM, Doug Boude <dougbo...@gmail.com> wrote: > > >>> 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 be I have a syntax error elsewhere and the > >>> exception catcher was fooled. > > >>> Thanks. > > >>> In case you might wonder why I would add a 1=1, it's so I can simply add > >>> 'AND' to my subsequent clauses and not have to track whether or not it's > >>> the > >>> first clause or not. > > >> -- > >> Hey! I dont tell you how to tell me what to do, so dont tell me how to do > >> what you tell me to do! ~ Bender (Futurama) > > > -- > > Hey! I dont tell you how to tell me what to do, so dont tell me how to do > > what you tell me to do! ~ Bender (Futurama) > > -- > Hey! I dont tell you how to tell me what to do, so dont tell me how to do > what you tell me to do! ~ Bender (Futurama) --~--~---------~--~----~------------~-------~--~----~ 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 because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---