Posts

Controller, Helper and Renderer in Salesforce Lightning and writing multiple javascript functions

Image
Controller,  Helper and Renderer - Relationship The new Salesforce Lightning  provides latest and rich UI experience to the Salesforce application using Components, JavaScript, HTML and CSS (Responsive design) on   Lightning Component framework  (a framework built on  aura framework) . Custom components would be developed and could be used in multiple areas as needed.  JavaScript plays an important role in Lightning Component framework and inside component bundle, it is separated in to Controller, Helper and Renderer.  Have you ever wonder, why these are separated? To know about this, one must know about each section and its role inside the component. Controller:  This section should contain only the JavaScript functions for listening to the different events (User events as well as Control events) that is being fired inside the component. The execution part or the business logic part should be de...
Post a Comment
Read more

How to get Dynamic SQL Select query to an table variable?

It is very often easy to manage complex search, paging and sorting using dynamic SQL feature provided in SQL Server 2008. Very often when you are executing a dynamic query, there would be situations where we may need to manupulate the result of the dynamic SQL. SQL Server provides a mechanisam to do this for a dymanic SQL which performs a SELECT operation through the following syntax: INSERT INTO @table_variable EXECUTE (query) For example, for getting the second page after applying the condition, the query could be written as follows: DECLARE @PageSize int = 1000 DECLARE @table TABLE ( rowId int IDENTITY ( 1 , 1 ), id int , value varchar ( 500 )) DECLARE @condition nvarchar ( max ), @Query nvarchar ( max ) set @condition = N' where id > 1000 order by id' SET @query = 'SELECT TOP ' + cast ( @PageSize as varchar ) + ' Id, Name FROM Customer ' + @condition INSERT INTO @table ( id , value ) EXECUTE ( @query ) SELECT ...
Post a Comment
Read more