[TYPO3-dev] pi_getRecord

[Sebastiaan van Parijs]

Hey Thnx Steffen,

This error message brought me in the right direction, it seems the 
starttime gives back an error that needs to befixed. Probably did'nt set 
is correctly ill see in to this, but for now thank you for getting me a 
new tool debug my sqls.

Ill message when my function works as intended.

Regards,

Sebastiaan



Steffen Kamper wrote:
> "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
> 
>