Update Field Snippets


23 November, 2013   

Lets say you have a table with field called "tags" that consists from tags separated by commas and you want to check whether it includes a required tag. Here the simplest ways of doing that.

02 November, 2014   

The RETURNING clause was implemented as part of the Oracle 10g release and is used to return information about the effected rows after issuing Data Manipulation Language (DML) statements.

Example: There is a table, 'user', with a column, 'clear', containing values such as: `clear \'animal\' \'pass'\ ` and we would like to retrieve 'animal' and 'pass' ( without the pre & post \' )

11 August, 2012   

MySQL code to find and replace string

21 January, 2012   

PL/SQL Block that uses implicit cursor attributes as below example code.

26 January, 2012   

A simple example template of an Asset Update XML

This stored sql procedure is used to replace a special character (or string) of your field with another string.

01 December, 2011   

The following code block shows how to run DML statements in PL/SQL. Basically they look similar to the SQL. Note that the SELECT statement retrieves the single-row value and store into a variable using INTO clause.

13 June, 2011   

Providing your visitors with a way to add your web site to their favorite places provides a great way to obtain repeat traffic. This is a great way to increase your overall traffic and sales, as they can visit your web site again and again. However, to obtain repeat traffic, you must continually update your content and give your visitors a...

Demonstrates to select all the Birthdays that will occur as of today, 15 days

Select all the Birthdays that will occur as of today, 15 days

To create the formatter paste this code into a new file and name it sfWidgetFormSchemaFormatterDefList.class.php. I saved it in /lib but it also makes sense to put it in /lib/form, depending on your personal preference.

HTML code Snippet to get directions form (Google Maps) saddr = blank input field for entering START address daddr = hard-coded END address

13 October, 2012   

You need to give each element a sequentially numbered tab index value in order for this script to work properly.

03 November, 2012   

Example code shown here how to get value from radiobutton

04 July, 2011   

Animation with threads by John E. Grayson

16 June, 2012   

You can use JavaScript window.location to redirect a visitor to a required page. You may have seen this feature used by sites with full page ads, or to redirect visitors to the site's new domain name. You can add also a timer to the script that will allow the page to redirect and the visitors will not need to click a link or type in the new URL.

02 October, 2012   

An example code to get value from radio button

25 August, 2012   

VB.Net code example to get value from radio button

10 September, 2011   

Example code showing how to add a primary constraint. This Oracle constraint is used to identify the primary key for a table. A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key. This...