yeah, we're heading back into the capitol area, from dinner. Barack says to do it my way. He's also making me CTO Of the USA. Coldfusion forever and forever coldfusion!
Dan On 1/19/09, Gmail <bob.silverb...@gmail.com> wrote: > > Hey, > > I thought you were busy with your fiancé in DC. ;-) > > Please ask Barack how he would approach the issue using TQL so we can > settle the matter once and for all. > > Sent from my iPhone > > On 19-Jan-09, at 10:11 PM, "Dan Wilson" <sipac...@gmail.com> wrote: > >> >> All of you are right in a way. >> On the other hand, I totally dismiss the use of junk clauses in SQL >> statements. >> >> Apart from being ugly, where 1 =1 can throw off indexes, cause query >> execution plans to flush more frequently and generally add nothing >> useful. >> >> Try and avoid them when possible. >> >> Dan >> >> On 1/19/09, Bob Silverberg <bob.silverb...@gmail.com> wrote: >>> >>> 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 >>> >>>> >>> >> >> >> -- >> "Come to the edge, he said. They said: We are afraid. Come to the >> edge, he said. They came. He pushed them and they flew." >> >> Guillaume Apollinaire quotes >> >> > > > > > -- "Come to the edge, he said. They said: We are afraid. Come to the edge, he said. They came. He pushed them and they flew." Guillaume Apollinaire quotes --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---