Re: CF to Salesforce.com API?
Hi Dave, I am following up on your post from May 2009http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:59366where you wrote: Code samples will follow soon Is there a link where code samples can be downloaded? Thank you for the slideshttp://figleaf.acrobat.com/cfobjective2009/cfsalesforce ! I am starting a project for user group communities using ColdFusion with Salesforce (integrating with data from groups.adobe.com). Thank you for highlighting stumbling blocks in your slides from cf.Objective. I hope we can get off to a much faster start knowing what you have highlighted. And also thanks to Tom de Manincor's Salesforce.cfchttp://salesforcecfc.riaforge.org/(which your slides also highlight). Best regards, g On Thu, May 14, 2009 at 11:43 AM, Dave Watts dwa...@figleaf.com wrote: I'm guessing that the API is technology neutral (Java, PHP, CF, etc.) since it accepts WSDL/SOAP requests. Is this accurate? Yes, although CF's default web services interface is a little too simple to do everything you need directly. That said, you can do it all from CF; I'm giving a presentation on how to do this in about five minutes here at cf.Objective. The URL for the presentation is here: http://figleaf.mmalliance.acrobat.com/cfobjective2009/cfsalesforce/ Code samples will follow soon. Basically, the big problems are: - you have to use SOAP headers (not really a big problem), - you have to dynamically change the endpoint (this isn't a big problem once you figure out how to do it, - you have to use the Java stub classes to create new records, etc I'm also weighing a build or buy decision with regard to a data connector between Salesforce and our ERP system (Pervasive SQL database). If I have a working knowledge of SSIS, do I really need to spend the money for a connector? Probably not, but it's a question of how much time you want to sink into it as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
VMWare Open BlueDragon image made available
Good news! The following post went up about 1 hour ago: VMWare Open BlueDragon image made available http://blog.sixsigns.com/2008/05/11/vmware-open-bluedragon-image-made- available/http://blog.sixsigns.com/2008/05/11/vmware-open-bluedragon-image-made-available/ See download link in page at the link above. Note that the download is of a zip that is 1GB. Happy CF'ing! [image: :-)] g ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How Many CF Developers Are There: Dave Mendels Says 300K
Just an fyi ... John Dowdell excerpted some comments that Dave Mendelshttp://www.adobe.com/aboutadobe/pressroom/executivebios/davidmendels.htmlhad posted last month: http://weblogs.macromedia.com/jd/archives/2007/02/flex_adoption.cfm Specific quote from Dave Mendels: We have an active community of about 300K ColdFusion developers, well over a million Flash designer/developers, and several million Dreamweaver customers. The post that Dave was commenting on was written by Shashank Tiwarihttp://www.oreillynet.com/pub/au/2799who started his post out with: Today we have between 3 and 4 million Java developers. g ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion is a key part of Adobe's core business, important strategically over the next year.
*fyi ... following of John Dowdell's blog from Wednesday: http://weblogs.macromedia.com/jd/archives/2007/01/cf_nugget.cfm http://weblogs.macromedia.com/jd/archives/2007/01/cf_nugget.cfmCF nugget: * Just a datapoint here... I'm sitting in a company-wide meeting right now, and am under the usual NDA and must be vague, but Shantanu Narayenhttp://www.adobe.com/aboutadobe/pressroom/executivebios/shantanunarayen.html[Adobe President and COO] is talking about priorities over the next year for Adobe, and ColdFusion is a key part of the core business, important strategically over the next year. CF and Scorpio were specifically called out in the presentation. Sorry for the (necessarily) skimpy info, but I wanted to pass this along. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamicaly Building CFSTOREDPROC tag, can it be done?
Andy, I think you can still execute procs in CFQUERY. If you want, try using CF to build up the SQL that calls the proc in variables, and then send it to the server by putting the #sqlprocstmt# inside a CFQUERY block. e.g.: CFQUERY ... #sqlprocstmt#/CFQUERY Executing procs via CFQUERY limits you to capturing only 1 result set (for more than 1 result set you need CFPROCRESULT). Please do post back and let us know what approach you end up using. Also, just curious, what database are you using? hth, g ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flash Media Server question
Eric, This page out of the FMS docs gives a good, simple overview of what you need to do: Preview of Development Tasks: To create and deploy a Flash Media Server application, complete the following tasks: http://livedocs.macromedia.com/fms/2/docs/0024.html As Kevin said in his reply, yes FMS does have a concept of an application that must be set up first. fyi ... At runtime, following is basically the sequence of events: ColdFusion page is requested -- CF page returned to browser -- CF page includes Flash SWF -- Flash SWF requests FLV using RTMP protocol -- Flash Media Server streams FLV back to SWF. btw ... Flash video (FLV) can be played by SWFs without FMS using Progressive Download. You can get an overview here: http://www.adobe.com/devnet/flash/articles/flv_download_03.html btw #2 ... you can get better support on FMS and Flash Video questions posting to the following list: http://www.flashcomguru.com/flashmedialist/ hth, g ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262810 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: stored procedures and mysql
Richard, Although ColdFusion ships with MySQL database drivers, my sense is that these bundled drivers may not support Stored Procs. (Just guessing.) When I go into the ColdFusion Administrator, on the Data Sources page, the Driver dropdown for Add New Data Source has for MySQL MySQL (3.x). Stored procs only became available in MySQL as of version 5.x. So it could be that what has been causing you to be tearing my hair out for weeks is that ColdFusion may be talking to your MySQL 5.x database with a driver that has no (i.e. null) logic for making Stored Proc calls. (Again, I am just guessing here. As a practical matter, however, the most important thing is just to get you configuration working :-) fyi ... drivers intermediate all communication between CF and the database. I.e.: ColdFusion --SQL-- driver -- Database --result set-- driver -- ColdFusion Following are links to two TechNotes on ColdFusion w/ MySQL. They cover going over to MySQL.com and downloading and installing their drivershttp://www.mysql.com/products/connector/j/, product name Connector/J: Aug 1, 2006 ColdFusion MX: Configuring the MySQL JDBC driver (MySQL Connector) http://www.adobe.com/go/tn_19170 March 17, 2006 Configuring a JDBC Driver for MySQL 4.1 or 5 for use with ColdFusion MX http://www.adobe.com/go/6ef0253 If you follow what is outlined in the TechNotes, I believe that your existing ColdFusion MySQL datasource will be uneffected. That is you will be able to add datasources using these new Connector/J drivers alongside your existing datasources. If I am correct in this, once you have the new Connector/J based datasource set up, you existing code will be unaffected. Then for testing you can create an alternate version of your ColdFusion logic referencing the new Connector/J based datasource. Also, I notice on the Connector/J pagehttp://www.mysql.com/products/connector/j/that the 5.x branch is now production ready. If you are going to install a Connector/J driver, I encourage you to first try the 5.x branch. (As I had mentioned, my config is currently at 3.12. The 3.x branch is now up to 3.14. And for Connector/J there is no 4.x branch.) Regarding using Dreamweaver for setting up your datasource connection, it should make no difference. Essentially DW and ColdFusion Administrator provide alternate UIs for updating datasource records. fyi ... I first switched to using the MySQL Connector/J drivers in early 2004 for BLOB support. That is, whatever drivers were then bundled with CF did not support inserting BLOBs. If you do try out using Connector/J drivers, please do post back and let us know if you can get your procs working with ColdFusion with them. hth, g On 12/1/06, Richard White [EMAIL PROTECTED] wrote: hi greg, just noticed that you said you were using a mysql-connector-java-3.1.12. i dont know if it makes any difference but i am using dreamweaver and have setup a mysql connection through it. Queries work fine but not the stored procedures. Do you think it may have something to do with the dreamweaver connection? how did you set up your connection, maybe i can try it that way? I have gone to the cf administrator and it is showing the database as a datasource so assume it has been setup fine though. thanks again greg, appreciate the help On 11/28/06, Richard White [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: stored procedures and mysql
Richard, Glad to be of help. I hope that now you will have a great weekend, happy holidays, etc. (and that your hair will grow back :-) And more than that, I hope that with Scorpio the MySQL drivers bundled with CF will be upgraded. (Anyone from the CF team at Adobe lurking here on this list ? ) btw ... I wore a DBA hat fulltime for several years before coming to CF. This made me very aware of the key role that the driver middleware plays in all SQL to client communication (CF included). I encourage that if others ever encounter problems related to CF and databases (including SQL), if you have access to DBAs, really try to engage your DBA when trying to resolve your problem. And truly, if you have access to DBAs, though you may not need them every day, be sure you make friends with them because there are times that they really can make magic happen for your database driven web applications :-) Happy CF'ing! Best regards, g On 12/1/06, Richard White [EMAIL PROTECTED] wrote: hi greg, you are a diamond :) I changed the driver over to the connector j 5.0 and added a new datasource not with mysql connection but with 'other' and set the configuration manually. I tried it and couldnt believe that it is now working. It does make alot of sense now that we know what it is. Thanks again for your help greg, i really do appreciate it :) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stored procedures and mysql
Richard,
Just to confirm background stuff ...
Is the following enabled:
In ColdFusion Administrator -- Data Sources -- {select data source in
question} -- Advanced Settings -- Allowed SQL -- Stored Procedures
I am running stored procs with no problem with MySQL 5.0.19 with ColdFusion
7.0.2 with mysql-connector-java-3.1.12.
This is the first that I have seen this thread. Sorry.
hth,
g
On 11/28/06, Richard White [EMAIL PROTECTED] wrote:
Hi i posted a problem a while ago as i couldnt get stored procedures
stored in mysql to work, it keeps coming up with a java.lang null pointer
error.
previous thread:
http://www.houseoffusion.comhttp://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365
/groups/CF-Talk/thread.cfmhttp://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365
/threadid:48365http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365
i was wondering if any using mysql and cfstoredproc could provide an
example or to see what i might be doing wrong as i cant work out whats
wrong.
I have granted full rights to my account as well so dont think its this
but dont know why it is coming up with the null pointer. If i run the stored
procedure from mysql it works fine so the stored procedure in the mysql
database is fine.
Thanks for any help, i would really appreciate it as i've been tearing my
hair out for weeks, and i didn't have that much to start with!
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262059
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion and Flex Integration - up to 10x gain, avoid cf object creation
fyi ... Over on FlexCoders, there have been some good posts detailing ColdFusion having poor performance when creating value objects (VOs) using createObject. Several options for getting optimal performance are demonstated. Does anyone else here on cf-talk have experience with this that they could share? Following are links to 3 notable posts on the FlexCoders thread: http://tech.groups.yahoo.com/group/flexcoders/message/55694 http://tech.groups.yahoo.com/group/flexcoders/message/56941 http://tech.groups.yahoo.com/group/flexcoders/message/56942 The thread started when Ron Fuller provided the following runtimes comparing VOs being created using createObject vs. ColdFusion passing an array of structs (and then doing object creation client side with Flex): 200 records As objects: 1180 ms, As structs: 150 ms 2000 recordsAs objects: 10,800 ms, As structs: 460 ms This morning Dirk Eismann provided runtimes using ColdFusion with JavaBeans and delegating object creation to a Java class: 1) cfloop / createObject on a CFC Bean / add this CFC instance to an Array -- is slooow (like 5000ms) 2) cfloop / createObject on a JavaBean (same as Erik mentions) / add this bean to an Array -- is fast! (like 50ms) 3) cloop / delegate object creation to a Java class (instatiated upfront) / Java class returns JavaBean / add bean to Array -- is fastest (like 30ms) hth, g ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and Flex Integration - up to 10x gain, avoid cf object creation
Tom, With HTML UIs, we pretty universally use next-n interfaceshttp://livedocs.macromedia.com/coldfusion/7/htmldocs/1265.htm#wp1133970to address the issue of large data sets being returned to the client. (That is, we initially present a subset of the full data set, and then use subsequent request-responses to send over additional subsets of the data on demand.) So the need to rethink things due to large data sets is only coming up in RIA development like Flash forms, Flex and AJAX. For instance where the data is going into a CFGRID or a Flex DataGrid. A UI element like a DataGrid somewhat mitigates your observation that there is no way a user can cope with 2000 things at once, since all they may be viewing at once are 20 to 50 rows. But then there is the scrollbar. And sort and search filters applied client side. Etc. I am trying to learn what the options are. Have you had call to rethink things on an RIA due to large data sets? If so, what did you do? Clearly Adobe has anticipated this by including paged requestshttp://livedocs.macromedia.com/flex/2/docs/1406.htmlin the DataServicehttp://livedocs.macromedia.com/flex/2/langref/mx/data/DataService.htmlclass of FDS. But I am pretty fuzzy on the whole FDS thing. (I understand that CF 7.0.2 has FDS built in, but that there may be CPU limitations. And that buying separate FDS licenses bumps project costs in $10K or $20K increments (unsure of details).) Should DataGrids just revert back to next-n style interfaces? I have an application that currently is returning 400 records. I have the records going into a DataGrid. Using createObject(), the latency is noticeable and undesirable. I will first be reworking my app to not use createObject() so any advice you can offer would be greatly appreciated :-) And though this is not my case, check out this seemingly crazy case where a developer was using ColdFusion as the back end of an application that shows a ton of graphs where he needed create like 60 objects that will be holding approximately 100,000 datapoints apiece and i need to create those objects dynamically... http://tech.groups.yahoo.com/group/flexcoders/message/27677 Again, my guess is these are GUI specific issues. Still, I want to know that CF has reliable solutions to serve as the backend of choice where these requirements come up :-) Best regards, g On 11/23/06, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 23 November 2006 16:22, greg h wrote: 200 records As objects: 1180 ms, As structs: 150 ms 2000 recordsAs objects: 10,800 ms, As structs: 460 ms I still maintin that if you are even trying to send 2000 of anything down to the client (HTML, WebService or Flex), you need to rethink things - there is no way a user can cope with 2000 things at once, so why send them all at once ? -- Tom Chiverton Helping to enormously engage interactive relationships ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver is a total dog!!
Doug, Admittedly DW is not for everybody. That said, DW code view pretty much is HS w/ code collapse other actually useful goodieshttp://www.adobe.com/products/dreamweaver/productinfo/features/ .. Is there a DW8 feature that you thought might make DW compelling to use from time to time? For instance, last I heard DW has CFC support that HS might not. And then of course there is always CFEclipsehttp://www.cfeclipse.org/ .. btw ... just curious what type of CPU and memory you were running DW8 on? I run DW8 every day on a Pentium 4 3.06GHz w/ 1 GB RAM and never once have I had the type of experience that you just described. Best of luck, g On 11/18/06, Doug Brown [EMAIL PROTECTED] wrote: VENT I just installed DW for the first time, and what a piece of crappola!! I have never seen nothing lag like this thing does. My site has about 245 files and I cannot believe it cannot handle it. Sometimes I think they put too much into these visual design tools. I suppose I will go back to HS+ and be happy once again. I read all the articles on how to improve DW speed, but IMO you should not have to disable features in order to get something to work the way it should. Arg!!! /VENT Doug B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
