How do I remove myself from this distribution? On 4/13/11 1:30 PM, "Cameron Childress" <camer...@gmail.com> wrote:
>Well, you could try doing an INNER JOIN in your QoQ instead of the IN >statement (yes, you can do joins in QoQ). I've done this before when >I needed to JOIN data from two different databases/servers. One of >those cases where a QoQ is really kinda magical and does something >that's pretty hard to do other ways. > >-Cameron > >On Wed, Apr 13, 2011 at 1:16 PM, Matthew Nicholson ><matthew.nichol...@soltech.net> wrote: >> Depressingly, >> >> I'm stuck with using the QoQ due to the design of the page and the >>business logic built around it. >> >> And thankfully, the variables are all realistically named; I stripped >>that down just to keep the situation simple in the email. >> >> I've yet to try it, but would it make more sense to directly reference >>the parent queries information vs trying to place it in a variable? >> >> So my CFQUERYPARAM would be something like <cfqueryparam >>cfsqltype="cf_sql_integer" value="#ValueList(Excepts.var, ", ")#" >>list="yes">)? > > >-- >Cameron Childress >Sumo Consulting Inc >http://www.sumoc.com >--- >cell: 678.637.5072 >aim: cameroncf >email: camer...@gmail.com > > >------------------------------------------------------------- >To unsubscribe from this list, manage your profile @ >http://www.acfug.org?fa=gin.edituserform > >For more info, see http://www.acfug.org/mailinglists >Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >List hosted by http://www.fusionlink.com >------------------------------------------------------------- > > > ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
