Would using union help? I've done this before with qoq but I'm not sure of its applicable here without seeing your data sets
Sent from my mobile On 22/08/2012, at 6:13 PM, Zac Spitzer <zac.spit...@gmail.com> wrote: > you definitely can, one workaround for casting issues is to simply > serialise to json and back > > On Wed, Aug 22, 2012 at 6:05 PM, Steve Onnis <st...@cfcentral.com.au> wrote: >> Does anyone know if you can actually query of query between more than one >> query? >> >> like >> >> <cfquery dbtype="query" name="LOCAL.searchResults"> >> SELECT column >> FROM query1, query2 >> WHERE query1.id = query2.id >> </cfquery> >> >> I am trying to do it but seem to be getting casting issues. I have tried to >> case the datatypes to be the same type but still no joy >> >> Steve >> >> -- >> You received this message because you are subscribed to the Google Groups >> "cfaussie" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/cfaussie/-/i9vh8frVHKkJ. >> To post to this group, send email to cfaussie@googlegroups.com. >> To unsubscribe from this group, send email to >> cfaussie+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/cfaussie?hl=en. > > > > -- > Zac Spitzer > Solution Architect / Director > Ennoble Consultancy Australia > +61 405 847 168 > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaussie@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
