[TYPO3-dev] pi_getRecord

[Steffen Kamper]

"Sebastiaan van Parijs" <sebastiaan at framed.nl> schrieb im Newsbeitrag 
news:mailman.1.1213693324.22593.typo3-dev at lists.netfielders.de...
> Hi,
>
> Thnx for the quick reply, i used your function and it returns this:
>
> # Values #
> params
> 0 tx_formsbuilder_datacollection
> 1 7
> # End #
>
> This is the same as the echod values:
>
> # Echos #
>
> Table: tx_formsbuilder_datacollection
> Uid: 7
>
> # End #
>
> So that seems to be working fine, but still i get the same error with the 
> function:
>
> # Error #
>
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL 
> result resource in 
> /usr/local/www/vhosts/framed.nl/subdomains/dev/httpdocs/t3lib/class.t3lib_db.php 
> on line 796
>
> # End error #
>
> What am i doing wrong? When i try to get another Table it works...
> # Code sample #
>
> $rec = $this->pi_getRecord( $this->extTables['structureSelection'], '1' ); 
> print_r( $rec );
>
> # End sample #
>
> It shows a complete array or wanted values.
>
> So again what to do now?
>
> Thnx for the good help by the way, love the good ideas.
>
> Sebastiaan
>

pi_getRecord is a wrapper for the function t3lib_page::checkRecord

There the query is build with enableFields, which recommend TCA-entry for 
the table.
If you don't have TCA-entry, the query will fail.

btw - if you see errors with sql, enable sqlDebug in installtool to see the 
query which fails.

vg Steffen