FAQ

Perl > dbi-users > September 2001

Search Discussions

200 discussions - 557 posts

  • Could someone explain: Why will fetchrow_hashref change in the future to return the same reference each time? I would like to understand the rationale. rob Live the dream.
    Rob RansbottomRob Ransbottom
    Sep 11, 2001 at 6:33 pm
    Feb 4, 2002 at 7:40 pm
  • Hi All, this one seems to puzzle me on how to avoid an unnecessary db error. I need to run a tally count on a couple tables, and if there isn't any data in the table it displays the dbError, altho ...
    MickaloMickalo
    Sep 22, 2001 at 11:40 pm
    Sep 24, 2001 at 2:15 pm
  • Hello, I am trying to install DBD::Oracle on a Redhat Linux 7.1 box for the sole purpose of connecting to a remote Oracle server. On our Windows boxes we need to install sqlnet (which we have for ...
    Philip DaggettPhilip Daggett
    Sep 26, 2001 at 9:01 pm
    Oct 1, 2001 at 5:44 pm
  • LokmaneLokmane
    Sep 20, 2001 at 12:40 pm
    Sep 20, 2001 at 4:03 pm
  • Sorry to interrupt on you on such a tragic day. I just want to let you know that question signs ('?') inside /* ... */ comments in a SQL-statement gives the following error message: DBD::mysql::st ...
    Morten HanshaugenMorten Hanshaugen
    Sep 11, 2001 at 9:07 pm
    Sep 19, 2001 at 5:56 am
  • I followed the trails of "Programming the Perl DBI, Appendix B" to freeodbc to .... to easysoft.org... I read for hours history requests at dejanews I am now more confused than when I started. I have ...
    Robert LopezRobert Lopez
    Sep 14, 2001 at 4:27 pm
    Sep 14, 2001 at 8:50 pm
  • Environment: SunOS 5.5.1 Generic_103640-36 sun4u sparc SUNW,Ultra-2 Oracle Enterprise Server 8.0.5 (on remote SunOS) DBI 1.20 (all tests OK) DBD::Oracle 1.12 (all tests OK) Hi, I decided to present ...
    Wojciech PietronWojciech Pietron
    Sep 17, 2001 at 10:14 am
    Sep 21, 2001 at 2:50 pm
  • Are the DBD Modules Thread safe, DBD::Informix in particular. Thanks -- ------------------------------------ ------------------------------------ "given enough time and resources we can accomplish ...
    James MaesJames Maes
    Sep 14, 2001 at 6:56 pm
    Sep 20, 2001 at 2:21 pm
  • I have a query that works just fine in Oracle SQL*Plus, but I receive the following error when run through DBI. Line 35 states: my $sth = $dbh- prepare(qq(SELECT fuser.us_initl, I'm running: Redhat ...
    Michael RagsdaleMichael Ragsdale
    Sep 17, 2001 at 7:02 pm
    Sep 18, 2001 at 5:09 pm
  • Im trying to install DBD-Oracle-1.12 on a HP-UX 11 host. The box is a PA-Risc 1.1 box with Oracle 8.1.7. I've compiled perl 5.6.1 on it as README.hpux states and done everything else that document ...
    Richard AllenRichard Allen
    Sep 25, 2001 at 5:20 pm
    Sep 27, 2001 at 3:02 pm
  • I was about to upgrade our installation when I noticed this in the changelog. Tim Bunce <[email protected] writes: We ran into this problem once before when we first upgraded to Oracle 8.1.6. At ...
    Greg StarkGreg Stark
    Sep 21, 2001 at 11:16 pm
    Sep 27, 2001 at 9:27 am
  • Hi Folks, I've run across an issue in our environment regarding concurrent read/write access of a LOB record. I have duplicated it on Oracle 9i / 8i (8.1.5 and 8.1.7), DBI 1.15/1.18, DBD::Oracle ...
    Steven VetzalSteven Vetzal
    Sep 20, 2001 at 5:37 pm
    Sep 24, 2001 at 10:00 pm
  • Hi, Let me briefly explain what I need: I'm working on application that uses perl DBI internally and provides web user interface. I need to be able to provide nice database table access from the web, ...
    Alex GerasevAlex Gerasev
    Sep 9, 2001 at 4:51 am
    Sep 19, 2001 at 5:47 pm
  • I have a minor optimization suggestion. Instead of this: unless ($sth_routine_name) { #setup statement handle } Do this: $sth_routine_name ||= $dbh- prepare(....); If $sth_routine_name is already ...
    WsheldahWsheldah
    Sep 13, 2001 at 3:21 pm
    Sep 15, 2001 at 9:48 pm
  • I know this might be a wrong place to post question but I need quick tip here!!! I am running perl 5.1.6.... whenever I run "perl Makefile.PL", it keep complaining the file could not be found. The ...
    George XuGeorge Xu
    Sep 9, 2001 at 4:04 am
    Sep 13, 2001 at 1:19 pm
  • Hello all: Just a quick question concerning putting images in a database- I want to add a field for images within my mysql database: how should I go about doing this? I have tried -- ALTER TABLE ...
    Todd MoyTodd Moy
    Sep 7, 2001 at 1:33 pm
    Sep 7, 2001 at 5:06 pm
  • hi, I want a litle more extended sytax for selectall_hashref(), or if u can tell me how the achieve this : my $Query = qq{SELECT field1, field2, field3}; my $res = $dbh- selectall_hashref($Query, ...
    RaptorRaptor
    Sep 5, 2001 at 4:26 pm
    Sep 6, 2001 at 12:30 am
  • Hi Gurus I am encountering error while trying to run "make test" command. UNIX version: dgux av003drpfm R4.20MU06 generic AViiON Pentium Oracle: 8.1.6 The errors (make test TEST_VERBOSE=1) are: ...
    Chakravorty, KunalChakravorty, Kunal
    Sep 27, 2001 at 1:48 am
    Oct 17, 2001 at 8:19 am
  • Have been using DBI with MySQL & Oracle for some time now. Recently, the powers that be (i.e my bosses) decided to use PL/SQL stored procedures for some of our rather complex queries. The PL/SQL guys ...
    Jon WilliamsJon Williams
    Sep 5, 2001 at 12:50 pm
    Oct 8, 2001 at 1:28 am
  • Is there a possibility to get only the last entry of a table ? Sure, I could read the whole content into a loop but this is IMHO not the best solution. my $numFields = $sth- {'NUM_OF_FIELDS'}; while ...
    Mark WalterMark Walter
    Sep 28, 2001 at 10:41 am
    Sep 30, 2001 at 1:20 pm
  • Hi Jeff, I have a program listed below that shows what I think is a bug. you can call the script with these parameters: -G user_name -D database -r uncomment the line that is a "select user_name()" ...
    Tim HarschTim Harsch
    Sep 28, 2001 at 11:06 pm
    Sep 30, 2001 at 2:31 am
  • Tim, for a while now you've been saying that you will change fetchrow_hashref so that its performance is close to or the same as fetchrow_arrayref, but the perldocs still have this disclaimer: ...
    Hardy MerrillHardy Merrill
    Sep 12, 2001 at 12:46 pm
    Sep 13, 2001 at 1:25 pm
  • I'm wondering what other people have developed as database independent way(s) of determining if the insert or update being done results in a duplicate key situation. I can think of 2 methods to ...
    Hardy MerrillHardy Merrill
    Sep 28, 2001 at 9:06 pm
    Sep 29, 2001 at 6:05 am
  • Hi there I'm trying to find a mechanism for dealing with large BLOBs, where large is a value greater than the memory available to the process. This is used in a CGI application. I've been reading ...
    Adam KennedyAdam Kennedy
    Sep 21, 2001 at 2:25 am
    Sep 24, 2001 at 2:58 am
  • I noticed that DBD-Oracle trims blanks at the end of a field inserted into a VARCHAR2-type column, even though ChopBlanks is set to False. Is that expected behaviour ? It messes up FreezeThaw. I'am ...
    Arjan van HamArjan van Ham
    Sep 18, 2001 at 6:59 pm
    Sep 19, 2001 at 12:14 pm
  • My name is Karina Nagahama. I want to know about DBI. I'm working on Windows NT, Apache, Perl, mod_perl Oracle8 and DBI. I'm using DBI in a .pm file. In order to select information from the database ...
    Karina NahagamaKarina Nahagama
    Sep 12, 2001 at 4:50 am
    Sep 12, 2001 at 10:55 am
  • Hi I have successfully been using DBD::CSV for the last year and recently upgraded to Red Hat 7.0 from 6.2. The problem is that ever since the upgrade, the ORDER BY clause on an ISO date field (i.e ...
    Alex SchuilenburgAlex Schuilenburg
    Sep 10, 2001 at 5:39 pm
    Sep 11, 2001 at 10:43 am
  • I am writing a Perl/DBI application. I need to initially issue a select statement and then determine if any records are returned. Could someone provide me with an example of how to determine if no ...
    Paul Maine Jr.Paul Maine Jr.
    Sep 10, 2001 at 7:40 pm
    Sep 11, 2001 at 7:56 am
  • I have a cgi script that can't seem to connect to a mysql database when running from the web. When I logon and run it from the command line, it works fine! It dies on the $dbh- connect(...) line. It ...
    Ian FeldbergIan Feldberg
    Sep 6, 2001 at 4:16 pm
    Sep 7, 2001 at 3:16 pm
  • I am having a problem with the following SQL in a single statement: my $sql = qq|create opaque type mytype ( internallength=variable, MAXLEN=512 ); GRANT usage on type mytype to user; my $dbh = DBI- ...
    Korey KlierKorey Klier
    Sep 6, 2001 at 1:42 pm
    Sep 6, 2001 at 5:36 pm
  • Hi, I have already saw similar questions but I think my pb is a bit different. I wrote a perl script that use an oracle 9i DB throug DBI DBD::Oracle. This script work fine when started from command ...
    Eddie iannuccelliEddie iannuccelli
    Sep 6, 2001 at 6:58 am
    Sep 6, 2001 at 8:25 am
  • catch exceptions with eval: eval { #DBI stuff connect, prepare, execute, fetch, etc. # (with RaiseError= 1 !!!) }; trap_die($@) if $@; HTH, Douglas Wilson
    Wilson, DougWilson, Doug
    Sep 25, 2001 at 10:35 pm
    Sep 28, 2001 at 7:59 pm
  • Hello I am a beginner in Perl . I have installed Active perl latest version in my Win NT machine. I am trying to install DBI module in my machine by both ppm and manual method. While installing I am ...
    AbhraAbhra
    Sep 27, 2001 at 1:58 pm
    Sep 27, 2001 at 4:29 pm
  • Trying to get output from a procedure call. Definitely being a pain. Yes, yes, I've looked at perldoc DBD::Oracle and that didn't seem to work. I've even read up on perldoc.com about DBI, and various ...
    Jones Robert Contr 81 CS/SCKJones Robert Contr 81 CS/SCK
    Sep 26, 2001 at 9:10 pm
    Sep 27, 2001 at 3:42 pm
  • The following, if executed from within a Perl script, will hang indefinitely while trying to do the 'execute()' statement. my $sth = DBH()- prepare( "UPDATE ldb_ad_t SET most_recent_print_date = ...
    Dave StorrsDave Storrs
    Sep 26, 2001 at 9:47 pm
    Sep 27, 2001 at 5:33 am
  • I don't seem to be able to 'SET IDENTITY_INSERT {table} ON' using DBI::ODBC. Anybody have suggestions? Many Thanks!!
    Pat SheehanPat Sheehan
    Sep 25, 2001 at 2:26 pm
    Sep 26, 2001 at 3:25 pm
  • Hi, i'm running a Linux-server and need to get information from an Microsoft SQL-server. Is there a cheap possibility to do this. Bye Casper
    Casper van der HarstCasper van der Harst
    Sep 25, 2001 at 2:23 pm
    Sep 25, 2001 at 2:53 pm
  • Folks, How are you ?. I have downloaded DBI-1.20.tar.gz from the www.perl.org. Here is the system info. SunOS suncore 5.8 Generic_108528-09 sun4u sparc SUNW,Ultra-60 I have updated Makefile for gcc ...
    Srinivasa Rao KattaSrinivasa Rao Katta
    Sep 13, 2001 at 4:45 pm
    Sep 24, 2001 at 3:15 pm
  • To those using an Oracle client in a network: In www.globecom.net/tora you'll find a very nice GUI interface to deal with you're Oracle server. I had a go at it and it's phantastic! Vittorio
    VittorioVittorio
    Sep 21, 2001 at 11:38 am
    Sep 24, 2001 at 10:33 am
  • ----- Forwarded message from Alan Evetts <[email protected] ----- Delivered-To: tim.bunc[email protected] Date: Thu, 20 Sep 2001 10:13:31 -0700 From: Alan Evetts <[email protected] To: ...
    Tim BunceTim Bunce
    Sep 20, 2001 at 7:59 pm
    Sep 20, 2001 at 10:03 pm
  • Hello, I wrote a simple insert program like $sth = $dbh- prepare( qq{ INSERT INTO $table VALUES ($values[0],?,?,?,?,?,?,?,$values[8], $values[9], $values[10],?,?,?,?,?,?,?,?,?) } ); $sth- ...
    M. JangM. Jang
    Sep 16, 2001 at 9:20 pm
    Sep 17, 2001 at 6:21 am
  • I need help!! I'm running Personal Oracle8i and ActiveState's perl on the same win98 machine. All I'm trying to do is make a connection. If anyone would please help me do this I'd appreciate it. So ...
    Byron WiseByron Wise
    Sep 12, 2001 at 3:44 am
    Sep 12, 2001 at 4:23 pm
  • Hi, Is there any attribute(s) of the database handle that identify the sid and serial# of the connection? That is, I want to use DBI to kill some sessions (but I don't want to kill myself). Or is ...
    Jay StraussJay Strauss
    Sep 11, 2001 at 12:38 am
    Sep 11, 2001 at 3:20 pm
  • Dear gurus ! i want to convince the managers & co-workers at my company to start using perl as a standart scripting language here. So I need your input on the following points , please : 1) success ...
    Andrey BronfinAndrey Bronfin
    Sep 11, 2001 at 12:15 pm
    Sep 11, 2001 at 1:10 pm
  • message is coming from? The error points to the disconnect line, but I'd sure like to be able to tell which handle isn't being finished. I think I found them all, but obviously not. ...
    Jim LynchJim Lynch
    Sep 4, 2001 at 12:34 pm
    Sep 10, 2001 at 8:56 am
  • My name is Karina Nagahama, I want to install DBD::Oracle, but I have problems in building it. I download DBD-Oracle-1.08.tar.gz from http://velocity.activestate.com/code/cpan/d/db/DBD-Oracle.html I' ...
    Karina NahagamaKarina Nahagama
    Sep 7, 2001 at 7:20 am
    Sep 8, 2001 at 1:39 am
  • Dear Tim, I'm trying to install DBI-1.20 on an Ultra 5 running Solaris 8. Solaris 8 comes with Perl and GNU software already installed, so the install is using GNU tools. I did install make-3.78.1 ...
    Larry SchweizerLarry Schweizer
    Sep 3, 2001 at 4:42 pm
    Sep 4, 2001 at 3:43 pm
  • I was wondering if anyone had suggestions about the following problem I am having with DBD::Pg. A script I have is trying to insert the following statement into a mail table (schema below): INSERT ...
    Warren VolzWarren Volz
    Sep 26, 2001 at 9:52 pm
    Sep 28, 2001 at 11:36 am
  • This is off topic but I can't find any resources. If anyone can point me or answer directly I'd appreciate it. I have a hash tying package that works EXCEPT when references are returned and used in ...
    Steve SapovitsSteve Sapovits
    Sep 27, 2001 at 3:50 pm
    Sep 27, 2001 at 11:25 pm
  • Hi all I don't know if this has been discussed on this list before, but I just thought I'd mention it as it took me a while to figure out why my code wasn't working. If you call an Oracle supplied ...
    Dan HorneDan Horne
    Sep 26, 2001 at 3:13 am
    Sep 27, 2001 at 9:49 pm
Sep 2001
1234
Group Navigation
period‹ prev | Sep 2001 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions200
posts557
users223
websitedbi.perl.org

223 users for September 2001

Sterin, Ilya: 45 posts Tim Bunce: 37 posts Wilson, Doug: 24 posts Bart Lateur: 17 posts Steve Howard: 10 posts Hardy Merrill: 9 posts Dan Horne: 8 posts Rob Ransbottom: 7 posts Stephen Clouse: 7 posts Steven Lembark: 7 posts Lbaxter: 6 posts Ivan Adzhubei: 6 posts Jay Strauss: 6 posts Karina Nahagama: 6 posts Peter J . Holzer: 6 posts Lokmane: 5 posts Andrey Bronfin: 5 posts Ronald J Kimball: 5 posts Steven Vetzal: 5 posts Wojciech Pietron: 5 posts
show more
Archives