anchor.diff:  component extends = "org.lucee.cfml.test.LuceeTestCase"{
   
   	function beforeAll() {
  -		variables.uri = createURI("LDEV2586");
  -
   		variables.msSQL = server.getDatasource("mssql");
   		if( structCount(msSQL) ) {
   			// define datasource
  -			application action="update" 
  -				datasource = {
  -					'LDEV2586': msSQL
  -				};
  +			application action="update"  datasource=msSQL;
   
   			// create necessary tables
  -			query datasource="LDEV2586" {
  +			query  {
   				echo("DROP TABLE IF EXISTS LDEV2586");
   			}
  -			query datasource="LDEV2586"{
  +			query {
   				echo("CREATE TABLE LDEV2586( id int, value decimal )");
   			}
  -			query datasource="LDEV2586"{
  -				echo("INSERT INTO LDEV2586 VALUES( 1,'1000' )");
  -				echo("INSERT INTO LDEV2586 VALUES( 2,'23.45' )");
  +			query {
  +				echo("INSERT INTO LDEV2586 VALUES( 1, '1000' )");
  +				echo("INSERT INTO LDEV2586 VALUES( 2, '23.45' )");
   			}
   		}
   	}
   
   	public function afterAll(){
   		if(hasCredencials()) {
  -			query datasource="LDEV2586"{
  +			query {
   				echo("DROP TABLE IF EXISTS LDEV2586");
   			}
   		}
  
positive.code: 		describe( "Test case for LDEV-2586", function() {
  			
  			it(title = " cfqueryparam does handle decimal value = 1000 with maxLength = 8 ",skip=!hasCredencials(), body = function( currentSpec ) {
  				query name="local.test" datasource="LDEV2586" {
  					echo("SELECT * FROM LDEV2586");
  				}
  				query name="local.subUsers" datasource="LDEV2586" {
  				   echo("SELECT * FROM LDEV2586 WHERE value = ");
  				   queryparam value='#test.value[1]#' cfsqltype="CF_SQL_DECIMAL" maxlength="8";
  				}
  
negative.code: 			});
  
  			it(title = " cfqueryparam doesn't handle deciaml value = 1000 with maxLength = 7",skip=!hasCredencials(), body = function( currentSpec ) {
  				query name="local.test"  {
  					echo("SELECT * FROM LDEV2586");
  				}
  				query name="local.subUsers"  {
  				   echo("SELECT * FROM LDEV2586 WHERE value = ");
  				   queryparam value='#test.value[1]#' cfsqltype="CF_SQL_DECIMAL" maxlength="7";
  				}
  