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>. https://trac.cakephp.org/ticket/3991

<?php
  //Pagination
  if($paginator->hasPage(null, 2))// Don't display pagination if there is no second page.
  {
    //&laquo;
    $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 http://book.cakephp.org/view/125/data-validation

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.

<?php
class User extends AppModel
{
  var $name = "User";
 
  // Validation rules.
  var $validate = array(
    'username'=>array(
        'isUnique'=>array(
            'rule'=>'isUnique',
            'message'=>'This username has already been taken.',
            ),
        'stringLength'=>array(

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
FROM TableA
WHERE TableA.col=[Enter a VALUE];

SQL - Oracle

Oracle

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

Pages

Subscribe to OpenWritings.net RSS