Can we see the code? It's hard to debug stuff via telepathy. Currently my money would be on you not loading the DBI module in the program (like the error message suggests).

hi davorg

thanks for immediate response and here the code which i am trying

to execute,kindly help me



use DBI;  # Here's how to include the DBI module

my $dbh;

my $db = 'myfirstdatabase'; 
my $db_user = 'RAM'; 
my $db_password = ''; 

# Connect to the requested server 

$dbh = DBI->connect ("dbi:mysql:$db","$db_user", "$db_password",{Raise
+Error => 0, PrintError => 0} ) or err_trap("Cannot connect to the dat
+abase");
my $sql;
my $sth;
$sql = "SELECT max(unxtmstmp) FROM logfl";
      
$sth=$dbh->prepare($sql) or die "preparing: ",$dbh->errstr;
$sth->execute or die "executing: ", $dbh->errstr;
@$d = $sth->fetchrow_array;
print "@$d";
[download]

This program works for me, once I change $db, $db_user, $db_password, and $sql to something that exists on my system. Also I had to add a subroutine for err_trap(). Do you have the DBD::mysql module installed?

hi Gilimanjaro

after doing modifications said by u only one error i am getting, the coding is as follows :==>

use strict;
use warnings;

use DBI;
# Here's how to include the DBI module 
my $dbh;

my $db = 'myfirstdatabase';
   my $db_user = 'RAM';
   my $db_password = '';
   # Connect to the requested server 

   $dbh = DBI->connect("dbi:mysql:$db","$db_user", "$db_password",{Rai
+seError => 0, PrintError => 0} ) or err_trap("Cannot connect to the d
+atabase");
   my $sql;
   my $sth;
   my $td;
   $sql = "SELECT max(unxtmstmp) FROM logfl";
      
   $sth=$dbh->prepare($sql) or die "preparing: ",$dbh->errstr; 
   $sth->execute or die "executing: ", $dbh->errstr; 
   $td = $sth->fetchrow_array;
   print "$td";
[download]

==================================================

The error which i am getting when i run the above program is

C:\ram>perl timeinblt.pl
Can't locate object method "connect" via package "DBI" (perhaps you fo
+rgot to load "DBI"?) at timeinblt.pl line 14.
C:\ram>
[download]

the line no. 14 is

$dbh = DBI->connect("dbi:mysql:$db","$db_user", "$db_password",{RaiseError => 0, PrintError => 0} ) or err_trap("Cannot connect to the database");

Edited 3 Aug 2004, by footpad: Converted <br> tags to <P> tags and added <code> tags.

This almost certainly means something is not right with your DBI installation... Try adding

print "$_\n" for grep /^[a-z]/, keys %DBI::;
[download]

after your 'use DBI;'. This single line will show you all symbols (including methods) in your DBI package after you've used it. If this list contains 'connect' then there's something wrong with your perl. If it doesn't, then something is wrong with your DBI. You could try reinstalling your DBI package maybe...