in reply to Re: $sth->execute error
in thread $sth->execute error

Thanks, that worked!

Beside the fields evalue1 & evalue2 the variables are either integer or text.
The design of database is very bad. It runs in a virtual machine on NFS. Every join takes ages, so now the attempt to have all data in one table.

Replies are listed 'Best First'.
Re^3: $sth->execute error
by Rodster001 (Pilgrim) on Feb 14, 2009 at 07:52 UTC
    NFS and virtual machine is not necessarily bad. I would check your indexes though (make sure the columns you join on are indexed and your where clauses are too).