Instructions are at the bottom of every email. On Wed, Apr 13, 2011 at 1:32 PM, Bellevue, David M <david.belle...@verizon.com> wrote: > 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?falogin.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 > ------------------------------------------------------------- > > > >
-- 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=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 -------------------------------------------------------------