comment on

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.

In reply to Re^2: (mysql) failing to locate object method by sriraj
in thread (mysql) failing to locate object method by sriraj

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


"be consistent"
	PerlMonks