Hi Jignesh, On Fri, Jun 28, 2013 at 7:11 AM, Jignesh Kakka (jkakka) wrote:

I am calling Do method of DBObject and passing this statement

delete from customer_user where login = 'test123' this returns me 1 in response every time

and when I pass select login from customer_user where login = 'test123' this also returns me 1 in response.

Is this issue with otrs or is there some caching happening?

Well the best way to find out is probably to check what you see in the database; but I doubt it'd be caching. Please write your code like this: return if !$Self->{DBObject}->Do( SQL => 'DELETE FROM customer_user WHERE login = ?', Bind => [ \$Login ], ); This should just work :D -- Mike