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

newgrp at googlemail.com newgrp at googlemail.com
Sun Mar 8 19:31:31 CET 2009


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 



More information about the TYPO3-project-formidable mailing list