i am doing a filtering process combining a cfsearch result set and a result set from a database query. The KEY value from the cfsearch is matching up with the primary key value from the db query. i did notice that the key value from cfsearch is cast as a string where was the id from the db is a number.
i have tried casting both to NUMBER and as STRING but neither worked and still got the casting error and also the error saying that the query was "expecting (like|between)" thing when i try to use "=" in the join -----Original Message----- From: Andrew Myers [mailto:am2...@gmail.com] Sent: Wednesday, 22 August 2012 6:17 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Query of Query between multiple recordsets 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. -- 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.
