Sage SalesLogix
  • Contact Us
  • Sage North America
800-643-6400
Welcome Twitter Facebook LinkedIn
Community Home Blogs Share Ideas Search Request Access Resources
Reply
Gold Super Contributor
RJLedger
Posts: 2,234
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

".. Stay Focused..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Please use plain text.