List Notes
| Actions |
|---|
//route, otherwise even index.php/notes/ shows the same as index.php or /
$Route->connect('/', array('controller' => 'notes', 'action' => 'index'));
/*************************Start HTML******************************************/
Warning: Invalid argument supplied for foreach() in d:\Inetpub\wwwroot\Pulse\cake\libs\controller\controller.php on line 598
Warning: Invalid argument supplied for foreach() in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 308
Notice: Uninitialized string offset: 0 in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 316
Notice: Uninitialized string offset: 0 in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 316
Notice: Uninitialized string offset: 0 in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 318
Notice: Uninitialized string offset: 0 in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 321
Notice: Uninitialized string offset: 0 in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 321
Warning: mssql_query() [function.mssql-query]: message: Cannot use empty object or column names. Use a single space if necessary. (severity 15) in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 160
Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near ''. (severity 15) in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 160
Warning: mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server. (severity 5) in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 160
Warning: mssql_query() [function.mssql-query]: Query failed in d:\Inetpub\wwwroot\Pulse\cake\libs\model\dbo\dbo_mssql.php on line 160
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('hermes_notes', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('notes'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'notes' | 0 | 0 | 2 | |
| 2 | SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('hermes_notes', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('notes'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'notes' | 0 | 0 | 1 | |
| 3 | SELECT [note].[] AS [note__] FROM [hermes_notes] AS [note] WHERE 1 = 1 | 1 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('hermes_notes', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('notes'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'notes' | 0 | 0 | 2 | |
| 2 | SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('hermes_notes', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('notes'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'notes' | 0 | 0 | 1 | |
| 3 | SELECT [note].[] AS [note__] FROM [hermes_notes] AS [note] WHERE 1 = 1 | 1 |