Hi,
I tried without quotes before and same results.
Anthony
Hi,
I tried to create a temporary table which should be a clone a real table by using the
following code:
$sth=$dbh->prepare("INSERT * INTO $tblTemp FROM $tblReal WHERE 1= 2");
This sql statement works in MS enterprise server, but not on Linux system. The error
message I got is like the follo
On Fri, 20 Jun 2003 20:47:20 +0200 anthony <[EMAIL PROTECTED]> wrote:
> I don't understand nothing with SQL.
> I do this
> $dbh= DBI->connect..
>
> $sth=$dbh->prepare(qq(SELECT longitude, latitude FROM place WHERE
> userid='?')) or die...;
> $sth->execute($userid) or die..;
As Timoth
On Sat, 21 Jun 2003 01:55:52 +0530 Biswajeet Padhy <[EMAIL PROTECTED]> wrote:
> can You please suggest why I am getting the error in following code;
>
> $test_num="500212275";
> $sql='begin CDI1_GETSEQ_PKG.CDI1_GETphoneID_PROC(:test_num); end;';
> $sth = $dbh->prepare( $sql);
> $sth->bind_param(
Hi Jonathan,
I find that I go in circles between Bundle::DBD::mysql and just DBD::mysql.
In addition to the DBD modules I'm getting it with these modules:
Attribute::Handlers
List::Util
Text::Balanced
Tie::File
Unicode::Normalize
if
If I find duplicate files and then either delete them both and
can You please suggest why I am getting the error in following code;
$test_num="500212275";
$sql='begin CDI1_GETSEQ_PKG.CDI1_GETphoneID_PROC(:test_num); end;';
$sth = $dbh->prepare( $sql);
$sth->bind_param(":test_num", $test_num);
$sth->execute();
print "[EMAIL PROTECTED]";
$sth->finish()
when
my $sql = 'begin sm_api.renew_subscription(:1, :2, :3, :4); end;';
my $sth = $db->prepare($sql);
eval
{
$sth->bind_param(1, $order_id);
$sth->bind_param(2, $version_id);
$sth->bind_param(3, $sid);
$sth->bind_param_inout( 4, \$ret, 128 );
In the first case, you don't need any quotes around the ?. DBI will handle the quoting
for you.
In the second case, you need single quotes, not double quotes.
-Original Message-
From: anthony [mailto:[EMAIL PROTECTED]
Sent: Friday, June 20, 2003 2:47 PM
To: [EMAIL PROTECTED]
Subject: s
Hi,
I don't understand nothing with SQL.
I do this
$dbh= DBI->connect..
$sth=$dbh->prepare(qq(SELECT longitude, latitude FROM place WHERE
userid='?')) or die...;
$sth->execute($userid) or die..;
I also done this
$sth=$dbh->prepare(qq(SELECT longitude, latitude FROM place WHERE
userid
Thanks Alan,
Can I call a stored procedure in perl DBI using DBD:Oracle driver. If so can
I have a sample piece of code so that I can call a stored procedure.
the stored procedure will take some input parameters and return a unique no.
Thanks for your help.
Biswajeet
-Original Message
>
> Jeff,
>
> one new issue with 1.06.
>
> o line 297 of the generated Makefile contains
> @$(NOOP)
> but those are spaces leading up to it instead of a tab. The
> line at fault is
> actually Makefile.PL line 427.
Fixed. Thanks.
>
> o the problem I reported (email subject line) st
Jean-Louis Leroy wrote:
*** SQL-Statement-1.005/lib/SQL/Statement.pm Mon Jun 2 14:55:34 2003
Thanks very much, I will encorporate these in as soon as possible.
--
Jeff
Has anybody else noticed the multiple file problem when using CPAN or CPANPLUS?
You check recommended, update to the latest, which passes, check again and it still
thinks you are out of date.
If you do a 'find' in the file system you find two files, one near the root of
lib/perl5 and one
*** SQL-Statement-1.005/lib/SQL/Statement.pm Mon Jun 2 14:55:34 2003
--- SQL-Statement-1.005_patch/lib/SQL/Statement.pm Mon Jun 2 14:56:00 2003
***
*** 1068,1074
sub is_matched {
my($self,$val1,$op,$val2)[EMAIL PROTECTED];
#print "[$val1] [$op] [$val2]\n";
!
Jeff,
one new issue with 1.06.
o line 297 of the generated Makefile contains
@$(NOOP)
but those are spaces leading up to it instead of a tab. The line at fault is
actually Makefile.PL line 427.
o the problem I reported (email subject line) still exists after I fixed above
and install
Hi Jonathan,
i tried to compile a Perl 5.8.0, DBI-1.37, DBD-Informix 2003-04 and
Informix Client SDK 2.80FC2 on Solaris 9 with Sun Forte 7 Compiler. It's
a 64 bit Database engine so i compiled it all with -xarch=v9. A simple
script like
#!/usr/bin/perl -w
use DBD::Informix;
my ($dsn) = "DBI:
Hi Pascal,
usually you can not query more than one database with one sql.
But really you don't query a database with a sql-statement, you do query a
table in a database to which you are
connected to.
And here lies the key, as far as your database does not support federated
database ( sql-access t
17 matches
Mail list logo
