SQL formatting using API giving wrong results

[PriyaNath007]

In the web interface (http://www.dpriver.com/pp/sqlformat.htm) when I pass db as mssql and format as sql: html text then the results that i get while i do copy to clipboard contains proper "<BR>" and "&nbsp;" tags but while i am doing the same with API call I am just getting"\n" in place of space

Can u get the same results as the web interface?? Please let me know.

Note: I tried various combinations by passing db format and vendor but always got the same results

[PriyaNath007]

@sqlparser @cnfree

[PriyaNath007]

@lukaseder

[cnfree]

@PriyaNath007

Please set the outputfmt property as SQL, but not html

html outputfmt will output the html tags.

[PriyaNath007]

@cnfree @sqlparser Hi Chen Chao,

Thanks a lot for your reply. I think there is an issue with the API parser and also inline parser link(http://www.gudusoft.com/link.html). When trying with query which contains UNION ALL Select statements without any braces it's not able to give the output, but at the same time the same query is working on the Web Interface((http://www.dpriver.com/pp/sqlformat.htm))

Ex query:- Select * from abc UNION ALL Select * from bcd