Re: [cfaussie] Query of Query between multiple recordsets
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 SELECTcolumn FROMquery1, query2 WHEREquery1.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.
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 SELECTcolumn FROMquery1, query2 WHEREquery1.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.
RE: [cfaussie] Query of Query between multiple recordsets
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 SELECTcolumn FROMquery1, query2 WHEREquery1.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.