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 ex

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 u

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

2001-02-15 Thread Ryan Wahle
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 loggedi