You could also use WHERE siteUser.ID IS NOT NULL, assuming that the field does not allow nulls. That's what I sometimes do.
Bob On Mon, Jan 19, 2009 at 7:06 PM, Ezra Parker <ezrapar...@gmail.com> wrote: > > 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) > > > -- Bob Silverberg www.silverwareconsulting.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
