<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11">

Good day,

 

I am an independent consultant and eighteen year veteran of the technology industry.  My specialty is helping companies figure out how to become more successful utilizing CRM best practices and salesforce.com.  

 

I have experience in the following areas:

* Process definition and refinement in the areas of Sales, Marketing, Customer Service, Support

* Customize objects, fields, page layouts, etc.

* Import, export, clean, de-duplication, and verify
* Create and customize reports and dashboards

* Integrate external applications

* Build applications on the Force.com platform for internal use or to list on the App Exchange

* General System administration 

 

Please reply to michaelmt44@yahoo.com with your contact information and a short description of your problem/goal and I will respond promptly.

 

Thank you,

Michael

Good afternoon,

I am querying the case object and I receive the following error from Flex.  In addition, even though there is an error the query still executes successfully (still returns the correct data).

SQLError: 'Error #3115: SQL Error.', details:'near "Case": syntax error', operation:'execute'
    at flash.data::SQLStatement/internalExecute()
    at flash.data::SQLStatement/execute()
    at <anonymous>()[/home/jamesw/projects/mavericks/sdkair/src/com/salesforce/AIRConnection.as:1197]
    at com.salesforce::AsyncResponder/result()[/home/jamesw/projects/mavericks/sdk/src/com/salesforce/AsyncResponder.as:90]
    at <anonymous>()[/home/jamesw/projects/mavericks/sdkair/src/com/salesforce/AIRConnection.as:459]
    at com.salesforce::AsyncResponder/result()[/home/jamesw/projects/mavericks/sdk/src/com/salesforce/AsyncResponder.as:90]
    at SalesForceResponder/result()[/home/jamesw/projects/mavericks/sdk/src/com/salesforce/Connection.as:1303]
    at mx.rpc::AsyncToken/http://www.adobe.com/2006/flex/mx/internal::applyResult()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AsyncToken.as:197]
    at mx.rpc.events::ResultEvent/http://www.adobe.com/2006/flex/mx/internal::callTokenResponders()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\events\ResultEvent.as:159]
    at mx.rpc::AbstractInvoker/http://www.adobe.com/2006/flex/mx/internal::dispatchRpcEvent()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AbstractInvoker.as:165]
    at mx.rpc::AbstractInvoker/http://www.adobe.com/2006/flex/mx/internal::resultHandler()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AbstractInvoker.as:191]
    at mx.rpc::Responder/result()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\Responder.as:41]
    at mx.rpc::AsyncRequest/acknowledge()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AsyncRequest.as:74]
    at DirectHTTPMessageResponder/completeHandler()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\messaging\channels\DirectHTTPChannel.as:381]
    at flash.events::EventDispatcher/dispatchEventFunction()
    at flash.events::EventDispatcher/dispatchEvent()
    at flash.net::URLLoader/onComplete()


Here's the code that is causing the error:

            var queryString:String = "Select Id, Subject, CaseNumber, LastModifiedDate, CreatedDate From Case where Case.isClosed = false and ContactId='" + p_contactId + "'";
                               
            Global.sforceConnection.query(queryString, new AsyncResponder( function (queryResult:QueryResult):void {
                    var caseData:ArrayCollection = new ArrayCollection;
           
                })
            );


Have any ideas?

Thank you,
Michael

Contact me privately ASAP, if you can dedicate roughly 40hrs/wk for the next 4-6 weeks. Preference given to those in the Bay Area, but not necessarily required.

We need 1 salesforce.com implementation consultant who can work on site any where in the U.S.A.
Must have great communication skills as this is a customer facing role.
Should have atleast 1 SFDC implemenation under their belt.

Start date 27th of Oct or earlier.