tag:blogger.com,1999:blog-9166901467995726431.post7921010762582623488..comments2024-03-17T22:56:17.550-07:00Comments on Liferay is easy: Custom Sql With Two TableAdityahttp://www.blogger.com/profile/06877429720075168788noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-9166901467995726431.post-69346061255094622652015-06-26T04:36:04.525-07:002015-06-26T04:36:04.525-07:00String string manipulationString string manipulationAnonymoushttps://www.blogger.com/profile/05237729658365703343noreply@blogger.comtag:blogger.com,1999:blog-9166901467995726431.post-21737710048940790612015-06-26T02:48:06.035-07:002015-06-26T02:48:06.035-07:00Good what approach you are following?Good what approach you are following?Adityahttps://www.blogger.com/profile/06877429720075168788noreply@blogger.comtag:blogger.com,1999:blog-9166901467995726431.post-17915446854679795182015-06-26T01:48:26.721-07:002015-06-26T01:48:26.721-07:00Thanku Sir, DoneThanku Sir, DoneAnonymoushttps://www.blogger.com/profile/05237729658365703343noreply@blogger.comtag:blogger.com,1999:blog-9166901467995726431.post-74989982301513812822015-06-25T03:01:01.532-07:002015-06-25T03:01:01.532-07:00Hi Tahir,
Yes you can but better approach is that...Hi Tahir,<br /><br />Yes you can but better approach is that you can create a String that contain the query with parameter apply string manipulation to create the complete query and then directly pass this.<br />And not use <br />pos.add()<br /> Adityahttps://www.blogger.com/profile/06877429720075168788noreply@blogger.comtag:blogger.com,1999:blog-9166901467995726431.post-91521045849312001052015-06-25T01:17:20.570-07:002015-06-25T01:17:20.570-07:00Can we pass String array as Positional Param in ab...Can we pass String array as Positional Param in above example.<br />>-----------------WHERE addr.country = ?");<br />QueryPos pos = QueryPos.getInstance(query);<br />pos.add(countryName);<br />countyName is String Array<br />There are two methods available add(String[] var) n add(String[] var,int count)Anonymoushttps://www.blogger.com/profile/05237729658365703343noreply@blogger.com