FAQ

Search Discussions

58 discussions - 260 posts

  • Once upon a time I said: http://groups-beta.google.com/group/perl.dbi.users/msg/caf189d7b404a003?dmode=source&hl=en and wrote http://search.cpan.org/~timb/DBI/Roadmap.pod which yielded: ...
    Tim BunceTim Bunce
    Jul 2, 2005 at 12:06 am
    Aug 17, 2005 at 3:24 pm
  • I'm sending you attached the output of it_works. DBD::Informix works fine, except that it's taking twice the time than ESQL/C when I SELECT from a table and do a while($ref = $stmt- fetch) { } This ...
    Gerardo Santana Gómez GarridoGerardo Santana Gómez Garrido
    Jul 3, 2005 at 8:47 am
    Jul 21, 2005 at 10:00 pm
  • I have the same problem as described here: http://www.nntp.perl.org/group/perl.dbi.users/7343 (searching from Oracle databases take extremely long because DBIx::Recordset tries to get metadata for ...
    Tielman de VilliersTielman de Villiers
    Jul 26, 2005 at 4:39 pm
    Jul 27, 2005 at 10:40 am
  • I am trying to bind an undef into an IsNull on a varchar field. When I write the query binding directly into the IsNull I get no records, yet if I create a SQL variable, bind the undef to that, and ...
    Brian BeckerBrian Becker
    Jul 25, 2005 at 3:32 pm
    Jul 26, 2005 at 3:33 pm
  • Summary ======= perl-5.8.7, DBI-1.48, Oracle-9.2.0.4. This is proably an Oracle question in the long run: How to frame a query so that bind_param_inout can pass strings as varchar's and have them ...
    Steven LembarkSteven Lembark
    Jul 13, 2005 at 4:49 pm
    Jul 20, 2005 at 8:59 am
  • It's not documented what selectall_hashref() will do when the key field or fields you've chosen are not unique. For example (Sybase SQL): $dbh- selectall_hashref( 'select 5 as a, 6 as b union select ...
    Avis, EdAvis, Ed
    Jul 13, 2005 at 9:34 am
    Jul 14, 2005 at 7:25 am
  • Hello, I have a small-but-weird problem. When I install the 0.34 release of DBD::File via CPAN it seems to make/test/install properly but... it just doesn't stick. The installation seems to stay at ...
    Paul BoutrosPaul Boutros
    Jul 5, 2005 at 4:52 pm
    Jul 9, 2005 at 6:45 pm
  • This is a quick RFC concerning database wrapper modules and frameworks, large and small, which are quite common on CPAN; specifically it concerns such things that are not any of my creations. I am ...
    Darren DuncanDarren Duncan
    Jul 19, 2005 at 9:05 am
    Jul 21, 2005 at 10:41 pm
  • Hi all. The SQL Server docs say that you can instruct SQL Server to interpret dates in the format you want ( for example in insert statements ) by issuing the command: set dateformat xxx where xxx is ...
    Daniel KasakDaniel Kasak
    Jul 7, 2005 at 1:36 am
    Jul 7, 2005 at 12:32 pm
  • I am pulling out users (name + email) and I need to sort the list by everything after the @ sign in the email address. I wasn't sure which group to post to. I am pulling them into an excel ...
    RobertRobert
    Jul 18, 2005 at 4:27 pm
    Jul 20, 2005 at 12:15 pm
  • hello is it possible to change the character-encoding of the data one receives from an oracle-DB at runtime? i.e. is it possible to have connections to two oracle-DBs in one perl-application where ...
    Hermann SchwaerzlerHermann Schwaerzler
    Jul 8, 2005 at 12:42 pm
    Jul 11, 2005 at 8:21 pm
  • hello, I am trying to download DBD-Oracle.ppd from http://ftp.esoftmatic.com/outgoing/DBI/5.8.4/ and i am not able to download that. Is there any way that i could download DBD-Oracle.ppd for perl ...
    MaryMary
    Jul 22, 2005 at 3:47 pm
    Jul 25, 2005 at 3:13 pm
  • All, I have completed the first draft of my Lightning Talk for OSCON 2005, which introduces 'Rosetta'. I request your assistence to help me make this talk the best it can be. You should send all ...
    Darren DuncanDarren Duncan
    Jul 22, 2005 at 7:48 am
    Jul 23, 2005 at 4:38 am
  • Hi, Wondered if anyone can tell me if I've misunderstood something here. I am able to insert unicode data into nvarchar2 and get back what was inserted but same code with nchar column does not work. ...
    Martin J. EvansMartin J. Evans
    Jul 18, 2005 at 5:05 pm
    Jul 19, 2005 at 1:32 pm
  • Hello, I am having trouble calling any stored procedure with a parameter through DBI and DBD::ADO on a Sybase Adaptive Server Enterprise. What I would finally like to do is call a stored proc with an ...
    Philip ZembrodPhilip Zembrod
    Jul 15, 2005 at 5:42 pm
    Jul 19, 2005 at 9:02 am
  • Hi all. I'm using the process: my $sth = $dbh- prepare ( "update xxx set a=?, b=?, c=? where d=?" ); $sth- execute( $a, $b, $c, $d ); to update data in a SQL Server database. It works fine most of ...
    Daniel KasakDaniel Kasak
    Jul 12, 2005 at 6:30 am
    Jul 12, 2005 at 10:56 pm
  • You should post this to dbi-users@perl.org. -- Scott T. Hildreth <shildret@scotth.emsphone.com
    Scott T. HildrethScott T. Hildreth
    Jul 11, 2005 at 2:18 pm
    Jul 12, 2005 at 3:23 am
  • Hi, Even though character encoding issues have been discussed also here, I still cannot figure out what is going on in my system. I try to load data from XML documents and insert into an Oracle ...
    Teemu KiviojaTeemu Kivioja
    Jul 29, 2005 at 8:00 am
    Aug 13, 2005 at 4:13 pm
  • Hello, does DBD::CSV supports the following select clause? select * from table where upper (col1) like '%ab%'; I'd like to make case insensitive queries but from docs it seems it's not allowed. ...
    Radomir HejlRadomir Hejl
    Jul 23, 2005 at 8:37 pm
    Jul 25, 2005 at 8:29 pm
  • Hi, I facing a problem while compiling a perl code from my Linux machine. I am using the following code snippet - #!/ms/dist/aurora/bin/perl use strict; use lib ...
    Sinha, Dipyaman \(Company IT\)Sinha, Dipyaman \(Company IT\)
    Jul 16, 2005 at 5:59 am
    Jul 19, 2005 at 3:16 pm
  • Scott, First of all, could you please give me some information such as client lib version (where did you obtain it from?), the version of the server you are connecting to, OS (type, version, ...
    Patrick GalbraithPatrick Galbraith
    Jul 14, 2005 at 5:02 pm
    Jul 18, 2005 at 11:31 pm
  • Where can I find a list where I can report bugs or get some advanced and knowledgeable help ???? I have an issue which I have posted to the forum... no help from anyone there.... It is a significant ...
    Drozdowski, CatharineDrozdowski, Catharine
    Jul 18, 2005 at 6:03 pm
    Jul 18, 2005 at 11:11 pm
  • Hi All, I am using Oracle v9.2.0.6, Perl V5.8.4... I can find the version of the dbi if needed... When I run a simple connection call I have been using for years against an Oracle DB with the ...
    Drozdowski, CatharineDrozdowski, Catharine
    Jul 14, 2005 at 12:22 am
    Jul 18, 2005 at 6:45 pm
  • Hi Folks Jonathan Leffler has sent me these grammars, which I'm hosting at: http://savage.net.au/SQL/ -- Cheers Ron Savage, ron@savage.net.au on 17/07/2005 http://savage.net.au/index.html Let the ...
    Ron SavageRon Savage
    Jul 17, 2005 at 1:10 am
    Jul 17, 2005 at 6:47 am
  • It seems the latest version on the esoftmatic site is for 5.8.4, is this due to the same licensing issue that ActiveState speaks of w.r.t. Oracle client? My ActiveState perl version is 5.8.7 and I ...
    Larry PieniazekLarry Pieniazek
    Jul 1, 2005 at 12:54 pm
    Jul 10, 2005 at 2:00 pm
  • Hello, there are two machines: computer1 and computer2. Parameters of computer1: perl 5.6.1 sname=solaris, osvers=2.8, archname=sun4-solaris-thread-64int-ld DBI 1.41 DBI::ProxyServer 0.3005 ...
    Wojciech PietronWojciech Pietron
    Jul 22, 2005 at 9:39 am
    Jul 29, 2005 at 9:48 pm
  • Hello, A large Perl application (10^4 .. 10^5 lines of code) has to work with data on an MS SQL Server 2000 containing Unicode data in NVARCHAR columns. Perl 5.8.6 (ActivePerl) runs on the same or ...
    Alexander FokenAlexander Foken
    Jul 28, 2005 at 2:14 pm
    Jul 29, 2005 at 3:44 pm
  • This seems like something that the wider world should know about. For those of you that missed it its been a strange few days on the CDBI mailing list. -- </chris "There are four boxes to be used in ...
    Christopher HicksChristopher Hicks
    Jul 28, 2005 at 6:23 pm
    Jul 29, 2005 at 6:49 am
  • Hoping someone can point me at a DBD thats known to be non-thread-friendly (ie, hasn't implemented the clone() methods). However, its underlying client libs and XS subs (if any) do need to be ...
    Dean ArnoldDean Arnold
    Jul 22, 2005 at 4:30 pm
    Jul 29, 2005 at 3:05 am
  • Hi, My current application is running on Oracle8i. The application is based on CGI Perl and it uses DBI and DBD. I'm going to migrate my application to Oracle9i. I would like to know which Version of ...
    Ata RajaAta Raja
    Jul 25, 2005 at 6:42 am
    Jul 26, 2005 at 1:56 pm
  • Hi, I was recently going through the process of manually installing DBI 1.48 and DBD::Oracle (I prefer the manual route), and couldn't complete the install due to items missing from @INC. I'm working ...
    Smith, Sharon Michelle (OSLO)Smith, Sharon Michelle (OSLO)
    Jul 21, 2005 at 7:14 pm
    Jul 21, 2005 at 7:16 pm
  • I understand that "finish" frees resources. What happens if the script dies under error? Do the "finish"es function as transactional boundaries and cause commits?
    Denesa K ShawDenesa K Shaw
    Jul 21, 2005 at 5:21 pm
    Jul 21, 2005 at 6:48 pm
  • I'm having a strange compile error when compiling DBD::Informix on AIX 5.2 using the IBM vac C compiler. DBI 1.48 installed without problems. I am using IDS 10.00.FC1 with the most recent Client-SDK, ...
    Priest, DarrylPriest, Darryl
    Jul 19, 2005 at 2:29 pm
    Jul 19, 2005 at 8:22 pm
  • I have a project that I need to connect to a DB2 database on an AS400 from a perl application on a Linux box. I've been reading as much as I can but have a few questions for those with experience in ...
    Keith JacksonKeith Jackson
    Jul 19, 2005 at 3:45 pm
    Jul 19, 2005 at 3:57 pm
  • Regards, Balkrishna Sapre. 91-20-22933700(3179) Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of ...
    Balkrishna SapreBalkrishna Sapre
    Jul 14, 2005 at 4:37 am
    Jul 19, 2005 at 12:50 am
  • Hi, I added the following bug report tp rt.cpan.org http://rt.cpan.org/NoAuth/Bug.html?id=13708 I haven't had any response an as I'm a nervous sort thought that sending the fact to this mailing list ...
    Trevor HillsTrevor Hills
    Jul 17, 2005 at 9:47 pm
    Jul 17, 2005 at 11:11 pm
  • Hi, I use perl scripts for FTP and other activities. I would like have some DB activitiy in one of the script with Oracle DB tables. Can someone give me headstart on this please. Thanks, Jagan.
    Jagan VemulaJagan Vemula
    Jul 13, 2005 at 2:29 pm
    Jul 13, 2005 at 3:51 pm
  • IBM Informix Database Driver for Perl DBI Version 2005.02 (2005-07-29) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables ...
    Jonathan LefflerJonathan Leffler
    Jul 29, 2005 at 6:26 pm
    Jul 29, 2005 at 6:26 pm
  • Hi, Can you please give the instructions to install and use Perl Interface to access DB2 I need everything from installation to sample program to access DB2 on windows from Perl. I am unable to ...
    Shabarinath KadavendiShabarinath Kadavendi
    Jul 25, 2005 at 7:22 am
    Jul 25, 2005 at 7:22 am
  • is there an web based guide detailing how to port oraperl to the perl-dbi format?
    Sid KatzSid Katz
    Jul 22, 2005 at 7:11 pm
    Jul 22, 2005 at 7:11 pm
  • Great idea! I would be willing to submit the application form for this and/or host it, unless someone else wants to do that. I will try to be fair and unbiased. My personal preference for a date is ...
    Darren DuncanDarren Duncan
    Jul 22, 2005 at 12:48 am
    Jul 22, 2005 at 12:48 am
  • ----- Forwarded message from Dmitry Trofimov <dmitry@perl.com.ua ----- From: Dmitry Trofimov <dmitry@perl.com.ua To: Tim.Bunce@pobox.com Subject: DBI support for arrayshash Hello. Please include ...
    Tim BunceTim Bunce
    Jul 20, 2005 at 10:36 pm
    Jul 20, 2005 at 10:36 pm
  • I have a table in an Oracle 10g database using the type binary_float. I can insert values into without any problems; however when I try to pull a value out I get garbage. Does DBD:Oracle version 1.16 ...
    John LegatoJohn Legato
    Jul 18, 2005 at 1:54 pm
    Jul 18, 2005 at 1:54 pm
  • Our current configuration: Postgres 7.4.8 (newly upgraded) Perl 5.8.7 (also newly upgraded) DBI 1.40 DBD::Pg 1.31 We have no outstanding problems traceable to anything in this pile of code. Is there ...
    Jeff BoesJeff Boes
    Jul 14, 2005 at 8:13 pm
    Jul 14, 2005 at 8:13 pm
  • If I missed something in the archives I apologize. I am trying to install DBD::mysql 3.0002, (I have client only libraries), when I run make test, all but test 1 fail with, DBD driver has not ...
    Scott T. HildrethScott T. Hildreth
    Jul 14, 2005 at 4:34 pm
    Jul 14, 2005 at 4:34 pm
  • There are two new CPAN-related sites that you may or may not have come across: http://www.annocpan.org/ -- Annotated CPAN This site allows people to add notes to the documentation of any CPAN module. ...
    Jonathan LefflerJonathan Leffler
    Jul 14, 2005 at 3:07 pm
    Jul 14, 2005 at 3:07 pm
  • This is also how DBD::Sybase handles it, as I recall. Michael had to teach me this just a few months ago (Thanks again, Michael).... amonotod -- `\|||/ amonotod@ | sun|perl|windows (@@) charter.net | ...
    AmonotodAmonotod
    Jul 13, 2005 at 6:23 pm
    Jul 13, 2005 at 6:23 pm
  • A colleague asked for help with the below script. As I have not worked with 10g and could not find a relevant FAQ I thought perhaps you gentle folks would nudge me in the right direction :-) Jacqui ...
    Jacqui Caren (IG)Jacqui Caren (IG)
    Jul 13, 2005 at 4:56 pm
    Jul 13, 2005 at 4:56 pm
  • Dear developers, Version 3.0002 DBD::mysql, the perl DBI interface to MySQL,has just been released! Version 3.0002 Fixes the problem with the package had problems being built with < MySQL 4.1, as was ...
    Patrick GalbraithPatrick Galbraith
    Jul 12, 2005 at 9:21 pm
    Jul 12, 2005 at 9:21 pm
  • A colleague asked for help with the below script. As I have not worked with 10g and could not find a relevant FAQ I thought perhaps you gentle folks would nudge me in the right direction :-) Jacqui ...
    Jacqui CarenJacqui Caren
    Jul 11, 2005 at 6:38 pm
    Jul 11, 2005 at 6:38 pm
Group Navigation
period‹ prev | Jul 2005 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions58
posts260
users94
websitedbi.perl.org

94 users for July 2005

Darren Duncan: 26 posts Reidy, Ron: 17 posts Jonathan Leffler: 15 posts Dean Arnold: 10 posts Martin J. Evans: 10 posts Ron Savage: 9 posts Sam Vilain: 8 posts Tim Bunce: 8 posts Gerardo Santana Gómez Garrido: 6 posts Patrick Galbraith: 6 posts Adam Kennedy: 5 posts Daniel Kasak: 5 posts Greg Sabino Mullane: 5 posts Steven Lembark: 5 posts Brian Becker: 4 posts Drozdowski, Catharine: 4 posts Jared Still: 4 posts Sam Tregar: 4 posts Avis, Ed: 3 posts Jeff Urlwin: 3 posts
show more
Archives