Radicore Forum: Framework » getData

Home » RADICORE development » Framework » getData_serial ($where)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

getData_serial ($where) [message #7607]

Fri, 16 July 2021 09:08

htManager
Messages: 434
Registered: May 2014

Senior Member

Hi Toni,
I have a list view report and I want to order the records alphabetical. In the _cm_post_fetchRow($fieldarray) method I get all the records in a different order.
In functions-and-variables.html I read that the getData_serial($where) methods gets all the records from the database. Afterwards they will be passed to the _cm_post_fetchRow() method one after the other.
In which _cm_... method can I see or change the order of the records or call the getData_serial($where) method?

Report message to a moderator

Re: getData_serial ($where) [message #7608 is a reply to message #7607]

Sat, 17 July 2021 04:31

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

You must set $this->sql_orderby BEFORE the call to getData_serial, which will merely issue the SELECT query *without* returning any data, just a resource. Calls to $this->fetchRow() will then return one record at a time from that resource.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: getData_serial ($where) [message #7609 is a reply to message #7608]

Sun, 18 July 2021 07:10

htManager
Messages: 434
Registered: May 2014

Senior Member

Thank you. I placed the code in _cm_pre_getData() and everything works fine now.

Report message to a moderator

Previous Topic:	Drop Down - PDF Output
Next Topic:	SQL with concat() - cannot extract token from

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Nov 23 07:23:52 EST 2024

Total time taken to generate the page: 0.00992 seconds