iSSPLiSSPL http://blog.inoxh.com Simple Solutions to a Simpler World. Fri, 01 Nov 2013 14:31:46 +0000 https://wordpress.org/?v=4.6 hourly 1 https://wordpress.org/?v=4.6 Adding data in MS SQL from one table to another table http://blog.inoxh.com/adding-data-in-ms-sql-from-one-table-to-another-table/ http://blog.inoxh.com/adding-data-in-ms-sql-from-one-table-to-another-table/#respond Fri, 01 Nov 2013 14:31:46 +0000 Mohammad Ansari http://blog.inoxh.com/?p=294 Posted in MS SQL

INSERT INTO TestTable (FirstName, LastName) SELECT FirstName, LastName FROM Person.Contact WHERE EmailPromotion = 2 for more details please check

Leave a Comment

]]>
Posted in MS SQL

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

for more details please check

Leave a Comment

]]>
http://blog.inoxh.com/adding-data-in-ms-sql-from-one-table-to-another-table/feed/ 0
MS SQL Server Update multiple table http://blog.inoxh.com/ms-sql-server-update-multiple-table/ http://blog.inoxh.com/ms-sql-server-update-multiple-table/#respond Mon, 21 Oct 2013 08:51:11 +0000 Mohammad Ansari http://blog.inoxh.com/?p=291 Posted in MS SQL,programming

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

]]>
Posted in MS SQL,programming

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

]]>
http://blog.inoxh.com/ms-sql-server-update-multiple-table/feed/ 0
How to refresh page after loading http://blog.inoxh.com/how-to-refresh-page-after-loading/ http://blog.inoxh.com/how-to-refresh-page-after-loading/#respond Wed, 14 Aug 2013 07:08:39 +0000 Mohammad Ansari http://blog.inoxh.com/?p=288 Posted in code,Dreamweaver,formatting,html

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=” […]

Leave a Comment

]]>
Posted in code,Dreamweaver,formatting,html

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

]]>
http://blog.inoxh.com/how-to-refresh-page-after-loading/feed/ 0
How to change, switch between two images for anchor tag? http://blog.inoxh.com/how-to-change-switch-between-two-images-for-anchor-tag/ http://blog.inoxh.com/how-to-change-switch-between-two-images-for-anchor-tag/#respond Sat, 27 Jul 2013 06:43:32 +0000 Mohammad Ansari http://blog.inoxh.com/?p=281 Posted in formatting,html,PHP

< 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

]]>
Posted in formatting,html,PHP

< 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

]]>
http://blog.inoxh.com/how-to-change-switch-between-two-images-for-anchor-tag/feed/ 0
How to remove white space in a mysql field? http://blog.inoxh.com/how-to-remove-white-space-in-a-mysql-field/ http://blog.inoxh.com/how-to-remove-white-space-in-a-mysql-field/#respond Tue, 18 Jun 2013 08:34:14 +0000 Mohammad Ansari http://blog.inoxh.com/?p=276 Posted in MySQL

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

]]>
Posted in MySQL

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

]]>
http://blog.inoxh.com/how-to-remove-white-space-in-a-mysql-field/feed/ 0
Set PHP Date Time local to Asia/Calcutta (Indian Standard Time) http://blog.inoxh.com/set-php-date-time-local-to-asiacalcutta-indian-standard-time/ http://blog.inoxh.com/set-php-date-time-local-to-asiacalcutta-indian-standard-time/#respond Tue, 11 Jun 2013 11:29:12 +0000 Mohammad Ansari http://blog.inoxh.com/?p=273 Posted in PHP,programming

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

Leave a Comment

]]>
Posted in PHP,programming

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

Leave a Comment

]]>
http://blog.inoxh.com/set-php-date-time-local-to-asiacalcutta-indian-standard-time/feed/ 0
How to read CSV (Comma Separated Files) line by line in PHP? http://blog.inoxh.com/how-to-read-csv-comma-separated-files-line-by-line-in-php/ http://blog.inoxh.com/how-to-read-csv-comma-separated-files-line-by-line-in-php/#respond Mon, 27 May 2013 05:16:57 +0000 Mohammad Ansari http://blog.inoxh.com/?p=269 Posted in PHP,programming

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

]]>
Posted in PHP,programming

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

]]>
http://blog.inoxh.com/how-to-read-csv-comma-separated-files-line-by-line-in-php/feed/ 0
How to remove part of string after certain character in php? http://blog.inoxh.com/how-to-remove-part-of-string-after-certain-character-in-php/ http://blog.inoxh.com/how-to-remove-part-of-string-after-certain-character-in-php/#respond Tue, 21 May 2013 07:51:41 +0000 Mohammad Ansari http://blog.inoxh.com/?p=266 Posted in PHP,programming

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

Leave a Comment

]]>
Posted in PHP,programming

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

Leave a Comment

]]>
http://blog.inoxh.com/how-to-remove-part-of-string-after-certain-character-in-php/feed/ 0
How to get/pass Parameter from URL to Adobe Flash swf? http://blog.inoxh.com/how-to-getpass-parameter-from-url-to-adobe-flash-swf/ http://blog.inoxh.com/how-to-getpass-parameter-from-url-to-adobe-flash-swf/#respond Sat, 18 May 2013 10:14:00 +0000 Mohammad Ansari http://blog.inoxh.com/?p=244 Posted in PHP,programming

Passing Parameters from URL in PHP ‘FlashVars’, ‘one=&two=‘, one=

Leave a Comment

]]>
Posted in PHP,programming

Passing Parameters from URL in PHP

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

one=

Leave a Comment

]]>
http://blog.inoxh.com/how-to-getpass-parameter-from-url-to-adobe-flash-swf/feed/ 0
How to auto format/reformat css, html using Dreamweaver? http://blog.inoxh.com/how-to-auto-formatreformat-css-html-using-dreamweaver/ http://blog.inoxh.com/how-to-auto-formatreformat-css-html-using-dreamweaver/#respond Thu, 16 May 2013 05:44:12 +0000 Mohammad Ansari http://blog.inoxh.com/?p=242 Posted in 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 […]

Leave a Comment

]]>
Posted in 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

]]>
http://blog.inoxh.com/how-to-auto-formatreformat-css-html-using-dreamweaver/feed/ 0