Re: DBD::mysql 4.024 Released

inspect perl/site/lib/DBD/mysql.pm, I see that it says $VERSION = '4.024'. I'm not sure what to think. Was the new version actually installed? (Previous was 4.022.) Or is the installation mixed up in some way? How can I tell for sure? Thanks for any light you can shed on this. Robert Dodier PS

looking for a patch or workaround for err / errstr bug

$VERSION = '4.022' in it. Does anyone know of a patch or workaround for bug #71555? Thanks for any advice. best, Robert Dodier

Re: Trying to use perl to call oracle stored proc to return an object.

; $sth-execute(); Hoping it is something really simple. Thanks for any help E. Scott Stricker @ Work -- Robert Durgin Sr. Software Engineer Texterity • 144 Turnpike Road Southborough , MA 01772 rdur...@texterity.com www.texterity.com

RE: DBD::ADO Crashes on Fork

. Bob -Original Message- From: Steffen Goeldner [mailto:sgoeld...@cpan.org] Sent: Thursday, April 14, 2011 10:39 AM To: Robert Boisvert Cc: dbi-users@perl.org Subject: Re: DBD::ADO Crashes on Fork Robert Boisvert wrote: I'm working on a project to connect to a SQLExpress database

DBD::ADO Crashes on Fork

process terminates (see program snippet below). Is my code in error or is there something amiss with the ADO/DBI drivers? I appreciate whatever assistance you can provide, Robert Boisvert Business Analyst SYNCHRONOSS TECHNOLOGIES (m) 908-745-1268 (aim) robert.boisv...@synchronoss.com robert.boisv

Re: DBD-CSV taint mode

Does an open(FILE, '', $csvfile) works right before a CUD-operation? If not, move this open()-call step by step to the top of Your script to catch the point where the tainted data enters. BTW: if Your filename is composed from tainted bits it is tained too. greetings Robert -- Am

Re: Error on Make command - gcc: odule_wrap.o: No such file or directory

It looks like a typo to me. Have You tried to look for module_wrap.*? Greetings Robert Am 24.11.2010 19:56, schrieb Mike Towery: Here is what I get when I do that. [r...@l2rac2 DBI-1.615]# gcc -shared -L/usr/local/lib odule_wrap.o -o blib/arch/auto/odule/module.so gcc: odule_wrap.o

Re: How to connect DBI module in my local server

http://search.cpan.org/~timb/DBI/DBI.pm#DESCRIPTION Greetings Robert

Re: DBI and DBD Installation on Different Unix (Solaris, AIX, HP and Linux)

DBD (or any other module) You like to install and continue. For example: $ perl -MCPAN -e install 'DBD::SQLite' This will work on any system, not only on Unixes. But of course only for modules hosted on CPAN. Greetings Robert

Re: need help on $sth-bind_param

}. The SQL_INTEGER and other related constants can be imported using use DBI qw(:sql_types); /citation For the possible values of $bind_type look in the code of DBI.pm for 'sql_types'. Greetings Robert

Re: What is the meaning of the return value from a DBI do statement?

be the way? And would this other way handle updates as well? The problem is that You check the return value of $sth-execute() ... Greetings Robert

Re: 'AllTables' method in DBIx:.Database returns nothing with CSV files

Did you tried it with an absolute path to f_dir? Greetings Robert -- ozarfreo schrieb: I am using DBIx::Recordset to access a directory with CSV files, and the method DBIx::Database-AllTables seems to return just an empty hash reference. I'm talking about the following code: use DBIx

Re: Help needed.

Can You show us the part of the code which have the problem. Try to minimise Your program to the problematic core. Greetings Robert --- Agarwal, Gopal K schrieb: Hi, I am connecting the Oracle DB with perl DBI. For short queries (execution time 2 sec) I am able to fetch the data

Re: DBD version for Sybase 15

The latest Version of DBD::Sybase is 1.09 (at CPAN). You should try this. By the way: What went wrong while installing or running Your program? Greetings Robert kanisorn.inthac...@dstglobalsolutions.com schrieb: Hi There, I'm looking to run the perl script on the Windows 2003 server

Re: Info needed about version compatibility

Have a look at http://matrix.cpantesters.org/?dist=DBI+1.609 for DBI and http://matrix.cpantesters.org/?dist=DBD-Oracle+1.23 for DBD::Oracle. It doen't look good for DBD::Oracle but it seems to me that the passed tests are not reported ... it can't be such a bad code ;-) Greetings Robert

Re: DBD::SQLite: Nullable Primary Key?

) ) Not nice, but it is a way... Greetings Robert --- Mark Lawrence schrieb: On Mon Oct 12, 2009 at 02:54:38PM +0200, Robert Roggenbuck wrote: I detected that it is possible to enter NULL in a table-column defined as PRIMARY KEY. Is it a bug or a feature of the manifest typing of SQLite

DBD::SQLite: Nullable Primary Key?

INTO TestTable VALUES (NULL, 1, NULL)'); $dbh-do('INSERT INTO TestTable VALUES (2, NULL, 3)'); $dbh-do('DROP TABLE TestTable'); ## While executing it complains only about inserting a NULL in column b for the second INSERT, but not for column a in the first INSERT... Greetings Robert

Re: DBD::CSV data types

You will find the supported data-types in SQL::Dialiects::CSV of the SQL::Statement package. There in no POD, but the section [VALID DATA TYPES] lists all possible types. DATE is unfortunately not there (DBD::CSV 0.22). Hope that helps Robert -- larry s schrieb: Does anyone know why

Re: DBD::CSV - UPDATE corrupts data!

the same as 15). What's going on? Where should I look for the cause of the problem? Greetings Robert PS: Here again my test-script. The 1st execution creates the table 'Projects' in /tmp. The 2nd execution should update the data (infact if everything went fine nothing changes, because

Re: DBD::CSV - UPDATE corrupts data!

::st (DBI::st=HASH(0x18e7698)~0x18e75c0 '20050701' '20100430' 'ID003') thr#1880010 - execute for DBD::CSV::st (DBI::st=HASH(0x18e7698)~0x18e75c0 '20050301' '20091231' 'ID002') thr#1880010 But may be this is only a matter of reporting... Greetings Robert Robert Roggenbuck schrieb: Hi

Re: disconnect and non-'Active' statement handles

the release of the script. Greetings Robert

disconnect and non-'Active' statement handles

Robert

Re: Very slow mail-transport to the list

I changed my subscription address. And now mailing goes as fast as it should. Thanx 8-) Robert rrogg...@uni-osnabrueck.de schrieb: Thank You very much for this clarification! I will try to change my email next week. The rest of this week I am at home and can not access the address from wich I

Re: DBD::CSV - UPDATE corrupts data!

is the same. Other things inlined ... Alexander Foken schrieb: Hello, On 30.06.2009 14:41, Robert Roggenbuck wrote: Hi all, [snip] Running the code below copied and pasted on Linux 2.6.26.5, Perl 5.8.8, DBI 1.607, DBD::CSV 0.20, both runs deliver the same result from your first run. Even several

Re: Insert records in table with perl DBD::Mysql

Robert --- Jannis Kafkoulas schrieb: Hi, I have this table: create TABLE netobj ( name VARCHAR(100), type int(1), ip_mem VARCHAR(1100), mask VARCHAR(15) default na, comment VARCHAR(50) default -, mark int(1) default 0, primary key(name)); (on a debian etch). After emtying the table

DBD::CSV - UPDATE corrupts data!

48 [snip] At last my stats: Perl 5.8.8 built for sun4-solaris-thread-multi DBI 1.48 DBD::CSV 0.22 Can someone help? Greetings Robert

Re: bind_params: Not identifying ? as a parameter placeholder

Why not $sth-bind_param(4, $int); ? I see 4 placeholders in Your statement. Do not rely on the values of statement handle attributes (like NUM_OF_PARAMS) unless You executed the statement handle. By the way: How does Your code fails? Any error message? Greetings Robert Tim Bowden

Re: Datatype-support of DBD::SQLite

DEFAULT, are available within DBD::SQLite. :-) Greetings Robert --- Owen schrieb: On Wed, 27 May 2009 16:19:28 +0200 Robert Roggenbuck rrogg...@uni-osnabrueck.de wrote: Hi all, while looking at the SQLite-Documentation at http://www.sqlite.org I detected that there are only a few

Re: Difference between DBD::SQLite and DBD::SQLite2?

Thanks for the clarification. Greetings Robert -- David Dooling schrieb: On Tue, May 26, 2009 at 12:29:08PM +0200, Robert Roggenbuck wrote: can someone explain the difference between the DBD::SQLite and the DBD::SQLite2 divers? DBD::SQLite2 is deprecated and (as you indicate below

Datatype-support of DBD::SQLite

CHARACTER, VARCHAR, BOOLEAN, DATE, TIME and other useful data types. Using DBD::CSV most of them are accepted but not treated special. Is it necessary to reformulate my CREATE TABLE statements if I decide to use DBD::SQLite? Greetings Robert

Difference between DBD::SQLite and DBD::SQLite2?

in it's NAME-chapter it is for sqlite 2.x? Hope someone can unconfuse me. Greetings Robert -- == Robert Roggenbuck Institut fuer wissenschaftliche Information e.V. (IWI) Fachbereich Mathematik / Informatik Universitaet Osnabrueck Germany

Re: Beginners Question: Can I have more the one statement-handle from same db-handle at a time?

test myself because my the mysql db on my iphone is broken and I have no other here at the moment :-( A simple yes or no will do. Thanks, B. -- === Robert Roggenbuck Universitaetsbibliothek Osnabrueck Alte Muenze 16 D-49074 Osnabrueck Germany Tel ++49/541/969

Re: How to write a (My)SQL statement with REGEX / RLIKE containing a scalar variable?

Server ... :-( Greetings Robert Deviloper schrieb: That's again the moment where I ask me, are there any good mysql cookbooks out there? Every sql book I touch seems only to have crappy mysql examples, but tons of oracle example... thanks so far. B. Dr.Ruud [EMAIL PROTECTED] hat am 14

Re: [rt.cpan.org #36696] DBI AutoCommit perldebug eval $@ problem

Queue: DBI Ticket URL: http://rt.cpan.org/Ticket/Display.html?id=36696 Can You please remove the address 'dbi-users@perl.org' from any 'To'-field (CC and BCC)? Greetings Robert Tim_Bunce via RT schrieb: Queue: DBI Ticket URL: http://rt.cpan.org/Ticket/Display.html?id=36696

Re: Installing package

This sounds to be a permission problem. Check Your install aim and Your permissions there. Greetings Robert Nirmaladevi Venkataraman schrieb: Hi when I tried to install DBD-ODBC package I get following error message ppm install failed: All available install areas are readonly. Could you

DBD-Oracle 1.20 - problems compiling on Windows (Visual Studio 2005 Perl 5.10)

Hi, If anyone has a pre-built DBD-Oracle for Windows (XP/Pro)/Perl 5.10, would love to have it. R - * Notice: This e-mail,

Re: Segmentation Fault(Core dumped)

Please give us some more information. Can You figure out where (= which lines) in Your script the code crashes? Greetings Robert Kasi, Vijay (London) schrieb: Hello, I am receiving 'Segmentation Fault (core dumped)' error while executing perl script on unix host. I am using oracle 10.2.0

Re: DBI problem...

Hi, at first it is not necessary to say use DBI::DBD. You name the driver in the call of DBI-connect(). Regarding the syntax error it would be worth to see some more lines before line 23. May be a missing ';' in line 22? Regards Robert didik kustriant schrieb: Hi, i'm newbie in perl

Re: DBD::CSV: make test fails

the most recent versions: $ perl -e 'use SQL::Statement; print $SQL::Statement::VERSION\n' 1.15 $ perl -e 'use Text::CSV_XS; print $Text::CSV_XS::VERSION\n' 0.31 $ perl -e 'use DBI; print $DBI::VERSION\n' 1.59 $ perl -e 'use DBD::CSV; print $DBD::CSV::VERSION\n' 0.22 Best regards Robert

Re: DBD::CSV: make test fails

function - but it is a DBD::CSV privat feature. So again DBD::CSV is wrong in using DBD::Adabas and applying it's own feature to a foreign driver. Cleaning the test codes from using foreign drivers will also solve this issue. Best regards Robert Robert Roggenbuck schrieb: I looked

Re: DBD::CSV: make test fails

lines 28-34). If I unset the DBI_* variables, DBD::Adabas is not used and all DBD::CSV-tests are passing - and finally 'make install' succeeds. May be this DBI_* usage should be removed from lib.pl? For the DBD::Adabas problem I will open a new thread. Thanks for all the comments :-) Robert

Re: DBD::CSV: make test fails

Hi Ron, Ron Savage schrieb: Robert Roggenbuck wrote: Hi Robert Looking at the code and the first error msg you got: YOU ARE MISSING REQUIRED MODULES: [ ] makes me suspect the method you are using to test the module. Are you using 'The Mantra' of standard commands? Something like: As I said

Re: DBD::CSV: make test fails

going though the others. The message is exactly the same in every test. If these are Jeff Zucker's private tests, there is something wrong with the package... Best regards Robert Ron Savage schrieb: [EMAIL PROTECTED] wrote: Hi Robert This is not much (missing an unnamed module?), but I

DBD::CSV: make test fails

:47 @INC: /home/rroggenb/perl/lib/5.8.8/i686-linux-ld /home/rroggenb/perl/lib/5.8.8 /home/rroggenb/perl/lib/site_perl/5.8.8/i686-linux-ld /home/rroggenb/perl/lib/site_perl/5.8.8 /home/rroggenb/perl/lib/site_perl . --- Best regards Robert

11i is out...

Does the latest version of DBI/DBD::Oracle support it? I didn't see a support version table anywhere. Robert

Re: 11i is out...

Andy Hassall wrote: Robert Hicks wrote: Does the latest version of DBI/DBD::Oracle support it? I didn't see a support version table anywhere. I posted something on this to the dev list, see link below, basically it works but there's a couple of minor issues: http://www.mail-archive.com

Re: Another set of DBI docs

its handy to me to quickly lookup the meaning of an attribute I've forgotten, or to lookup the right parameters for some method. Any comments/corrections/suggestions welcome, but are probably best sent offlist. Regards, Dean Arnold Presicient Corp. That is pretty nifty. Robert

Re: DBI DBD-ODBC

Yes that is the statement I am using in my PERL script. Robert V Simmons Martin Evans [EMAIL PROTECTED] 08/15/2007 03:31 AM To dbi-users dbi-users@perl.org cc Subject Re: DBI DBD-ODBC [EMAIL PROTECTED] wrote: I created an MSACCESS Database on my Windows XP O/S, set up

Re: ShowErrorStatement

Tim Bunce wrote: On Tue, Aug 14, 2007 at 07:01:23PM -0400, Robert Hicks wrote: Tim Bunce wrote: Setting ShowErrorStatement is unrelated to or die... so the question seems flawed. ShowErrorStatement just adds information to the message produced by RaiseError and PrintError. I recommend

Re: ShowErrorStatement

, PrintError = 0, ShowErrorStatement = 1, ... Tim. So I should still or die... even if I set ShowErrorStatement? I ask, because if true, then I would like to let the author of the paper I am reading know to make corrections if needed. Robert

DBI DBD-ODBC

. If anyone knows the reason for this error and how I can fix it, I would appreciate it very much. I am sending this email as a last resort as I have exhausted all of my resources. Regards, Robert V Simmons This communication is for informational purposes only. It is not intended as an offer

Re: ShowErrorStatement

Tim Bunce wrote: On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote: Tim Bunce wrote: On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code

Re: ShowErrorStatement

Tim Bunce wrote: On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote: Tim Bunce wrote: On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code

ShowErrorStatement

First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code with or die... statements. Is it good practice to use this or is an explicit or die... better because you can see there is error trapping? Robert

Load Testing Script

Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might have a better script... Robert

Re: Load Testing Script

Loo, Peter # PHX wrote: Hey Robert, Are you going from Oracle to Oracle? Peter Yup...I am basically wanting to test against 1 particular Oracle db. Robert

Re: Load Testing Script

It probably doesn't matter. Right now I just have a script that does inserts and selects. I control the database so I can do pretty much what I need to do. Loo, Peter # PHX wrote: From a flat file? Peter -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent

Re: Load Testing Script

Garrett, Philip (MAN-Corporate) wrote: Robert Hicks wrote: Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might

Re: Recovering records from corrupted MSSQL tables

'next;' } else { # no more records last; } } $isrt_sth-execute( @$row_ref ) } Robert Brian H. Oak schrieb: I'm working with an MS SQL Server database residing on a disk that suffered a crash. There are a couple of very

[DBD::Oracle] Familiar error to someone?

processors Perl 5.6.2 DBD::Oracle 1.17 DBI 1.56 Should we move up to the latest DBD::Oracle to fix? This doesn't happen on the PA-RISC box running DBI 1.14 with the same version DBD::Oracle. Robert

Re: [DBD::Oracle] Familiar error to someone?

John Scoles wrote: Itanium could be a 32/64 bit problem did you compiled all your code useing 32 bit libs? I believe so...I know the c code is. Perl: Summary of my perl5 (revision 5.0 version 6 subversion 2) configuration: Platform: osname=linux, osvers=2.6.9-55.el,

Re: DBI requires 5.6.0 or 5.6.1?

Paul DuBois wrote: snip Tim, thanks for clarifying. I was wondering because it wasn't clear to me, in writing about DBI, how to characterize what version of Perl a reader should have. I'll write that 5.6.0 is required but 5.6.1 is preferred. What are you writing about DBI? ; ) Robert

Re: DBI:CSV join ... flashback to 2002

the problems will be gone then. Best regrads Robert [EMAIL PROTECTED] schrieb: Question about joining using DBI:CSV. I must be making a stupid mistake somewhere. Earlier posts (2002) state that there were problems using aliases in joins. I've just installed the modules on a windows machine

Oracle spatial

Does DBD::Oracle have any problems with spatial tables and the like? We are looking at using spatial for some nav computational stuff. Robert

Re: Oracle make test failing on HP/UX

according to the POD but nada. Robert

Re: Oracle make test failing on HP/UX

/usr/lib/hpux32/dld.so: Cannot dlopen load module '/usr/lib/hpux32/libpthread.so.1' because it contains thread specific data. Failed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load '/users/user/DBD-Oracle-1.17/blib/arch/auto/DBD/Oracle/Oracle.so' for

Oracle make test failing on HP/UX

I am trying to install DBD::Oracle (yes I did read the README) on HP/UX 11.23 (itanium). I have DBI installed properly and I tested using DBD::SQLite. When I go to install the Oracle stuff I get this during a make test: ./usr/lib/hpux32/dld.so: Cannot dlopen load module

Re: Oracle make test failing on HP/UX

[EMAIL PROTECTED] wrote: Note the libraries. perl is 64 bit whereas you are trying to load 32 bit libraries. I have built Oracle DBI on Itanium if you want further info P I would be much ablidged if you could share. : ) Robert

Re: Oracle make test failing on HP/UX

=$ORACLE_HOME:$ORACLE_HOME/lib and see what happend I will try that as well. I have both the LD and SHLIB set in the env but I think the LD one points to the 64 bit libs. Robert

Re: Oracle DBI for HP

/downloads.html I used the following version which has the DBI module already installed: 11.23 / 64 and perl 5.8.8 + defined-or + DBI 1.53 + Tk 804.027 built with gcc-4.1. (It is down at the bottom!) I have to use the 5.6 series... : ( Robert

Re: Oracle DBI for HP

[EMAIL PROTECTED] wrote: Can you get hold of an HP ANSI C compiler? p Yes I can. R

Re: escaping % AND \%

. '%' ); Doing it this way You avoid the trouble handling the conflicting Perl- and the SQL-escaping in case of '%'. Regards Robert Bill Moseley schrieb: I have a very simple search using ILIKE and binding like: $sth-execute( '%' . $user_input . '%' ); The docs show this for escaping SQL pattern

RE: ODBC probelms when connecting to MSSQL

The perl script is #!/usr/bin/perl use strict; use warnings; use DBI qw(:sql_types); my($mandateid,$memberno,$orderval,$fitdate,$authmessage,$authnum); my ($output1, $output2,$output3, $input1, $input2, $input3, $input4, $input5); $mandateid = $ARGV[0];

ODBC probelms when connecting to MSSQL

Hi All I'm trying to connect to MSSQL 2000 to execute a number of stored procedures to return values to my IVR system, I have two stored procedures that work, and one that works from the ms query analyser, but when I run the perl script Here is the output

Re: DBD::CSV and multi character separator

Hi, can You show us a relevant code snippet (connecting and querying) and a snippet of Your CSV-Data? Which kind of line separator are You using? Best Regards Robert Santosh Pathak schrieb: Hi, I read on following site that DBD::CSV supports multi-character separator. But I am

Re: DBD::CSV and multi character separator

This looks clean too me - and Philip points already to the main reason for which Your code fails. BTW: Did You get an error message while connecting / querying or did You just get no results? Greetings Robert - Santosh Pathak schrieb: Here is my code, use DBI; $dbh = DBI-connect

Re: Gofer to PC (was: Is PERL -- MS SQL really that difficult?)

pursuing the other ideas offered (sybase, connect () syntax improvements, etc) for now. Thanks for the tips! Robert On Apr 26, 2007, at 4:51 AM, Tim Bunce wrote: On Wed, Apr 25, 2007 at 05:24:40PM -0400, Robert Denton wrote: Is it just me, or is using perl on a linux server to extract

Re: Is PERL -- MS SQL really that difficult?

biggest error, other than borrowing unproven connect() syntax from who-knows-what-google-return, was in not declaring dbi:ODBC: in from of the data source and also in not defining my odbc.ini file. Many thanks to everyone who contributed to the resolution of this issue Robert On Apr 26

Re: data_source syntax

[PostgreSQL] but apparently I also need something that can talk to an MSSQL db. I thought unixODBC came with all the necessary drivers? Can anyone confirm this? Perhaps I need to install a different version? Thanks! Robert On Apr 24, 2007, at 7:17 PM, Ron Savage wrote: Hi Robert While

Re: data_source syntax

at FreeTDS and report back... Robert On Apr 25, 2007, at 12:20 PM, Martin Evans wrote: Robert Denton wrote: Well, as it turns out, I am jumping the gun. Going by some tutorials here: http://www.easysoft.com/developer/languages/perl/ dbd_odbc_tutorial_part_1.html Having unixODBC installed

Is PERL -- MS SQL really that difficult?

/examples etc of how this set up is supposed to work. The examples at dbi.perl.org and in Programming the Perl DBI seem to never include MSSQL examples, unfortunately. Robert

Re: Is PERL -- MS SQL really that difficult?

Why can't we all just get along? --unknown (by me) I understood from the start that I would be raging against the machine but I was hoping there would be fellow ragers to help me along. I am _so_ close. I can feel it. But I really need some help to get it the rest of the way. Robert

Re: Cannot find ODBC driver

hope that if it is yumable then the yum install would suffice. Robert On Apr 24, 2007, at 8:17 AM, Martin J. Evans wrote: Robert Denton wrote: Hi, I am hoping someone here recognizes this problem: I have installed unixODBC for use as a driver manager for DBD::ODBC. However, when I run

data_source syntax

$password = 'testPass'; $dbh = DBI-connect( $data_source, $username, $password ); Thanks! Robert

Cannot find ODBC driver

install Make had some problems, won't install Perhaps the problem is that the ODBCHOME env var is set wrong? I have tried the following: export ODBCHOME=/usr/bin export ODBCHOME=/etc both yield the same results... Could someone make a recommedation? Thanks!! Robert

Re: perl dbi memory error?

By the way: In the 3rd step You are using in Your code $sth-execute (and not $dbh-execute, as You typed in Your message)? Don't You? Best regards Robert ravi kumar schrieb: Hai, I am using perl DBI module for fetching data from database. My database table contains almost 70

Re: Cannot Install DBD ORacle in Win Xp

? Robert

Re: Balasan: Re: Where does MoveNext belong to?

dump_results() (depending of the purpose of the dumping). Best regards Robert Patrix Diradja schrieb: Hallo Robert, Vielen Dank fuer Ihre Antwort. But I don't think it's enough for my demand to use fetching of ResultSet that way. Could you help me more, please tell me where I can get to use

Re: Where does MoveNext belong to?

I do not know anything special about ADO, but try the more usual way to fetch results: my $tab4l; while ( ($tab4l) = $rsnya-fetchrow_array) { print \$tab4l: $tab4l \n; } Does it work this way? Best regards Robert Patrix Diradja schrieb: Dear my friends I am writing a program

Re: Help Needed :: urgent

Can You add some more details about error messages, relevant code snippets and used versions (of Perl, DBI, used drivers, mySQL)? Robert veera sekar schrieb: Hello, I used perl DBI module for my threading concept.but i am getting problem, few things not working because of DBI resource break

Re: DBI Module

What is the error message You get while 'make'? Robert Agarwal, Nalnish (CT) schrieb: Hello, I am trying to make DBI on Solaris 9 machine. Following is the output of perl -V Makefile.PL --- Summary of my perl5 (revision 5.0 version 6 subversion 1

Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

Chris Drake wrote: Hi Philip Robert, Thanks for those excellent references help offers. Do you (or anyone) know whether or not I should even be *using* a shared server, and have you any idea about how many dedicated connections is too many on a dual-3.8ghz Xeon Linux PC with 8gigs or RAM

DBI in a web context

in an eval statement? Croak or die statements? I am thinking eval because I can set autocommit to off and then do rollbacks if $@ has an error. Suggestions and comments welcome? Robert

Re: DBI in a web context

In my case I would probably report and return. Easy enough to do for what I am dong. Robert Reidy, Ron wrote: I would definitely wrap the entire transaction in an eval {}. But, I'm not sure if I would croak/die when a failure occurs vs. report the error and go back. rr -Original

Re: Oracle and bindcolumns

string. I did...and I realized my mistake when that error came up. : ) Robert

Re: Oracle and bindcolumns

Garrett, Philip (MAN-Corporate) wrote: Robert Hicks wrote: Hardy Merrill wrote: Sorry for the top-post - Groupwise :-( Notice how Philip suggested using to_char - *not* to_date. You probably already know this, but on the chance you don't, you use to_date if you have a string that contains

Oracle and bindcolumns

Any gotchas there? I am opening an Access db via ODBC and binding those columns (including a date field) and passing that to the Oracle handle to do inserts (i.e. Access - Oracle migration). Robert

Re: Oracle and bindcolumns

Garrett, Philip (MAN-Corporate) wrote: Robert Hicks wrote: Any gotchas there? I am opening an Access db via ODBC and binding those columns (including a date field) and passing that to the Oracle handle to do inserts (i.e. Access - Oracle migration). Only gotcha is with formatting -- you'll

DBD::Oracle: Synonym translation no longer valid?

:\Projects\Perl\XLReports\get_primaries.pl line 31. What is synonym translation??? Robert

Re: DBD::Oracle: Synonym translation no longer valid?

it references or re-create the synonym so that it refers to a valid table, view, or synonym. HTH Michael OMG, they changed the table name without telling me! Nice of them. It helped a lot. Robert

  1   2   3   4   >