Does anyone know if you can actually query of query between more than one
query?
like
SELECTcolumn
FROMquery1, query2
WHEREquery1.id = query2.id
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
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 wrote:
> Does anyone know if you can actually query of query between more than one
> query?
>
> like
>
>
> SELECTcolumn
> FROMquery1, query2
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 wrote:
> you definitely can, one workaround for casting issues is to simply
> serialise to json and back
>
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
num