___ ___ erkimt SQLSTATE [42703] Undefined column: 7 ERROR: alis.nome_coluna column does not exist LINE 1: [closed] ______ qstntxt ___

I have a page on my system that does a file transfer, it just does an update on the table. I copied the lines of this code and put it to work on another page, changing only the field and table names.

I'm using the Symfony 1.4 framework with MVC for PHP development. In the action of the original function there are two actions one that opens the page and another that makes the update code. In the action of the other page, I copied the action that makes the page open and the code action doing the update, changed the fields and table name.

My role, as I said, is to take the procedure number (original code page) and bring it along to whom the procedure was registered. In the database has a boolean column %code% that receives default %code% and if it is changed it becomes %code% - and if it is %code% I say in my code for it to invert the values.

I did the same thing for the other page. If I do not create the column %code% (new boolean column) my button that does the function of opening the page to transfer, everything works fine, however it does not change anything because it does not have a column in the table created to receive the value% with%. If I create the column %code% my system does not load the data and the error appears saying that the column does not exist.

My action code is this:

%pre%

I am not the creator of the system, I am only giving maintenance (I am a trainee). Can anyone help me?

    

______ azszpr57824 ___

try to put one in? as in the above line between the parameters:  -> set ('d.transferido_den', '?', 'NOT (d.transferido_den)')

It will probably work.

    

______ azszpr58125 ___

I was making a mistake because of the database I was calling. There were 2 with similar names, I was creating in db that was not being called in my file, so the error.

    

___

I have a page on my system that does a file transfer, it just does an update on the table. I copied the lines of this code and put it to work on another page, changing only the field and table names.

I'm using the Symfony 1.4 framework with MVC for PHP development. In the action of the original function there are two actions one that opens the page and another that makes the update code. In the action of the other page, I copied the action that makes the page open and the code action doing the update, changed the fields and table name.

My role, as I said, is to take the procedure number (original code page) and bring it along to whom the procedure was registered. In the database has a boolean column transferido that receives default false and if it is changed it becomes true - and if it is true I say in my code for it to invert the values.

I did the same thing for the other page. If I do not create the column transferido_den (new boolean column) my button that does the function of opening the page to transfer, everything works fine, however it does not change anything because it does not have a column in the table created to receive the value% with%. If I create the column true my system does not load the data and the error appears saying that the column does not exist.

My action code is this:

public function executeTransferir(sfWebRequest $request)
{
    $this->forward404Unless(
        $denuncias = Doctrine::getTable('Denuncias')->find(array($request->getParameter('id'))), 
        sprintf('Object denuncias does not exist (%s).', 
        $request->getParameter('id'))
    );

    $this->forward404Unless($this->getUser()->hasPermissionFor('denuncias','editar'), 'Você não possui permissão para executar esta ação!');

    $params = $request->getParameter("denuncias");

    Doctrine_Query::create()
        ->update('denuncias d')
        ->set('d.id_conselho', '?', $params['id_conselho'])
        ->set('d.transferido_den', 'NOT(d.transferido_den)')
        ->where('d.id = ?', $request->getParameter('id'))
        ->execute();

    return $this->renderText('<script>parent.window.location.href = "' . $this->getController()->genUrl('@denuncias') . '";</script>');
} 

I am not the creator of the system, I am only giving maintenance (I am a trainee). Can anyone help me?