On Tue, Apr 17, 2001 at 04:11:53PM +0200, jmb wrote:
> Hi,
> I am new to this list and am looking for some help. I have tried finding my
> problem with perldoc DBI and the FAQ, but without luck... 8(
>
> I am trying to execute the following statement:
> $query = $dbhandle->prepare("select FAXID from GMX.FAX_DIR where
> PROCESSLEVEL=2 and (sysdate - LASTCHANGE)<$T_MAX_OPEN ");
>
> The error I get is:
> Can't call method "prepare" on an undefined value at ./myprog.pl line 144.
>
The use of SysDate doesn't actually matter in this problem. The variable
$dbhandle does not have a defined value. When you call DBI->connect(), are
you checking the return value to make sure the connection succeeded?
Ronald
