[TYPO3-dev] exec_INSERTmultipleRows doesn't insert records, that exec_INSERTquery does

Jigal van Hemert jigal at xs4all.nl
Wed Jun 29 22:51:23 CEST 2011


Hi,

On 29-6-2011 17:46, Victor Livakovsky wrote:
> $GLOBALS['TYPO3_DB']->exec_INSERTmultipleRows('tx_lvestate_announcements',
> array_keys($announces[0]), $announces);
[...]
> If I uncomment error lines, I get this sql error: Column count doesn't
> match value count at line 6

You can debug it easily by letting the db class remember the last built 
query:
$GLOBALS['TYPO3_DB']->store_lastBuiltQuery = TRUE;
.... do your query stuff ....
t3lib_utility_Debug::debug($GLOBALS['TYPO3_DB']->debug_lastBuiltQuery, 
'last built query');

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert.




More information about the TYPO3-dev mailing list