Questions tagged as 'postgresql'

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:

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

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.

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.