On Mon, May 17, 2004 at 08:34:07PM +0100, Tim Bunce wrote: > On Mon, May 17, 2004 at 11:22:35AM -0300, Pedro Anisio wrote: > > I used trace() but still cannot figure out what is happening, but still dont > > work :-( > > > > I'm sending attached the log files and the program. > > working: > -> prepare for DBD::mysql::db (DBI::db=HASH(0x8925a28)~0x891f5a0 > 'update mensagem set mens_stat = 2 where mens_codigo = 350027984 and mens_stat > = 1') > -> execute for DBD::mysql::st (DBI::st=HASH(0x893ea20)~0x893ead4) > <- dbd_st_execute 1 rows > > not working: > -> prepare for DBD::mysql::db (DBI::db=HASH(0x8925a5c)~0x891f5e4 > 'update mensagem set mens_stat = ? where mens_codigo = ? and mens_stat = ?') > -> execute for DBD::mysql::st (DBI::st=HASH(0x893ea34)~0x893eae8 2 350027984 1) > Binding parameters: update mensagem set mens_stat = '2' where mens_codigo = > '350027984' and mens_stat = '1' > <- dbd_st_execute 0 rows > > I suspect if you change the working one to put quotes around the > values in the WHERE clause it'll break.
Pedro, was this the issue? > Out of interest, what's the definition of the mensagem table? I'm still interested to know this. (The "show create table mensagem" output would be ideal. Along with the server version.) Cases where the quotes matter are rare but important, so I'd like to be sure I understand what's happening here. Thanks. Tim.
