SQL executes on command-line but not in PERL

2001-02-15 Thread Laszlo G. Szijarto
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,

Re: SQL executes on command-line but not in PERL

2001-02-15 Thread Laszlo G. Szijarto
Thank you, Ryan, but the PERL code runs perfectly if I try it on any other field. It just doesn't run on THIS field. It's not a SPECIAL field in any way (like PRI Key or Unique or anything like that). When I run it in a compound statement like "update accounts set users=10, loggedin=10 where

Re: SQL executes on command-line but not in PERL

2001-02-15 Thread Rolf Hopkins
What about repairing the table and what does DESC tablename say? - Original Message - From: "Laszlo G. Szijarto" [EMAIL PROTECTED] To: "Ryan Wahle" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 3:20 Subject: Re: SQL executes on command-