Sql Error Handling Snippets


13 November, 2011   

Boiler Plate for T-Sql Error handling

31 July, 2012   

Boiler Plate for T-Sql Error handling

01 October, 2011   

An example of Exception Handling in PL SQL

11 April, 2013   

Pull external HTML code from a file right into your webpage

01 February, 2011   

Missing images will either just display nothing, or display a [ ? ] style box when their source cannot be found. Instead you may want to replace that with a "missing image" graphic that you are sure exists so there is better visual feedback that something is wrong. Or, you might want to hide it entirely. This is possible, because...

17 February, 2019   

Missing images will either just display nothing, or display a [ ? ] style box when their source cannot be found. Instead, you may want to replace that with a "missing image" graphic that you are sure exists so there is better visual feedback that something is wrong. Or, you might want to hide it entirely. This is possible because...

09 January, 2013   

Better way to handle Broken Image. Missing images will either just display nothing, or display a [ ? ] style box.

05 May, 2012   

ASP code example with Sql Statement

29 January, 2011   

Cufon 101

05 May, 2012   

ASP code example to return a long representing the record count returned by an SQL statement

21 January, 2012   

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

14 May, 2011   

This is a general code to use when updating an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match.

14 May, 2011   

This is a general code to use when deleting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. A variation of the code would be not to delete the record (as you tend to always need to restore or retrieve it sooner or later) you can add a 'status' field. If status='d' then it is...

20 April, 2013   

You can create your own Exceptions in PL/SQL

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.

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.

09 May, 2011   

This is a general code to use when inserting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. An extention of this code would be to make sure the entry you are adding to the database doesn't already exist (to save dupicate entries). Note: This code requires you to connect to the MySQL...

09 May, 2011   

This is a general code to use when selecting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match. This MYSQL Code using in PHP

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

Exam code to backup MySQL Database to SQL File