SalesForceCFC has been stable, but there is always room for improvement. This version includes a few tweaks and clean up.

Download the code @ RIAForge

I would also like to put out a 'Call for Features' to put on the roadmap for 1.0

Some already suggested:
-support for SOQL sub/nested queries
-asynchronous HTTP calls

Please post your suggestions on the Forums @ RIAForge or just leave a comment here.

In addition, I will be including a base unit test collection to provide stability for future releases and customization. Along with improved documentation and code samples.

I'd like to thank Daniel Llewellyn and Pete Freitag for their contributions, as well.

0.7 -CHANGE LOG- 1/24/2009
- enhancement - added support for batch save
- enhancement - added support for AssignmentHeader
- enhancement - added support for EmailHeader
- enhancement - added result size to query return data
- enhancement - updated typing and case of component
- enhancement - increased default SOAP timeout
- deprecated - unnecessary setters (setServerURL,setSessionId,setLastLogin)

I apologize. I left out the test page and sample code from the latest release.

I've updated the project to include the Application.cfc, which is required for testing the security token persistence using the session scope. Along with the testForm.cfm, which has all the example code, and demo.

SalesForceCFC @ RIAforge

This is a much improved release. It brings the object's architecture up to date, improves performance, and offers a few new features.

0.6 -CHANGE LOG- 2/22/2009 - enhancement - auto login
- enhancement - upgraded constructor
- enhancement - more getters and setters
- enhancement - last login added to instance
- enhancement - added utility calls getUserInfo and getServerTimeStamp
- enhancement - upgraded soap handling to minimize code
- enhancement - session handling added to test form to demo persistance
- deprecated - username and password parameters have been removed from login
- deprecated - objDataStruct on return from describeObject()
- fix - validate method getServerURL missing parenthesis
- fix - test form updated to avoid crossover and better cleanup

Download a copy at SalesForceCFC on RIAForge

It was brought to my attention, that you can not return more then 2000 records at a time using the query() method in the SalesForce API.

This is done to throttle performance and overhead when using the API. SF does make the data available, but it requires a few more steps.

I've integrated these steps and added the queryMore() method to salesForceCFC.

Along the way, queryObject() was updated to now accept a 'batchSize' argument. You can now specify the maximum number of records to return when doing a query. Similar to doing a SELECT TOP in MS SQL, or a LIMIT in regular SQL.

If there are more records then the batchSize you send in, then you will see a QUERYLOCATOR key in the return struct. It's a reference to your query on the SF server. It will remain available until there is 15 minutes of inactivity on it.

The 'queryLocator' gets passed in to the queryMore() method instead of passing in the queryString like you do in queryObject(). The option to 'includeRelatedObject' is still available with queryMore(), as is 'batchSize', and 'startRow'. One thing to note, is that SF will always return at least 200 records. So your batchSize should never be less then that.

With the new updates to this release, you now have the power to paginate any size query using the SalesForce API.

Download a copy at SalesForceCFC on RIAForge

A few updates were made in the 0.4 release available at:

salesForceCFC @ riaForge

A major and a minor fix have been implemented. The major being the lack of xmlFormat() in earlier releases. This would prevent characters like '<' to be passed as part of a queryString when using the queryObject() method.

There is now methods to manipulate the timeout value for SOAP requests and a getMemento() method that will return all values stored with the instance.

I am on the fence over the throwonerror setting, and looking for some feedback.

Version 0.3 now supports SalesForce's query language, SOQL's, relational queries. Which is their syntax for SQL JOINs. salesForceCFC now has the fields prefixed and built in to the resultset. With an option to include a struct of the entire object with each row.

For more on that, with this release comes the launch of the salesForceCFC demo site.

You'll need a SF account if you don't already have one. Developer account's are free and available at developer.salesforce.com.

v0.3 Change Log & Notes

Download Latest Release of salesForce CFC @ RIAforge.org

I appreciate the positive feedback and suggestions I have received on the initial release of salesForceCFC. So I took the time to put together some stuff that will help implement it.

The latest package includes a landing page, for testing and a link to the cfcdocs.

The test form, will run thru the basic creation of the object, login, and test each method. It is intended to be used as a diagnostic. I added a validate() method, as well. It checks the objects state and looks for an active secure session before trying to send any SOAP requests. The return structs will provide full error information and help you track down the cause quickly.

To download check out the project salesForceCFC at RIAForge

For the latest changes, instructions, and usage notes check out the readme.txt, now included with the package.