Radicore Forum: How To » Condition in $where string is being lost

Home » RADICORE » How To » Condition in $where string is being lost

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

Condition in $where string is being lost [message #1643]

Fri, 12 September 2008 13:40

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

I'm trying this approach with a league and assigning teams to it. I'm changing the where clause in the child subclass so that it displays teams with grucomp_id=NULL, the code is the following:

    // ****************************************************************************
    function _cm_pre_getData ($where, $where_array, $fieldarray=null)

    {
       
$where = "equipo.grucomp_id IS NULL AND grucomp.liga_id in 
(SELECT liga.liga_id FROM liga WHERE liga.deporte_id=equipo.deporte_id AND liga.categoria_id = 
equipo.categoria_id AND liga.temporada_id = equipo.temporada_id)";

        return $where;

    } // _cm_pre_getData

By debugging the sql file I see that the where clause is

equipo.grucomp_id IS NULL

and that all the other conditions in the clause are erased.
Any tips to where the where clause removes the last part of the conditions I add?

Report message to a moderator

[Message index]

		Condition in $where string is being lost By: bonzo_bcn on Fri, 12 September 2008 13:40
		Re: Condition in $where string is being lost By: AJM on Fri, 12 September 2008 13:54

Previous Topic:	Exporting data from radicore into an excel file
Next Topic:	Help text task_id

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 18 09:06:24 EST 2024

Total time taken to generate the page: 0.00962 seconds