{"id":5386814,"date":"2014-10-14T06:32:09","date_gmt":"2014-10-14T06:32:09","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/shortcode-sql\/"},"modified":"2016-08-22T03:25:54","modified_gmt":"2016-08-22T03:25:54","slug":"shortcode-sql","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/shortcode-sql\/","title":{"rendered":"Shortcode SQL="&""},"content":{"rendered":"

Dear Sir,
\nI m facing a problem while using the abase shortcode sql.<\/p>\n

If I includes ‘&’ character inside the shortcode, it will not work.<\/p>\n

Example:
\n[abase sql=”select name, team,msc,technology,rate from v_emp_skills where LOB=’C&TIS’ and rate <> ‘N\/A’ order by rate desc”]<\/p>\n

As you can see the LOB condition value ‘C&TIS’, it includes ‘&’ Character, so it doesn’t bring any records.<\/p>\n

Please advice.<\/p>\n

https:\/\/wordpress.org\/plugins\/abase\/<\/p>\n","protected":false},"template":"","class_list":["post-5386814","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5386814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5386814\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5386814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}