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 =

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

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=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 (NOT

Re: DBI and field type 'bit'

The URL for the bug report is https://rt.cpan.org/Ticket/Display.html?id=118207=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

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

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

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

Re: DBI interaction with postgres

On Tue, Jan 4, 2011 at 8:12 AM, jankes jankes...@gmail.com 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

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 this

Re: DBI - bind_param_inout

On Mon, Oct 25, 2010 at 3:27 PM, Shlomi Fish shlo...@iglu.org.il 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

Re: DBI under SOAP/mod_perl

Hi Octavian, On 19 July 2010 06:07, Octavian Rasnita orasn...@gmail.com 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

Re: DBI under SOAP/mod_perl

Does the $dsn contain the full path to the database? -- Octavian - Original Message - From: Dermot paik...@gmail.com To: Perl Beginners beginners@perl.org 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

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

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-errno . - .

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/Mysql.pm says

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 maillog LIMIT 10;; my

Re: DBI fetchall_arrayref

On Fri, Feb 27, 2009 at 08:43, David Shere dsh...@steelerubber.com 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

Re: DBI fetchall_arrayref

Chas. Owens wrote: On Fri, Feb 27, 2009 at 08:43, David Shere dsh...@steelerubber.com 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

Re: DBI and SQLite efficiency

From: Southworth, Harry harry.southwo...@astrazeneca.com 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

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 WHERE

RE: DBI and SQLite efficiency

From: Southworth, Harry harry.southwo...@astrazeneca.com 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[$_]}

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 create

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-do(ALTER

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 without

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

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 : use DBI; my

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_source ( mysql ) ; The

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 : use DBI; my $dbh

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 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

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 be

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 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 transaction.

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; my

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

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-prepare('update

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. Probably

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;

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,

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 quoting

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 ^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 long

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 DB2.

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 { #some

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 similar

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 replacing 'use

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); Note

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

[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

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 whatever' I have the following script more or less

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 mailto:[EMAIL PROTECTED] 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

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 mailto:[EMAIL PROTECTED] 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 -- Mobile

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 mailto:[EMAIL PROTECTED] 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 the

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: beginners@perl.org Sent: Tuesday, December 13, 2005 09:30 AM Subject: DBI problem Hi all- I'm attempting to loop thru

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

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

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 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).

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

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

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 one of

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: beginners@perl.org Sent: Sunday, July 10, 2005 18:09 PM

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 INTO

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

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 =

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

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, but

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 with an

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 program

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 database

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/null Issuing

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 - 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

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 -- To

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

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] wrote

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

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 scripts. The error

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 -

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= $dump_dir\/$names;

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(); Can't call method

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

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

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 returned

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; $self-{$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 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 http://search.cpan.org/search?query=firebirdmode=all the second hit is subtitled DBI driver for Firebird (then it goes on to mention

RE: DBI Install

-Original Message- From: Witzke, Rob [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 3:30 PM To: [EMAIL PROTECTED] Subject: DBI Install ... /bin/sh: /opt/SUNWspro/bin/cc: not found make: *** [Perl.o] Error 1 Your compiler was not found ... José. DISCLAIMER

Re: DBI Install

On Wed, 4 Aug 2004, Witzke, Rob wrote: I am trying to install DBI on a Sun Solaris box but am running into problems. Have you tried using the CPAN shell? If you have it available, it's *much* easier than the way you're trying it. $ sudo perl -MCPAN -e shell cpan shell -- CPAN

RE: DBI Install

, August 04, 2004 10:29 AM To: Witzke, Rob Cc: PerlBeginners (E-mail) Subject: RE: DBI Install On Wed, 4 Aug 2004, Witzke, Rob wrote: Well, it seems that I don't have a c compiler loaded. (I thought that I did) That'll slow you down :-) Is is possible to get the DBI stuff pre-compiled? Maybe

RE: DBI Install

On Wed, 4 Aug 2004, Witzke, Rob wrote: Well, it seems that I don't have a c compiler loaded. (I thought that I did) That'll slow you down :-) Is is possible to get the DBI stuff pre-compiled? Maybe, but DBI is often available with Perl itself. Have you verified that you don't already have it?

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 ran your command $ perl -MDBI -e '1' and got no results

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

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

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

RE: DBI Install

; 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 grab gcc and start installing DBI. You

  1   2   3   >