Software / Technology Tips

==================================================================== function myModule_personal_detail_form($form, &$form_state) { $form = array(); $form = array( '#type' => 'textfield', ); $form = array( '#type' => 'textfield', ); $form = array( '#type' => 'textfield', '#maxlength' => 3, ); // Get the path to the module $path = drupal_get_path('module', 'myModule'); // Attach the CSS and JS to the form $form = array(…

— Create Employee Table Create Table EMPLOYEE( ID int,EmpID int,EmpName varchar(50)) — Insert Sample data to the Employee table INSERT INTO EMPLOYEE VALUES ( 1, 1, ‘Aasish’) INSERT INTO EMPLOYEE VALUES ( 2, 1, ‘Anita’); INSERT INTO EMPLOYEE VALUES ( 3, 1, ‘Kabita’); INSERT INTO EMPLOYEE VALUES ( 4, 2, ‘Raj’); INSERT INTO EMPLOYEE VALUES…

How do we Insert,Delete,Update from Kentico webproject by using a webpart? In Kentico CMS we have a database with number of tables to support the CMS system, still some times we want to add a custom table for some requirement.So we need to add/edit/update that table though the KenticoCMS. To do the CRUD operation on…

C# does not support pointer arithmetic by default to have type safety and security. If we want to use pointers in C# we need to use the keyword unsafe. We can have pointer types, value types and reference types in an unsafe context. When we declare multiple pointers in a single declaration, the * is…

Steps: 1- Register the webservice in CF admin using any method (whether by manual creation in cf admin or by creating an object) 2- After the wsdl is registered, it will create one folder with a random name, for example ‘WS2002874483‘ under “ColdFusion9/stubs/” directory. This will contain all class files referenced in the wsdl. 3- You need to…

Caching has been used for years to improve performance of applications. So it is very much important to control caching properly to get highest possible benefit out of it. Please find the method below to manage query caching properly. First I will demonstrate the logic and then follow it up with code. The problem with…

Using Zend_Db Adapter method we use the following approach to connect database and execute SQL statement. //Connect to database $db = Zend_Db::factory(‘DB_ADAPTER_TYPE’, array( ‘host’ => ‘127.0.0.1’, ‘username’ => ‘webuser’, ‘password’ => ‘xxxxxxxx’, ‘dbname’ => ‘test’, ‘adapterNamespace’ => ‘MyProject_Db_Adapter’ )); //To execute the query $db->query($sqlquery); But in the above method, when the query length exceeds 4000…

By Default, a nonclustered index gets created if keyword ‘clustered’ is not specified. Here in the above example, we have created a nonclustered index ‘IX_Employee_EmpID’ on EmpID column of  Employee table. Nonclustered index also gets created – When we create a PRIMARY KEY on a table where a clustered index has already been defined. If…

Here I am assuming 1- Many relationship between Department and Employee table(i.e. A department has many employee and a single employee can work only in a single department). Part – 1 : Generate XML type from Database tables Suppose I need to generate a xml type for a partcular department(Here I want to generate for…

The Usage guide : Command: picframe infile outfile -f frameid : is the id number of the picture frame. Basically for this framing to work, you need to follow a certain convention. For adding a custom frame, you need to cut out a square section from the lower right corner of a picture frame, whose…