Snippets
Sergio de EOM Code Base Test FIX MSSQL Express 2008 R2 + Windows server 2008 Standar + PHP 5.6 x86 + pdo_sqlsrv.dll Ver.3.2
Show Data in table “CTA_VENDEDOR” MSSQL 2008 Express:
Print: http://s19.postimg.org/brx6vi49v/Print_De_Pantalla_520.jpg
Scheme, MSSQL 2008:
DB: “MDM-QA” or “Manjares_del_Mar_SRL-QA”
Table: CTA_VENDEDOR
Field: COD_VENDEDOR
OUT DEBUG CAKEPHP:
(int) 6 => array( //Test Sql 6 ‘query’ => ‘SELECT TOP 1 [CTA_VENDEDOR].[COD_VENDEDOR] AS [CTA_VENDEDOR__COD_VENDEDOR] FROM [CTA_VENDEDOR] AS [CTA_VENDEDOR] WHERE [CTA_VENDEDOR].[COD_VENDEDOR] = N’LS’ ORDER BY (SELECT NULL)’, ‘params’ => array(), ‘affected’ => (int) 0, ‘numRows’ => (int) 0, ‘took’ => (float) 1 ), (int) 7 => array( //Test Sql 7 ‘query’ => ‘SELECT TOP 1 [CTA_VENDEDOR].[ID_CTA_VENDEDOR] AS [CTA_VENDEDOR__ID_CTA_VENDEDOR], [CTA_VENDEDOR].[FILLER] AS [CTA_VENDEDOR__FILLER], [CTA_VENDEDOR].[COD_VENDEDOR] AS [CTA_VENDEDOR__COD_VENDEDOR], [CTA_VENDEDOR].[DESC_VENDEDOR] AS [CTA_VENDEDOR__DESC_VENDEDOR] FROM [CTA_VENDEDOR] AS [CTA_VENDEDOR] WHERE [CTA_VENDEDOR].[cod_vendedor] = N’LS’ ORDER BY (SELECT NULL)’, ‘params’ => array(), ‘affected’ => (int) 0, ‘numRows’ => (int) 0, ‘took’ => (float) 15 ), (int) 8 => array( //Test Sql 8 ‘query’ => ‘SELECT COUNT AS [count] FROM [CTA_VENDEDOR] AS [CTA_VENDEDOR] WHERE [COD_VENDEDOR] = N’LS’‘, ‘params’ => array(), ‘affected’ => (int) 1, ‘numRows’ => (int) 1, ‘took’ => (float) 20 )
Comments (0)
You can clone a snippet to your computer for local editing. Learn more.