1 0
post icon

Adding data in MS SQL from one table to another table

INSERT INTO TestTable (FirstName, LastName)
SELECT FirstName, LastName
FROM Person.Contact
WHERE EmailPromotion = 2

for more details please check

Leave a Comment
November 1, 2013
post icon

MS SQL Server Update multiple table

Table A will be updated with data from Table B

UPDATE A
    SET A.NAME = B.NAME
FROM TableNameA A, TableNameB B
WHERE A.ID = B.ID
Leave a Comment
post icon

How to refresh page after loading

While making a mobile friendly page i need to readjust the page to make it center align. As with load of the page it was not being centered, when user click double click on the page, it get’s align centered. so we implemented auto refresh which do exactly what we after…

JavaScript

< script language=” JavaScript” >
< !– function LoadOnce() { window.location.reload(); } //– >
< /script>

Call this function on body tag

< body onLoad=” LoadOnce()” >

Leave a Comment
post icon

How to change, switch between two images for anchor tag?

< a href="index.php">

< img src="images/home-grey.png" onmouseover="this.src='images/home-white.png'" onmouseout="this.src='images/home-grey.png'" />

< div class="big-text">Home< /div>

< /a>

Leave a Comment
post icon

How to remove white space in a mysql field?

Execute SQL Command

UPDATE Country set State_Name = TRIM(State_Name);

Where State_Name in function TRIM hold values with spaces, and TRIM Function removes any white spaces and update the field in same table.

Leave a Comment
post icon

Set PHP Date Time local to Asia/Calcutta (Indian Standard Time)

$timezone = “Asia/Calcutta”;
date_default_timezone_set($timezone);
$date = date(‘Y-m-d’);
$time = date(‘H:i:s’);

Leave a Comment
post icon

How to read CSV (Comma Separated Files) line by line in PHP?

CSV is plain text file, which means you can open it notepad or anyother text editor.
CSV file stores tabular data (numbers and text) in plain-text form.

$file_handle = fopen(“csv_file_name.csv”, “r”);

while (!feof($file_handle) ) {

$line_of_text = fgetcsv($file_handle, 1024);

print $line_of_text[0] . $line_of_text[1]. $line_of_text[2] . “
“;

}

fclose($file_handle);

Leave a Comment
post icon

How to remove part of string after certain character in php?

$title = array_shift(explode(‘_’, $title));
where $title is string having complete text including ‘_’ , so it will remove any thing after ‘_’ including ‘_’.

Leave a Comment
post icon

How to get/pass Parameter from URL to Adobe Flash swf?

Passing Parameters from URL in PHP

‘FlashVars’, ‘one=&two=‘,

one=

Leave a Comment
post icon

How to auto format/reformat css, html using Dreamweaver?

Does your code page look like unorganized, messy lines of code?
Use the Apply Source Formatting feature and reformat it exactly to your preferences.
To quickly clean them up, click the Format Source Code icon at the bottom of the Coding toolbar (Edit > Toolbars > Coding) and select Code Format Settings to set your preferred formatting.

You can also access the formatting option from Commands > Apply Source Formatting or only apply it to a select block of code by selecting the Apply Source Formatting to Selection option.

Can by applied to all type of files DW can work with.

Leave a Comment