Re: DBI and hosts file entries

Hi, According to my experience with DBD::Sybase + Freetds, the name resolution is done for the host names specified in the freetds.conf file. The following code will try to create an handler object for the host+port specified in the [ENGINEERING] section of the freetds.conf file $dbh = DBI->conn

Re: DBI and hosts file entries

Hi Paul, I'm going to assume you're on a Linux system. I have exactly that configuration on my system (name to ip address mapping in /etc/hosts) and here's my understanding of how it's supposed to work: DBI uses a database driver (DBD). DBD uses the database client libraries. In my case MyS

Re: DBI and hosts file entries

first you want to be sure that your host can connect to the remote host onn the right port. You can use the telnet command to do that telnet server port where server is the name for the server in your /etc/hosts file and port is the port number on the remote where sybase is listening. iirc

Re: DBI and field type 'bit'

Chas. Owens schrieb: The URL for the bug report is https://rt.cpan.org/Ticket/Display.html?id=118207&results=52bad5c05e442e5750731e7011056012 Thank you very much! I resorted to use an integer instead of a bitfield, and it works fine with things like ... SET `status` = `status` + 32 WHERE (N

Re: DBI and field type 'bit'

The URL for the bug report is https://rt.cpan.org/Ticket/Display.html?id=118207&results=52bad5c05e442e5750731e7011056012 On Sat, Oct 1, 2016 at 11:44 AM Chas. Owens wrote: > Poking around in the source, it does not appear to be well tested WRT bind > variables (see the test file below). I will

Re: DBI and field type 'bit'

Poking around in the source, it does not appear to be well tested WRT bind variables (see the test file below). I will file a bug at https://rt.cpan.org/Public/Dist/Display.html?Name=DBD-mysql but I wouldn't hold my breath on seeing anything other than a documentation change. There is probably to

Re: DBI and field type 'bit'

Whoops, meant to include links for the docs to those two functions: http://perldoc.perl.org/functions/pack.html http://perldoc.perl.org/functions/vec.html On Sat, Oct 1, 2016 at 11:31 AM Chas. Owens wrote: > DBD::mysql is treating 1 and 3 as their ASCII values on insert due to > quoting. You n

Re: DBI and field type 'bit'

DBD::mysql is treating 1 and 3 as their ASCII values on insert due to quoting. You need to create values that are bit fields themselves. This being Perl, there are lots of ways of doing that: $dbh->do("create table bittest (lilbits bit(8))"); my $insert = $dbh->prepare("insert into bittest valu

Re: DBI interaction with postgres

On Tue, Jan 4, 2011 at 8:12 AM, jankes wrote: > my $nowe = $generuj->fetchrow_array; I haven't had the pleasure of using DBI yet, but CPAN says to exercise caution when using fetchrow_array in scalar context. Perhaps you should switch to list context. Either way, check the status of $generuj->err

Re: DBI - bind_param_inout

On Mon, Oct 25, 2010 at 3:27 PM, Shlomi Fish wrote: > 2. $bind_value is the variable where you want to supply and receive the value. > You need to take a reference to it so it can be modified. I imagine she knows this already, but I believe the stored procedure's parameter will need to be marked

Re: DBI - bind_param_inout

Hi Nora, On Monday 25 October 2010 10:05:05 HACKER Nora wrote: > Hi list, > > I have a sql package which returns a value after execution. I figured > out that, when calling this package from Perl, I need a bind parameter > (http://search.cpan.org/~timb/DBI-1.615/DBI.pm#bind_param_inout) that > th

Re: DBI under SOAP/mod_perl

Hi Octavian, On 19 July 2010 06:07, Octavian Rasnita wrote: > Does the $dsn contain the full path to the database? Yes. The dsn line is declared like this: DBI SQLite3 ### my $dsn = 'dbi:SQLite:dbname=/var/db/MyApp/myapp.db'; It's outside the constructor which I am not sure is good prac

Re: DBI under SOAP/mod_perl

Does the $dsn contain the full path to the database? -- Octavian - Original Message - From: "Dermot" To: "Perl Beginners" Sent: Friday, July 16, 2010 7:29 PM Subject: DBI under SOAP/mod_perl Hello All, (This is perl, v5.8.8). Sorry if this is a bit specialised (EG not v. beginner

Re: DBI escape_string

your last field included in the query ('msg') has an apostrophe in the middle of the text, as well as not be closed with a single quote before the entire string is closed with the double quote. you can't include an unescaped single quote inside a single-quoted string, nor can you include an unesca

Re: DBI driving me nuts ... !

Have you tried to print @row? #!/usr/bin/perl use Mysql; $dbh = Mysql->connect("localhost"," > > mailscanner","root","c0nc3pt") or > die ("Error " . Mysql->errno . " - " . Mysql->errstr); > $sql = "SELECT to_address FROM maillog LIMIT 10;"; > $sth = $dbh->query($sql) or die ("Error " . Mysql->e

Re: DBI driving me nuts ... !

> Please can you advise ? > > #!/usr/bin/perl > > use Mysql; > > $dbh = Mysql->connect("localhost","mailscanner","root","c0nc3pt") or > die ("Error " . Mysql->errno . " - " . Mysql->errstr); > ... I do not see any DBI in here. Though ... http://search.cpan.org/~capttofu/DBD-mysql- 3.0008/lib/M

Re: DBI driving me nuts ... !

Gregory Machin wrote: > Hi > Please can you advise ? > > #!/usr/bin/perl use strict; use warnings; > > use Mysql; > > $dbh = Mysql->connect("localhost","mailscanner","root","c0nc3pt") or > die ("Error " . Mysql->errno . " - " . Mysql->errstr); my $dbh = ... > $sql = "SELECT to_address FROM m

Re: DBI fetchall_arrayref

Chas. Owens wrote: On Fri, Feb 27, 2009 at 08:43, David Shere wrote: The following sub uses "fetchall_arrayref" in the DBI module to put the results of an SQL command into an array, where each element of the array is a hash of that records name/value pairs. The documentation says to pass it a

Re: DBI fetchall_arrayref

On Fri, Feb 27, 2009 at 08:43, David Shere wrote: > The following sub uses "fetchall_arrayref" in the DBI module to put the > results of an SQL command into an array, where each element of the array > is a hash of that records name/value pairs.  The documentation says to > pass it a reference to a

Re: DBI and SQLite efficiency

Southworth, Harry wrote: > I have a database with several tables in it, and each table contains data on > lots of people. From one run of my program to the next, the tables could > change, so my code needs to be fairly general. > > I want to pull the data for each person from each table, and cre

RE: DBI and SQLite efficiency

From: "Southworth, Harry" > I think that if I append (rather than overwrite) each report with each > table, I could restructure the code like you suggest. Thanks for > pointing that out - it hadn't occurred to me. > > > my %sth; > > for (0..$#tables){ > > $sth{$tables[$_]} = $dbh->prepare( > >

RE: DBI and SQLite efficiency

Thanks. I think that if I append (rather than overwrite) each report with each table, I could restructure the code like you suggest. Thanks for pointing that out - it hadn't occurred to me. > my %sth; > for (0..$#tables){ > $sth{$tables[$_]} = $dbh->prepare( >"SELECT * FROM $theTable WHER

Re: DBI and SQLite efficiency

From: "Southworth, Harry" > I have a database with several tables in it, and each table contains > data on lots of people. From one run of my program to the next, the > tables could change, so my code needs to be fairly general. > > I want to pull the data for each person from each table, and cr

Re: DBI: Add column to mysql table

On Sat, Dec 6, 2008 at 20:23, hotkitty <[EMAIL PROTECTED]> wrote: > Hi, > > I am using DBI to add a column to my existing table, goodtable. W/ a > phpmyadmin I can add a column w/ a numeric or nonnumeric label. Using > perl DBI, I can only add a column w/ a nonnumeric label, as follows: > > $dbh->d

Re: DBI equivalent of Oraperl ora_titles function !

On Tue, Aug 5, 2008 at 6:06 PM, Peter Scott <[EMAIL PROTECTED]> wrote: > On Tue, 05 Aug 2008 09:38:41 +0530, Amit Saxena wrote: > > > What's the DBI equivalent of Oraperl ora_titles function ? > > > > I need it because I want to get the titles (column names) of a select > query > > into an array w

Re: DBI equivalent of Oraperl ora_titles function !

On Tue, 05 Aug 2008 09:38:41 +0530, Amit Saxena wrote: > What's the DBI equivalent of Oraperl ora_titles function ? > > I need it because I want to get the titles (column names) of a select query > into an array without fetching the row values from the database. I believe you want the NAME state

Re: DBI error

Ah! Yes!! Thank you very much!! Problem fixed now =) 2008/7/22 Rob Dixon <[EMAIL PROTECTED]>: > > Panda-X wrote: > > > > I've got this error, anything I can do ? > > > > "Can't locate auto/DBI/data_source.al in @INC " > > > > Code : > > > >use DBI; > >my @dataSource = DBI -> data_

Re: DBI error

Panda-X wrote: > > I've got this error, anything I can do ? > > "Can't locate auto/DBI/data_source.al in @INC " > > Code : > >use DBI; >my @dataSource = DBI -> data_source ( "mysql" ) ; The method call is DBI->data_sources('mysql'); > and if I change the as this : > > us

Re: DBI error

On Tue, Jul 22, 2008 at 9:18 AM, Panda-X <[EMAIL PROTECTED]> wrote: > Hi, > > I've got this error, anything I can do ? > > "Can't locate auto/DBI/data_source.al in @INC " > > Code : > > use DBI; > my @dataSource = DBI -> data_source ( "mysql" ) ; > > and if I change the as this : > >u

Re: DBI install

Hi, if you don't have internet connection, the easy form is downloading the module via cpan. http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.605.tar.gz later you have to decompress it with : $ tar -xzvf DBI-1.605.tar.gz # cd DBI... # perl Makefile.PL # make && make install can do the wo

Re: DBI install

On Tue, Jul 1, 2008 at 8:39 PM, <[EMAIL PROTECTED]> wrote: > Can any one help me out in Installing DBI in a standalone box. There is no > internet connetion. I tried downloading DBI-1.48 module and tried using ppm > and makefile.PL its not working. I am doing it correct or missing something? >

Re: DBI Integrated Security

From: "HESTER, CHRISTOPHER" <[EMAIL PROTECTED]> > I'm trying to connect to a MSSQL 2000 database using integrated security > and am not having any success. My understanding is that you only need to > call DBSETLSECURE before you call dblogin, as in my example below, but > it doesn't even attempt to

Re: DBI question

Ken Foskey wrote: > On Wed, 2008-05-21 at 23:53 +1000, Ken Foskey wrote: >> I have a program that will run literally for days and days. It monitors >> logs by file tail. Problem is that I think the DBI is causing problems. >> It is constantly connecting and reconnecting to DB2 for every >> transa

Re: DBI question

On Wed, 2008-05-21 at 23:53 +1000, Ken Foskey wrote: > I have a program that will run literally for days and days. It monitors > logs by file tail. Problem is that I think the DBI is causing problems. > It is constantly connecting and reconnecting to DB2 for every > transaction. The original did

Re: DBI prepare syntax

Perl is Awsome! Thanks for explaining that basic concept to me Douglas! Douglas Hunter <[EMAIL PROTECTED]> wrote: Mike wrote: > Hi, > > I have a variable setup as $pid and i've tried to call this in the prepare > part of the DBI module but i'm get an "Unknown column $pid" syntax error. > Pr

Re: DBI prepare syntax

Mike wrote: Hi, I have a variable setup as $pid and i've tried to call this in the prepare part of the DBI module but i'm get an "Unknown column $pid" syntax error. Probably $pid was passed as a string instead of a variable inside the prepare (''). Anyone has an idea of how i can fix this?

Re: DBI prepare syntax

That was a rookie mistake :). Double quotes works, thanks Beginner! Beginner <[EMAIL PROTECTED]> wrote: On 8 Nov 2007 at 8:59, Mike wrote: > Hi, > > #Update override_exclude set th_flag="N" to indicate that thesaurus entries > #have been added to sierra2_thesaurus.xml > > use DBI; >

Re: DBI prepare syntax

On 8 Nov 2007 at 8:59, Mike wrote: > Hi, > > #Update override_exclude set th_flag="N" to indicate that thesaurus entries > #have been added to sierra2_thesaurus.xml > > use DBI; > my $dbh = DBI->connect("dbi:mysql:endeca_tracking",$user,$password); > my $sth = $dbh->prep

Re: DBI, postgresql and large table

Chas Owens wrote: On 6/27/07, Andrej Kastrin <[EMAIL PROTECTED]> wrote: Dear all, I need to process postgresql table with DBI module. The script below works well for small tables, but when I want to process larger tables (10 rows) out-of-memory occurs. Any suggestion? Thanks in advance, An

Re: DBI, postgresql and large table

On 6/27/07, Andrej Kastrin <[EMAIL PROTECTED]> wrote: Dear all, I need to process postgresql table with DBI module. The script below works well for small tables, but when I want to process larger tables (10 rows) out-of-memory occurs. Any suggestion? Thanks in advance, Andrej use strict; u

Re: DBI::execute(): how to evade quoting identifier names

Bram Kuijper am Dienstag, 2. Januar 2007 18:07: > Hi all, Hello Bram Kuijper > I try to execute the following SQL query in PostGreSQL 8.1. However, it > gives errors since DBI::execute() automatically quotes when it inserts > its arguments into the SQL query. Is there any way to change the quot

Re: dbi ^C handling

On Sunday 08 October 2006 13:51, Ken Foskey wrote: > I killed my update script with the DBI and it left the DB2 connection > hanging so I could not rerun until the DBA killed the thread the next > working day. Was it a long-running operation? I've found that if you issue a command that takes a lon

Re: dbi ^C handling

>I killed my update script with the DBI and it left the DB2 connection >hanging so I could not rerun until the DBA killed the thread the next >working day. > >What is the preferred handling for killing scripts like this so they >clean up connections? It's a little strange that when you kill your

Re: DBI - DB2 Perl Script ... TWiki

[EMAIL PROTECTED] wrote: > Hi all, Hello, > I have this script that am trying to use to connect to DB2. > > At the moment I cannot get the script to connect to DB2. > > In the UNIX prompt, if I run . /home/db2inst1/sqllib/db2profile first and then > run the Perl script, then I can connect to DB

RE: DBI type mismatch

On Tue, 2006-08-01 at 10:13 -0500, Charles K. Clarkson wrote: > Bjørge Solli wrote: > > : I get an error message I don't understand. I've been following > : what I thought was good practice when talking to a DB. > > Did you import those constants? > > use DBI qw(:sql_types); I have a simil

Re: DBI

On Tuesday 01 August 2006 17:04, Greg Sabino Mullane wrote: > You need to tell DBI to import the SQL type constants. This is done by > replacing 'use DBI;' above with: > > use DBI qw(:sql_types); Do I have to do something similar to get the below to work? use strict; my $insertid; ... eval { #s

Re: DBI

On Tuesday 01 August 2006 17:04, Greg Sabino Mullane wrote: > > use strict; > > use DBI; > > $sth->bind_param( 1, \$insertid, SQL_INT); #insertid from other > > insertion $sth->bind_param( 2, \$ap, SQL_DOUBLE); > > You need to tell DBI to import the SQL type constants. This is done by > rep

Re: DBI

[EMAIL PROTECTED] (Bjørge Solli) writes: > Hi, > > I get an error message I don't understand. I've been following what I > thought was good practice when talking to a DB. > > use DBI; Import :sql_types tag. use DBI qw/:sql_types/; -- Radek -- To unsubscribe, e-mail: [EMAIL PROTECTED] For addi

RE: DBI

Bjørge Solli wrote: : I get an error message I don't understand. I've been following : what I thought was good practice when talking to a DB. Did you import those constants? use DBI qw(:sql_types); HTH, Charles K. Clarkson -- Mobile Homes Specialist Free Market Advocate Web Programmer

Re: DBI

> use strict; > use DBI; > $sth->bind_param( 1, \$insertid, SQL_INT); #insertid from other > insertion > $sth->bind_param( 2, \$ap, SQL_DOUBLE); You need to tell DBI to import the SQL type constants. This is done by replacing 'use DBI;' above with: use DBI qw(:sql_types); No

Re: DBI::AnyData problem

On Sunday 26 March 2006 18:58, Stephen Day wrote: > I have perl, v5.8.7 built for i686-linux running on gentoo. > I've installed the DBI::AnyData modules ( DBI, SQL::Statement, DBD::CSV, > AnyData, DBD::AnyData ) with perl -e 'use CPAN; install ' > > I have the following script more or less copie

Re: DBI/SQL question

Robert Hicks wrote: I have a large array of numbers that I need to use in an update SQL statement using a "like" clause. my @nums = ( 123 456 789 ); foreach my $num (@nums) { $dbh->do(q{update table_name set item_desc1 = item_desc2 where equip like # I draw a blank here } I am not sure

RE: DBI problem

john wrote: : Thanks, Charles, for your suggestions. I think I've incorporated : most of them. You're welcome. : Your regex is a lot more practical than what I was using. I wouldn't have used it a year ago. Perhaps I'm getting better. :) : Here is the impro

Re: DBI problem

Thanks, Charles, for your suggestions. I think I've incorporated most of them. Your regex is a lot more practical than what I was using. Here is the improved script. I can live with the one warning "Newline in left-justified string for printf at ./describe_skus.pl line 29". John #!/usr/bin/perl

RE: DBI problem

john wrote: : Yes, you're right. I changed this line: : while ((my $ref) = $sth2 ->fetchrow_hashref("$num")) {... : by removing the parameter, and quotes around 'my $ref' : : while (my $ref = $sth2 ->fetchrow_hashref()) {... : and the script works now. For t

Re: DBI problem

At 11:07 PM 12/13/05, john wrote: I can't see it in emacs. Then my guess was off-base. What do you mean by "dump the last line of the file in binary"? Sounds like something I need to learn about. tail -2 filename | cat -v -v Displays non-printing characters so they are visible. --

RE: DBI problem

john wrote: : I can't see it in emacs. : What do you mean by "dump the last line of the file in binary"? I don't use emacs, but if you open the file in a hex editor you can view each character and see how your lines and files end. HTH, Charles K. Clarkson -- Mob

Re: DBI problem

Frank, I can't see it in emacs. What do you mean by "dump the last line of the file in binary"? Sounds like something I need to learn about. John Frank Bax wrote: At 02:30 AM 12/13/05, john wrote: I'm attempting to loop thru an input file, executing a SELECT query with the value from each

Re: DBI problem

Teddy, Yes, you're right. I changed this line: while ((my $ref) = $sth2 ->fetchrow_hashref("$num")) {... by removing the parameter, and quotes around 'my $ref' : while (my $ref = $sth2 ->fetchrow_hashref()) {... and the script works now. Thanks for your help. John Octavian Rasnita wrote:

Re: DBI problem

At 02:30 AM 12/13/05, john wrote: I'm attempting to loop thru an input file, executing a SELECT query with the value from each line. The script works for the first iteration, and then gives these error messages: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at ./describe_s

Re: DBI problem

Hi, As far as I know, the method fetchrow_hashref doesn't require a parameter (like fetchall_hashref). Teddy - Original Message - From: "john" <[EMAIL PROTECTED]> To: Sent: Tuesday, December 13, 2005 09:30 AM Subject: DBI problem > Hi all- > I'm attempting to loop thru an input file,

Re: DBI fetch

Peter Scott wrote: On Sat, 27 Aug 2005 14:07:09 +0300, Octavian Rasnita wrote: What do you think, if the most important is the speed, which method is recommended to get the results of a DBI query? fetchrow_arrayref or fetchrow_array (I guess that fetchrow_hashref has the lowest speed). Tha

SOLUTION (was Re: More re: DBI::Proxy failure)

On Mon, Sep 12, 2005 at 12:44:43PM -0400, Mason Loring Bliss wrote: > Mon Sep 12 12:37:03 2005 err, 1, Refusing client So, this was, indeed, PostgreSQL refusing the connection, and not a DBI issue at all. This was masked by DBI::ProxyServer returning a "user could not authenticate" error even wit

More re: DBI::Proxy failure

It seems that when I have dbiproxy log to the terminal, it gives more information, which hopefully will be of some use: Mon Sep 12 12:37:03 2005 err, 1, Error while connecting to DBI:Pg:dbname=oracle as mason: DBI::ProxyServer connect('dbname=oracle','mason',...) failed: FATAL: IDENT authentica

Re: DBI fetch

On Sat, 27 Aug 2005 14:07:09 +0300, Octavian Rasnita wrote: > What do you think, if the most important is the speed, which method is > recommended to get the results of a DBI query? > > fetchrow_arrayref > or > fetchrow_array > > (I guess that fetchrow_hashref has the lowest speed). That wasn't

Re: DBI insert vs update question

Peter Rabbitson wrote: > Hello everyone, > I want someone to share his expertise on the following: > Suppose we have a table with some data that periodically must be synced > with an external source, which provides only partial information (e.g. > it might provide all the fields for a new record,

Re: DBI insert vs update question

Below is taken from: http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm Also look at: http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html Prepared statement support (server side prepare) To use server side prepared statements, all you need to do is set the variabl

Re: DBI insert vs update question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey Peter, Are you sure about that? As far as I understand, what you say you can't do, is to have two prepares for example: my $dbh = DBI->connect("dbi:mysql:database","user","pass"); my $foo = $dbh->prepare("SELECT * FROM ."); my $bar = $dbh->

Re: DBI insert vs update question

> I'm sure others will give you more informed answers.. But why can't > you create multiple statement handlers under the same connection? > Because you can't. One connection holds only one prepared statement (at least in MySQL). If you prepare $statement2 on the same $dbh, $statement1 automati

Re: DBI insert vs update question

On Sun, Jul 10, 2005 at 06:23:19PM +0300, Octavian Rasnita wrote: > Can't you use the replace sql query? > > Use it like you use "insert". It will insert new rows where there are no > rows, and do an update where there are rows... > Negative. REPLACE is just a shortcut for DELETE FROM... INESERT

Re: DBI insert vs update question

Can't you use the replace sql query? Use it like you use "insert". It will insert new rows where there are no rows, and do an update where there are rows... Teddy - Original Message - From: "Peter Rabbitson" <[EMAIL PROTECTED]> To: Sent: Sunday, July 10, 2005 18:09 PM Subject: DBI ins

Re: DBI, duplicates

Ing. Branislav Gerzo [IBG], on Tuesday, June 14, 2005 at 21:10 (+0200) thinks about: IBG> my ($id) = $dbh->selectrow_array("select id from IBG> db_url where id = ?", {}, $url); ahm, maybe I'm too tired or blind, don't see that - I have error in select statement :) -- ...m8s, cu l8r,

Re: DBI + XML::Twig conflict (?)

Peter Rabbitson wrote: >>Thank you. No guarantees, but try setting 'InactiveDestroy' when you >>create the DB handle. XML::Twig uses a fork/exec call in 'parseurl' to >>retrieve the URL in one process and to parse the XML in the other. When >>the retrieval is complete one of the processes closes wi

Re: DBI + XML::Twig conflict (?)

> Thank you. No guarantees, but try setting 'InactiveDestroy' when you > create the DB handle. XML::Twig uses a fork/exec call in 'parseurl' to > retrieve the URL in one process and to parse the XML in the other. When > the retrieval is complete one of the processes closes with an 'exit'. I > think

Re: DBI + XML::Twig conflict (?)

Peter Rabbitson wrote: >>>If I run the real program I end up stuffing about 480 out of roughly 510 >>>products into a designated table and then the handle goes out to lunch with >>>the same error message. >> >>What's the error message? >> > > > Ups... I guess I missed that: > > ~$ ./test > /dev/

Re: DBI + XML::Twig conflict (?)

> > If I run the real program I end up stuffing about 480 out of roughly 510 > > products into a designated table and then the handle goes out to lunch with > > the same error message. > > What's the error message? > Ups... I guess I missed that: ~$ ./test > /dev/null Issuing rollback() for dat

Re: DBI + XML::Twig conflict (?)

Please don't cross post. Peter Rabbitson wrote: > I have a strange problem where a database handle is being destroyed for no > apparent reason. My initial idea was to parse some xml, and translate it > into a database. Deleting line after line of code I came up with this short > meaningles prog

Re: DBI - SELECT by Date

Am Donnerstag, 5. Mai 2005 22.46 schrieb Diogo Nunes de Oliveira: > Hi all, Hi Diogo > I´m having quite a problem here... My script works with postgree. Now i > want to get a result from a date range... But I just can´t get it done... > Explaining... Let´s supose I want to get all registers from

RE: DBI object version 1.32 does not match $DBI::VERSION 1.48

: Wednesday, April 06, 2005 8:42 AM To: Christopher L. Hood Cc: Perl Beginners List Subject: Re: DBI object version 1.32 does not match $DBI::VERSION 1.48 On Wed, 6 Apr 2005 [EMAIL PROTECTED] wrote: > I have upgraded DBI to version 1.48 and I am now having issues and > errors with my script

RE: DBI object version 1.32 does not match $DBI::VERSION 1.48

[EMAIL PROTECTED] wrote: > 1. Why does CPAN only make the module directories accessible only by > root ? (permissions set to 700 ) It's probably just respecting your umask. Is your umask 077? It needs to be something like 022 instead. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional c

RE: DBI object version 1.32 does not match $DBI::VERSION 1.48

on is installed? Chris Hood  -Original Message- From: Chris Devers [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 2005 8:42 AM To: Christopher L. Hood Cc: Perl Beginners List Subject: Re: DBI object version 1.32 does not match $DBI::VERSION 1.48 On Wed, 6 Apr 2005 [EMAIL PROTECTED]

Re: DBI object version 1.32 does not match $DBI::VERSION 1.48

On Wed, 6 Apr 2005 [EMAIL PROTECTED] wrote: > I have upgraded DBI to version 1.48 and I am now having issues and > errors with my scripts. The error that I am getting is : How did you do the upgrade? It looks like you have remnants of the old version still installed. -- Chris Devers -- T

RE: DBI query

mike wrote: > Anyone got any any idea what is happening here > > $dbh=DBI->connect("dbi:Pg:dbname=data_cc",$user,$pw); > $dump_dir='/home/data_cc/dump'; > @names=$dbh->tables(); > #$dbh->execute; > #print @names; > foreach $names(@names){ > if (substr($names,0,9) eq "public.tb") > { > $file1= "$du

Re: DBI query

Hi mike Am Montag, 14. März 2005 18.38 schrieb mike: > Anyone got any any idea what is happening here Apart from your actual problem, it happens that the coding below will give big chances to have undetected or hard to find errors. - use "use strict; use warnings;" at the top of the code - decl

RE: DBI problem

mike wrote: > I have the following query which works in psql > > SELECT to_char('05 Feb 2005'::date,'-MM-DD') > > However when I run it in DBI I get > > $row6=$dbh->prepare("SELECT > to_char('2005-02-05'::date,'-MM-DD')"); > #$row6->bind_param(1,'2005-02-05'); $row6->execute(); > > > C

Re: DBI hashref with multiple db rows

> >> > I have created a module, and inside one of the Package methods, I > >> have > >> > the following code: > >> > > >> > $href = $getPlanInfo->fetchrow_hashref(); > >> > foreach my $key (keys %$href) { > >> > print "$key : $href->{$key}\n"; > >> > $name =

Re: DBI hashref with multiple db rows

>> > I have created a module, and inside one of the Package methods, I >> have >> > the following code: >> > >> > $href = $getPlanInfo->fetchrow_hashref(); >> > foreach my $key (keys %$href) { >> > print "$key : $href->{$key}\n"; >> > $name = $key; >> >

Re: DBI hashref with multiple db rows

Please bottom post > Steve > > You may want to think of this from a DB perspective. > > Is there a unique key associated with each of these lookups that could prevent duplicate rows being returned? If you are looking up info for a particular person, I would assume you would only want 1 retu

Re: DBI hashref with multiple db rows

> Steve > > You may want to think of this from a DB perspective. > > Is there a unique key associated with each of these lookups that could > prevent duplicate rows being returned? If you are looking up info for > a particular person, I would assume you would only want 1 returned and > you would wa

Re: DBI hashref with multiple db rows

Steve You may want to think of this from a DB perspective. Is there a unique key associated with each of these lookups that could prevent duplicate rows being returned? If you are looking up info for a particular person, I would assume you would only want 1 returned and you would want a key wi

Re: DBI for FireBird

On 20 Aug 2004, at 11:03, Cristi Ocolisan wrote: Can anybody tell me something about a DBI for FireBird? I looked on CPAN, but didn't find any. When I go to the second hit is subtitled "DBI driver for Firebird" (then it goes on to mention In

RE : DBI Install

> -Message d'origine- > De : Witzke, Rob [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 4 août 2004 19:36 > À : Bob Showalter; PerlBeginners (E-mail) > Objet : RE: DBI Install > > Unfortunately, this does indeed seem to be the case and I can't rebuild

RE: DBI Install

On Wed, 4 Aug 2004, Witzke, Rob wrote: > Witzke, Rob wrote: > > Unfortunately, this does indeed seem to be the case and I can't > > rebuild perl without jeopardizing our primary system > > You can build a second copy of Perl and point to that for your DBI > scripts by changing the shebang line...

RE: DBI Install

Witzke, Rob wrote: > Unfortunately, this does indeed seem to be the case and I can't > rebuild perl without jeopardizing our primary system You can build a second copy of Perl and point to that for your DBI scripts by changing the shebang line... -- To unsubscribe, e-mail: [EMAIL PROTECTED] For

RE: DBI Install

That would be great. Where can I find the instructions for that? Rob -Original Message- From: Bob Showalter [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 2:49 PM To: Witzke, Rob; PerlBeginners (E-mail) Subject: RE: DBI Install Witzke, Rob wrote: > Unfortunately, this d

RE: DBI Install

, Rob; PerlBeginners (E-mail) Subject: RE: DBI Install Witzke, Rob wrote: > Well, it seems that I don't have a c compiler loaded. (I thought > that I did) As others have pointed out, you need a C compiler to install some modules. However, I'm pretty sure you can't just "gra

RE: DBI Install

Witzke, Rob wrote: > Well, it seems that I don't have a c compiler loaded. (I thought > that I did) As others have pointed out, you need a C compiler to install some modules. However, I'm pretty sure you can't just "grab gcc" and start installing DBI. You need to build modules with the same com

RE: DBI Install

On Wed, 4 Aug 2004, Witzke, Rob wrote: I ran your command $ perl -MDBI -e '1' and got no results so I guess that is a good thing. Yeah, that means you already have DBI. Now you just need DBD drivers for the database[s] you need. I will be looking into getting a c compiler. Any suggestions? GCC is

RE: DBI Install

--howdy: --wouldn't it be better if you went to http://www.sunfreeware.com --and snagged a compiler (gcc works, i believe) - i'm sure you'll use it --for other stuff in the future anyways ... --*shrug* --just my $0.02 cents ... -X -Original Message- From: Witzke, Rob [mailto:[EMAIL PR

RE: DBI Install

> -Original Message- > From: Witzke, Rob [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 04, 2004 4:32 PM > To: Chris Devers > Cc: PerlBeginners (E-mail) > Subject: RE: DBI Install > > > Chris, > > Thank you very much for you help. > > I r

  1   2   3   >