crowja wrote:
Is there a dummy driver for DBI that basically does
nothing? Maybe a set of stubs so I could do something
like this:
use DBI;
my $dbh = DBI->connect("dbi:null", "", "");
my $sth = $dbh->prepare("SELECT * FROM mytab WHERE id = ?");
$sth->execute(3141);
while (my @vals = $sth->fe
I'm actually looking for the source code for execute() (IE sub execute {
.. }), do() and quote() are in DBI.pm, prepare() is in DBD/mysql.pm but
execute in neither.
The source code for execute is in dbd_st_execute() in dbdimp.c, and if you want
to know how the quoting is done, you will need to
.
> > Can't locate object method "ad_catalog" via package "DBI::db" at
> > threesharp.pl line 9.
> >
> > my $dbh = DBI->connect('dbi:AnyData(RaiseError=1):');
> > $dbh->ad_catalog( $table_name, 'ThreeSharp', $file_name);
>
> It sounds like you have an older version of DBI (<1.37),
leegold wrote:
C:\Documents and Settings\Administrator\Desktop\threesharp>perl
threesharp.pl
Can't locate object method "ad_catalog" via package "DBI::db" at
threesharp.pl line 9.
my $dbh = DBI->connect('dbi:AnyData(RaiseError=1):');
$dbh->ad_catalog( $table_name, 'ThreeSharp', $file_nam
Below please find the error message, current path, code, and .pm. I'm
using active perl on win2k. I added threesharp.pm to
C:\Perl\site\lib\AnyData\Format\ with the other .pm files.
I think my path needs help. This is my first attempt at DBI code below.
What should I be looking for to add to the
Thank you so much for your help. It works well after installing the
64-bit perl.
Have a good weekend!
Fei
-Original Message-
From: BLACH Johannes [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 8:41 AM
To: Fei Zhong US-Germantown
Cc: [EMAIL PROTECTED]
Subject: Re: wrong ELF class
On Wed, 12 May 2004, JupiterHost.Net wrote:
> Ronald J Kimball wrote:
> >
> > JupiterHost.Net [mailto:[EMAIL PROTECTED] wrote:
> >
> >
> >>I found do() and quote() in DBI.pm, prepare() in DBD::mysql, but I
> >>couldn't find execute() - I wanted to see how it does the quoting
> >>exactly (for bi
Mathieu,
Sure, you can run the SQL statements in your file with DBI, but you will need to parse
the file to get all the SQL statements and then run them through the DBI interface. I
would suggest that if you need to use Perl/DBI, that you instead look at a different
method than running the SQL
Hi,
I have a really big sql scripts with many select, procedures and spool spool
off statements. I want to know how can i run this sql script with DBI.
With sqlplus, this sql script run correctly. But I don't know how can i run
this script with perl.
Can you help me?
Delaporte, Olivier wrote:
Here is the set-up:
DBD-Informix-2003.04
INFORMIX-ESQL Version 9.30.HC1 or ClientSDK 2.40
HP-UX 11.11 64 bit
Gcc 3.3.3
Perl -V:
Compiler:
cc='gcc', ccflags ='-D_POSIX_C_SOURCE=199506L -D_REENTRANT
-D_HPUX_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_S
Use trace()
Tim.
On Fri, May 14, 2004 at 04:05:44PM -0300, Pedro Anisio wrote:
> Sorry, I didnt send this part of the code
>
> @param = (2, 343520291, 1);
>
> >-MENSAGEM ORIGINAL-
> >De: "Pedro Anisio" <[EMAIL PROTECTED]>
> >Enviada em: Sex, 14 Mai 2004 16:02:14
> >Assunto: Res: Res: RE
Ron,
I have AutoCommit set on.
With DBI 1.42
this program just works if I use this, otherwise it not UPDATE the table:
$query = "update mensagem set mens_stat = 2 where mens_codigo = 343520291 and
mens_stat = 1"; prepare($query);
With DBI 1.30 it works just it is:
@param = (2,
Sorry for the last faux pas. I misread your code.
Where do you commit? Or, is AutoCommit => 1?
Is the behavior the same with both versions of DBI? Did something else change?
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Reidy, Ron
Sent: Frida
So, does this mean $msg is undef? What is the value of $sth->err or $sth->errstr?
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Pedro Anisio [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 1:02 PM
To: [EMAIL PROTECTED]
Subject: Res: RE: Probl
Sorry, I didnt send this part of the code
@param = (2, 343520291, 1);
>-MENSAGEM ORIGINAL-
>De: "Pedro Anisio" <[EMAIL PROTECTED]>
>Enviada em: Sex, 14 Mai 2004 16:02:14
>Assunto: Res: Res: RE: Problems changing from 1.30 to 1.42
>
>
>>I dont get any error on $msg but the UPDATE is not ex
I dont get any error on $msg but the UPDATE is not executed and the values on my
database dont' change.
Pedro
>-MENSAGEM ORIGINAL-
>De: "Reidy, Ron" <[EMAIL PROTECTED]>
>Enviada em: Sex, 14 Mai 2004 15:59:25
>Assunto: Res: RE: Problems changing from 1.30 to 1.42
>
>
>>What is your error
What is your error?
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Pedro Anisio [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 12:57 PM
To: [EMAIL PROTECTED]
Subject: Problems changing from 1.30 to 1.42
Guys,
I'm migrating my system fro
Guys,
I'm migrating my system from DBI 1.30 to 1.42 but I found onte little problem,
this piece off code used to worked at 1.30 but now it simple don't do this update,
unless I pass the update values directlty on the $query. What is causing this? Anyone
can help-me?
#!/usr/bin/perl
use D
[EMAIL PROTECTED] wrote:
I am using Perl's tie function to tie the DB_File to a hash. The DB_File
I don't know the answer to your question. But since you cc'd the
dbi-users list, I thought I'd let you know that, as of the most recent
release of DBI (1.42), the DBI distribution now comes with DB
Hi All,
I am running perl 5.0.6.1 on Solaris 2.9. I use DB_File v1.807 to access
Berkeley DB (i do not know which version... pl tell me how to get this).
I am using Perl's tie function to tie the DB_File to a hash. The DB_File
(.dbf) is quite a big file approx 10 MB in size with 92000 key value p
This time, with feeling ... here's the attachments.
--
Jeff
#
package AnyData::Format::Hash;
#
# copyright (c) 2000, Jeff Zucker <[EMAIL PROTECTED]>
# all rights reserved
###
Egan Ford wrote:
"This is a parser for simple name=value style Ini files. Soon it will also
handle files with sections."
Is there an update?
I'm attaching a couple of things I've got sitting around but that aren't
ready for release yet that might help you. The first works like this:
my $dbh =
>
> Hello
> After instaling the package DBI 1.42 on Mac OS X Server
> version 10.2.4 I have want to install the package DBD::ODBC
> 1.09 but I have found thise problems : -1 after entering the
> command: Perl Makefile.PL I have obtained the following
> message:
BTW, I almost skipped this mes
Hi Chrisopher,
Christopher Huhn wrote:
I'm missing the following features using DBD::CSV:
* Selecting constant values isn't working (i.e. SELECT 'xyz' FROM
table). AFAIK that's plain SQL.
Yes, it's plain SQL but not yet supported by SQL::Statement. The syntax
that is supported is listed
Hi Fei,
After installing DBI, I try to install DBD-Oracle-1.15 in my Sun Solaris
9.0 computer. My oracle is 10.g.
Oracle 10g is delivered only as 64-bit application. If you're using any
perl version you didn't compile yourself, it's a 32-bit application. You
try to mix those, you get the error
Dear all,
After installing DBI, I try to install DBD-Oracle-1.15 in my Sun Solaris
9.0 computer. My oracle is 10.g. Running perl Makefile.pl, I did not
find any special error message. But I got a following message when I run
"make and make test". Could you please help out about this issue?
On 13-May-2004 [EMAIL PROTECTED] wrote:
> Hello
> After instaling the package DBI 1.42 on Mac OS X Server version 10.2.4 I have
> want to install the package DBD::ODBC 1.09 but I have found thise problems :
> -1 after entering the command: Perl Makefile.PL I have obtained the
> following
> messa
Is there a dummy driver for DBI that basically does
nothing? Maybe a set of stubs so I could do something
like this:
use DBI;
my $dbh = DBI->connect("dbi:null", "", "");
my $sth = $dbh->prepare("SELECT * FROM mytab WHERE id = ?");
$sth->execute(3141);
while (my @vals = $sth->fetchrow_array())
Hello
After instaling the package DBI 1.42 on Mac OS X Server version 10.2.4 I have
want to install the package DBD::ODBC 1.09 but I have found thise problems :
-1 after entering the command: Perl Makefile.PL I have obtained the following
message:
-
Useless use of private
Is there a version of DBI or DBI/DBD that will connect to a MS-SQL Server
2000 database without using ODBC/DBD-ODBC?
I need to connect to MS-SQL Server from a HPUX 11.00 system that is not
configured to use ODBC data sources.
Thanks in advance..
--
Jeff Hinds - Database Specialist
Middle Tennes
On Thu, 2004-05-13 at 16:58, Jeff Hinds wrote:
> Is there a version of DBI or DBI/DBD that will connect to a MS-SQL Server
> 2000 database without using ODBC/DBD-ODBC?
>
> I need to connect to MS-SQL Server from a HPUX 11.00 system that is not
> configured to use ODBC data sources.
See FreeTDS -
31 matches
Mail list logo