[TYPO3-project-formidable] renderlet:LISTER in Searchform / Displayof total number of records / Access to SQL-Query

[Leopold Mayr]

Hi Hauke,

thanks for the tip, but unfortunately this doesn't work here due to  
the fact that I use a datahandler:VOID (I just want to search stuff  
and not alter the database).

But thanks a lot for the fast reply!

regards,

Leo

Am 08.03.2009 um 19:31 schrieb <newgrp at googlemail.com> <newgrp at googlemail.com 
 >:

> Hi Leo,
>
> I haven't worked with Searchform etc yet, but to your second problem:
> Try using $this->oDataHandler->_getStoredData(); as as php user  
> object.
> It should content all the data of  the SQL statement.
>
> Regards,
> Hauke
>
> ----- Original Message -----
> From: "Leopold Mayr" <leo at sprinkesnirg.de>
> To: "TYPO3 project list for the FORMidable extension"
> <typo3-project-formidable at lists.netfielders.de>
> Sent: Sunday, March 08, 2009 2:55 PM
> Subject: [TYPO3-project-formidable] renderlet:LISTER in Searchform /
> Displayof total number of records / Access to SQL-Query
>
>
>> Hi List,
>>
>> ...I hope this ain't a dumb question...
>>
>> I have a searchform with a lister that displays 50 records at a time
>> (with pager).
>>
>> I have the following two problems:
>>
>> 1. I want to display the total number of records that match the  
>> search
>> critera and I can't find any info on that, maybe I've been looking in
>> all the wrong places...
>>
>> 2. In each row of the lister I have included a checkbox with
>> activelistable=true and a "Save all" button that saves the uids of
>> checked records in a session array (a "remember" list). I have also
>> written a Javascript function that checks all checkboxes. All this
>> works fine, but it only works for the records that are displayed. I
>> want to include a "Save all" Button that saves all uids of records
>> that match the search criteria. Is there a way to access the SQL- 
>> query
>> generated by the searchform so that I can extract a list of uids
>> maually? I could then also use this Query to get the total number of
>> records in order to solve problem #1. Or is there an array that
>> contains all records?
>>
>> I'd appreciate any help, because I'm really stuck here
>>
>> Thanks in advance,
>>
>> Leo
>>
>>
>> _______________________________________________
>> TYPO3-project-formidable mailing list
>> TYPO3-project-formidable at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>
> _______________________________________________
> TYPO3-project-formidable mailing list
> TYPO3-project-formidable at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable