Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

HTML5 Mobile Web Application - Heads up tip on "non-NULLS"

I was showing someone the new html5 app yesterday on my Droid X and telling him it was connected to my live SalesLogix system (not a demo site). Of course Murphy's Law jumped right in front of me and it threw up an error dialog immediately when attempting to open up the first lead on the screen:

    "A server error occurred while requesting data"

 

I clicked OK,  then on the back arrow and all was fine. To see if this was a system or data issue, an attempt was made to open the 2nd lead in the list.. it opened fine. Going back to the first.. failed.. again..

 

This am using (Firefox/Firebug), the problem was was traced to the LEAD.LEADSOURCEID containing a "blank" in the LEAD record(s) which were throwing errors (yep.. found about twenty of them). A SImple SQL update statement via ExecuteSQL (in the Admin app) resolved the issue immediately:

    UPDATE LEAD SET LEADSOURCEID = NULL WHERE LEADSOURCEID = ''

 

This was just one example where "trashy data" can cause you to not obtain desired results.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html