you probaly don't have your code setup correctly. put some of the perl
code that does the statement to let us help you more.
On Thu, 15 Feb 2001, Laszlo G. Szijarto wrote:
> Hi, everyone,
> I've recently run into a strange phenomenon.
>
> I try to tun the statement "update accounts set loggedin=10 where username='user'"
>-- works fine from the command line. But I used it in a PERL DBI situation and it
>does NOTHING -- no error, nothing. I know the PERL code is fine, because I've tried
>substituting the $sql variable (containing the statement) with other statements just
>for test purposes, like for example changing some other fields -- and it works fine.
>In fact, I tried a combination statement,
> "update accounts set users=10, loggedin=10 where username='user'" and the users
>field updates but the loggedin field does not. Both are int(11) columns. And the
>very same statement works PERFECTLY from the command line. Does anyone have ANY
>idea? I've been busting my brains and trying all kinds of things -- with NO success.
> Thank you in advance,
> Laszlo Szijarto
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
