Re: MySQL data get and set problem

2010-08-10 Thread Nitin Mehta
rds, Nitin From: Manasi Save To: Michael Dykman Cc: "mysql@lists.mysql.com" Sent: Tue, August 10, 2010 10:34:37 AM Subject: Re: MySQL data get and set problem Hi Michale, I have made that parameter column name change. but I am unable to understand how even after

Re: MySQL data get and set problem

2010-08-09 Thread Manasi Save
Hi Michale,   I have made that parameter column name change. but I am unable to understand how even after execution of update statement and commit after that, data is getting reverted.   Any inputs on this will be a great help. -- Regards, Manasi Save On Mon, 9 Aug 2010 14:11:19 -0400, Michael

Re: MySQL data get and set problem

2010-08-09 Thread Michael Dykman
You might have better results if you use unique identifiers: Select MyID From Test Where TestID = TestID; I'm not sure how mysql is supposed to tell the param 'TestID' from the column name. - michael dykman On Mon, Aug 9, 2010 at 3:10 AM, Manasi Save wrote: > Dear All, > > Table values are g

MySQL data get and set problem

2010-08-09 Thread Manasi Save
Dear All,   Table values are getting rollback without calling rollback.   I have a table Test with some columns in it.   Here's the Table Structure:-   Create Table TestID ( TestID int not null, MyID int );   I am calling two procedures one is get the value of MyID column and one is to set the va