Re: [cfaussie] Re: CF10 WSDL
It essentially means that you're now using Apache Axis1 instead of Apache Axis2. Axis1 is the SOAP web service engine that CF used to use since support for web services was added. For a variety of backwards compatibility reasons it has been left in the product and can be enabled through the admin and (I think, but I might be wrong) also through an attribute in code. Cheers Kai We had the same problem - went in to CFAdmin and changed 'Web Service Version' to 1 instead of 2 (seems to be the default) - I haven't read the docs on what the difference is.. Maybe someone else can help us there -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 179 091 web: http://www.ventego-creative.co.nz Blog in Black: http://www.bloginblack.de 2DDU Podcast: http://www.2ddu.com/ Twitter: @AgentK -- -- 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] Re: CF10 WSDL
Hi Kai, You are correct. You can override the CFADMIN setting in code via an Application.cfc setting or as CFC metadata. From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Kai Koenig Sent: Wednesday, 22 August 2012 16:07 To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: CF10 WSDL It essentially means that you're now using Apache Axis1 instead of Apache Axis2. Axis1 is the SOAP web service engine that CF used to use since support for web services was added. For a variety of backwards compatibility reasons it has been left in the product and can be enabled through the admin and (I think, but I might be wrong) also through an attribute in code. Cheers Kai We had the same problem - went in to CFAdmin and changed 'Web Service Version' to 1 instead of 2 (seems to be the default) - I haven't read the docs on what the difference is.. Maybe someone else can help us there -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 435 179 091 web: http://www.ventego-creative.co.nz Blog in Black: http://www.bloginblack.de 2DDU Podcast: http://www.2ddu.com/ Twitter: @AgentK -- -- 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.
[cfaussie] Query of Query between multiple recordsets
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.
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.