Enable CLOB in DataSource in ColdFusion administrator / [Macromedia][SQLServer JDBC Driver][SQLServer]XML parsing: line 1, character 64000, equal expected

ERROR:   Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]XML parsing: line 1, character 64000, equal expected  

CASE:  we get this error when we try to retrieve long text/characters from database in cfquery.   Default configuration for Long Text Buffer (chr) is 64,000. when you expect result more than 64,000 characters in CFQUERY then we need to enable  "Enable long text retrieval (CLOB)". 

see below image for reference

upgrading jquery to 1.8.0/upgrading jquery to latest version

its very easy to upgrade to latest version of jquery.  we need to take care of very few things.


1. If you are using "checked" property like below then you need to change code like below. the reason its not returning as true/false anymore.

old code:  

    if ($('#testCheckbox').attr('checked')== true && 

your new code need to be like this: 
    $('#testCheckbox').is(':checked')


2. if you have any code like below then change as per new code

old code: 
    var cType = $("select:cType").val();    

New Code
    var cType = $("#cType").val();

3. if you using validation plugin then old version of validation plugin will not be supported any more with new jquery so you have to upgrade your validation plugin also. Upgrade validation plugin to 1.9.0

http://bassistance.de/jquery-plugins/jquery-plugin-validation/

4.  upgrade your old plugins, 
    jquery.form.js -- upgrade to new version of this plugin. 

social change without society

is it possible to have social change without society? No.

is it possible to ask questions without knowledge? No

is it possible to change someone without changing yourself ? No