Utkarsh Dixit

UPPER: Translates all characters within the string to upper case

Utkarsh Dixit — Sat, 05 Nov 2011 16:16:50 +0000

1> -- UPPER: Translates all characters within the string to upper case. 2> 3> DECLARE @UPPER_STRING char(100) 4> SET @UPPER_STRING = "www.Java2s.com" 5> 6> SELECT UPPER(@UPPER_STRING) 7> GO




-------------------------------------------------------------------------

WWW.JAVA2S.COM

(1 rows affected) 1>

Ref : http://www.java2s.com/Code/SQLServer/String-Functions/UPPERTranslatesallcharacterswithinthestringtouppercase.htm

Combine Lower() Upper() and substring() function to capital the first letter in a word

Utkarsh Dixit — Sat, 05 Nov 2011 16:12:28 +0000

1> 2> -- LOWER() and UPPER() Functions 3> DECLARE @LastName VarChar(25), @SpaceIndex TinyInt 4> SET @LastName = 'mc donald' 5> 6> -- Find space in name: 7> SET @SpaceIndex = CHARINDEX(' ', @LastName) 8> IF @SpaceIndex > 0 -- Space: Capitalize first & substring 9> SELECT UPPER(LEFT(@LastName, 1)) 10> + LOWER(SUBSTRING(@LastName, 2, @SpaceIndex - 1)) 11> + UPPER(SUBSTRING(@LastName, @SpaceIndex + 1, 1)) 12> + LOWER(SUBSTRING(@LastName, @SpaceIndex + 2, LEN(@LastName))) 13> ELSE -- No space: Cap only first char. 14> SELECT UPPER(LEFT(@LastName, 1)) 15> + LOWER(SUBSTRING(@LastName, 2, LEN(@LastName))) 16> 17> GO


----------------------------------------------------

Mc Donald

(1 rows affected) 1>

UPPER: change string to upper case

Utkarsh Dixit — Sat, 05 Nov 2011 16:09:22 +0000

1> create table employee( 2> ID int, 3> name nvarchar (10), 4> salary int, 5> start_date datetime, 6> city nvarchar (10), 7> region char (1)) 8> GO 1> 2> insert into employee (ID, name, salary, start_date, city, region) 3> values (1, 'Jason', 40420, '02/01/94', 'New York', 'W') 4> GO


(1 rows affected)

1> insert into employee (ID, name,    salary, start_date, city,       region)

2>               values (2,  'Robert',14420,  '01/02/95', 'Vancouver','N')

3> GO
(1 rows affected)

1> insert into employee (ID, name,    salary, start_date, city,       region)

2>               values (3,  'Celia', 24020,  '12/03/96', 'Toronto',  'W')

3> GO
(1 rows affected)

1> insert into employee (ID, name,    salary, start_date, city,       region)

2>               values (4,  'Linda', 40620,  '11/04/97', 'New York', 'N')

3> GO
(1 rows affected)

1> insert into employee (ID, name,    salary, start_date, city,       region)

2>               values (5,  'David', 80026,  '10/05/98', 'Vancouver','W')

3> GO
(1 rows affected)

1> insert into employee (ID, name,    salary, start_date, city,       region)

2>               values (6,  'James', 70060,  '09/06/99', 'Toronto',  'N')

3> GO
(1 rows affected)

1> insert into employee (ID, name,    salary, start_date, city,       region)

2>               values (7,  'Alison',90620,  '08/07/00', 'New York', 'W')

3> GO
(1 rows affected)

1> insert into employee (ID, name,    salary, start_date, city,       region)

2>               values (8,  'Chris', 26020,  '07/08/01', 'Vancouver','N')

3> GO
(1 rows affected)

1> insert into employee (ID, name,    salary, start_date, city,       region)

2>               values (9,  'Mary',  60020,  '06/09/02', 'Toronto',  'W')

3> GO
(1 rows affected)

1>

2> select * from employee

3> GO



ID          name       salary      start_date              city       region



----------- ---------- ----------- ----------------------- ---------- ------

          1 Jason            40420 1994-02-01 00:00:00.000 New York   W

          2 Robert           14420 1995-01-02 00:00:00.000 Vancouver  N

          3 Celia            24020 1996-12-03 00:00:00.000 Toronto    W

          4 Linda            40620 1997-11-04 00:00:00.000 New York   N

          5 David            80026 1998-10-05 00:00:00.000 Vancouver  W

          6 James            70060 1999-09-06 00:00:00.000 Toronto    N

          7 Alison           90620 2000-08-07 00:00:00.000 New York   W

          8 Chris            26020 2001-07-08 00:00:00.000 Vancouver  N

          9 Mary             60020 2002-06-09 00:00:00.000 Toronto    W
(9 rows affected)

1>

2>

3> SELECT RTRIM(Name) + " " + RTRIM(City) As Employee_Name_City

4> FROM Employee

5> WHERE UPPER(Name) LIKE "%Y"

6> GO

Employee_Name_City

---------------------

Mary Toronto

(1 rows affected) 1> 2> drop table employee 3> GO 1>

Using JavaScript and forms

Utkarsh Dixit — Wed, 02 Nov 2011 06:35:51 +0000

Ref1 : Using JavaScript and forms

Ref2 : Get form element infomation

Ref3 : How to get the value of a form element using JavaScript

Model View Controller(MVC) in PHP

Utkarsh Dixit — Mon, 31 Oct 2011 18:00:17 +0000

The model view controller pattern is the most used pattern for today’s world web applications. It has been used for the first time in Smalltalk and then adopted and popularized by Java. At present there are more than a dozen PHP web frameworks based on MVC pattern.

Despite the fact that the MVC pattern is very popular in PHP, is hard to find a proper tutorial accompanied by a simple source code example. That is the purpose of this tutorial.

The MVC pattern separates an application in 3 modules: Model, View and Controller:

•The model is responsible to manage the data; it stores and retrieves entities used by an application, usually from a database, and contains the logic implemented by the application.
•The view (presentation) is responsible to display the data provided by the model in a specific format. It has a similar usage with the template modules present in some popular web applications, like wordpress, joomla, …
•The controller handles the model and view layers to work together. The controller receives a request from the client, invoke the model to perform the requested operations and send the data to the View. The view format the data to be presented to the user, in a web application as an html output.
The above figure contains the MVC Collaboration Diagram, where the links and dependencies between figures can be observed

mvc-collaboration

Our short php example has a simple structure, putting each MVC module in one folder:

mvc-structure

Ref : http://php-html.net/tutorials/model-view-controller-in-php/

XAMPP for Windows

Utkarsh Dixit — Mon, 31 Oct 2011 16:13:24 +0000

Ref : XAMPP for Windows 1.7.7

Configuring PHP Development Environment in Windows

Utkarsh Dixit — Mon, 31 Oct 2011 16:07:31 +0000

Configuring PHP Development Environment in Windows
This tutorial shows you two ways of configuring your PHP development environment on the Windows operating system. The first and most convenient way is to install and configure an AMP (Apache, MySQL, PHP) package. This tutorial shows you how to install the XAMPP package. The second way is to install and configure each component separately.

read more

INSTALLING, CONFIGURING, AND DEVELOPING WITH XAMPP

Utkarsh Dixit — Mon, 31 Oct 2011 16:03:17 +0000

http://dalibor.dvorski.net/downloads/docs/InstallingConfiguringDevelopingWithXAMPP.pdf

XAMPP – Apache, PHP, MySQL

Utkarsh Dixit — Mon, 31 Oct 2011 15:54:57 +0000

XAMPP – Make your Computer a Webserver: Apache, PHP, MySQL

Ref : http://www.youtube.com/watch?v=KWRB-maTVyM

Nitobi

Utkarsh Dixit — Mon, 31 Oct 2011 10:48:51 +0000

We’ve been developing Ajax applications since before the name was coined, and writing JavaScript since before it was cool.We have completed JavaScript development for companies from Nike to NASA.

Plus, we wrote the book on Ajax. Literally. In 2007 Nitobi senior staff wrote “Enterprise Ajax” published by Prentice Hall.

Whether you’re building a new app from the ground up, Ajax-enabling an old app or customizing Ajax-powered components, we can help you:

Choose an Ajax Framework
Implement and optimize your DHTML and JavaScript
Debug your code for all modern browsers
Integrate your JavaScript with other RIA technologies like Flash and Flex
A proud member of the Open Ajax Alliance and a frequent presenter at the Ajax Experience and AjaxWorld, we’re committed to building interoperable Ajax solutions across all operating systems and browsers.

Check out the Ajax and JavaScript development we did for Jiibe

Ref :