Topic
  • 1 reply
  • Latest Post - ‏2012-05-01T10:13:14Z by IdanAdar
SystemAdmin
SystemAdmin
570 Posts

Pinned topic Not able to use transformation in SQL Adapter

‏2012-04-30T19:39:10Z |
Hi,
When I try to use the *transformation *parameter in my SQL Procedures' input, I see the following warning in the console


15:36:46,618 WARN  [SQLQuery] The parameter transformation is not known and will be ignored.


But in the documentation, this information is mentioned.Below is the procedure that I'm using.


var userListListQuery = WL.Server .createSQLStatement(
"Select * from User_Table"); function getUserList() 
{ var input=
{ preparedStatement : userListListQuery , parameters : [], transformation : 
{ type : 
'xslFile', xslFile : 
'UserListFilter.xsl' 
} 
}; 

return WL.Server.invokeSQLStatement(input); 
}


Am I doing this in the correct way? Can you please let me know?
  • IdanAdar
    IdanAdar
    288 Posts

    Re: Not able to use transformation in SQL Adapter

    ‏2012-05-01T10:13:14Z  
    This is because in SQL the result you get is not in XML, thus you cannot transform it.