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;

SQL - MS SQL

Escape underscore(_) in LIKE statement
To escape underscore(_) in LIKE statement, you have to enclose the underscore(_) inside square brackets.
-- Select all values that end with _B.
SELECT *
FROM TableA
WHERE TableA.col LIKE '%[_]B';
Check SQL Server version and edition
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition');
Copy all data of a table to another 1
 

Pages

Subscribe to OpenWritings.net RSS