CakePHP - Pagination

I can't change the output of PaginatorHelper::next and PaginatorHelper::prev to return as <span>. So, I wrote code to replace <div> with <span>.

  if($paginator->hasPage(null, 2))// Don't display pagination if there is no second page.
    $sPrev = $paginator->prev('«'.__('Previous', true), null, null, array('class'=>'disabled'));
    $sPrev = str_replace('<div class="disabled">', '<span class="disabled">',$sPrev);
    $sPrev = str_replace('</div>', '</span>',$sPrev);

CakePHP - See all data that have been sent to the controller

Put the following in the function of your controller:

CakePHP - Fields Data Validations

Change validations errors messages

CakePHP - Execution order of multiple validation rules

Below is a typical validations rules for User Model. The validations rules of a field are ran from bottom up. In this case, for the email field, it will run stringLength, email and then isUnique rules.

class User extends AppModel
  var $name = "User";
  // Validation rules.
  var $validate = array(
            'message'=>'This username has already been taken.',

Ant - Using timestamp

Example of using timestamp

Ant - Ant with JUnit4

Sample Ant build file to run JUnit

<?xml version="1.0" encoding="UTF-8"?>
  Filename: build.xml
  Note: You have to change the followings according to your environment:
          -<pathelement location="bin"/>
          -<pathelement location="lib/junit/junit-4.8.2.jar"/>
          -<test name="x.x.x.x.x.x" todir="${junit.output.dir}"/>
<project basedir="." default="junit" name="Sample of Ant file for JUnit">
  <property name="junit.output.dir" value="junit"/>
  <path id="junit.classpath">

SQL - MS Access

Useful Functions

Nz( variant, [ value_if_null ] )
Return defined value if variant is null. value_if_null is optional. If value_if_null is not defined, then it will return zero-length string. Example of usage in MS Access Query Design View: Field: Expr1: Nz(AnyColumValue, "Value is null")
Ask for user input in query
You can use square bracket to ask for user input each time that the query is ran.
SELECT TableA.col
WHERE TableA.col=[Enter a VALUE];

SQL - Oracle


Check Oracle version
  1. Login to SQL *Plus.
  2. Get the version by running query:
    SELECT * FROM v$version;


Subscribe to RSS