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.