RE: sql statements

[John Deretich]

I am trying to use dbi
to pull the system date and
put into it into a scalar.
I tried initializing the mydate variable
in sql to perl as $mydate = undef;
but it returned the message can't bind
unknown placeholder ':p1'.
Any ideas.

thanks,

John

-----Original Message-----
From: ?d Derek Douglas-Hecker [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 21, 2003 1:25 PM
To: John Deretich
Subject: RE: sql statements


below works for me....actually both statements return the same value...what
are you trying to do?

?d



use DBI;

$dbh = DBI->connect("dbi:Oracle:",'username','password') or die
"$DBI::errstr\n";

my $sth = $dbh->prepare(qq{select sysdate into :mydate from dual});
#my $sth = $dbh->prepare(qq{select sysdate from dual});

if (! ($sth->execute())) {
    print "$DBI::errstr\n";
}else{
    $row = $sth->fetchrow_array;
    print "$row\n";
}

$sth->finish;
$dbh->disconnect;
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs