FAQ

Perl > dbi-users > May 2003

Search Discussions

204 discussions - 674 posts

  • -- Cheers Ron Savage, ron@savage.net.au on 11/05/2003 http://savage.net.au/index.html
    Ron SavageRon Savage
    May 11, 2003 at 2:34 am
    May 20, 2003 at 8:38 am
  • [ DBI manpage ] "do" $rows = $dbh- do($statement) or die $dbh- errstr; $rows = $dbh- do($statement, \%attr) or die $dbh- errstr; $rows = $dbh- do($statement, \%attr, @bind_values) or die ... Prepare ...
    Alan BurlisonAlan Burlison
    May 16, 2003 at 3:46 pm
    May 17, 2003 at 7:59 am
  • I am using Perl DBI and mysqlPP to insert into a database If my data includes '?' they get replaced with NULL I have tried prefixing ? with \ but that makes no difference Any help to resolve this ...
    Mike SolomonMike Solomon
    May 14, 2003 at 1:12 pm
    May 19, 2003 at 2:33 pm
  • Hi! list, The following program only prints one column from the table, how do I print all the columns from a table. #!C:\perl\ActivePerl\Perl\bin\perl -w use DBI qw(:sql_types); my $dbh = DBI- ...
    RobertRobert
    May 14, 2003 at 6:05 pm
    May 27, 2003 at 6:18 pm
  • Hi List, I have installed DBD::DB2 drivers downloaded from Activestate on NT 2000. When I run dbish it is showing DB2 but when I choose it it is giving the following error: The dynamic link library ...
    RobertRobert
    May 27, 2003 at 8:31 pm
    May 28, 2003 at 11:14 pm
  • Hi I'm looking into how to put a private copy of the DBI [v 1.35] into my home directory [on Solaris 5.6], so far I've tried : perl Makefile.PL PREFIX=/home/l347283 perl Makefile.PL ...
    FayegibbinsFayegibbins
    May 12, 2003 at 10:49 am
    May 12, 2003 at 10:43 pm
  • hi i've moved my app to mod_perl2, Perl 5.8 and get the following error... whats wrong with the code? [Sat May 17 16:26:42 2003] [error] 896: ModPerl::Registry: DBD::ODBC::db prepare failed: (DBD: ...
    AlexAlex
    May 17, 2003 at 2:31 pm
    May 19, 2003 at 11:10 pm
  • If I try connecting to Oracle as the sys user I get the following message (Oracle 9) ORA-28009: connection to sys should be as sysdba or sysoper (DBD ERROR: OCISessionBegin) How do I do this? The ...
    Alan BurlisonAlan Burlison
    May 14, 2003 at 11:15 pm
    May 17, 2003 at 12:35 pm
  • I know this is the wrong list but this is the only one I'm subscribed to right now and someone who know knows this may be kind enough to give a quick answer. I've tried $x = `perl -cw xxx.pl`; with ...
    Bong TumanutBong Tumanut
    May 13, 2003 at 7:55 pm
    May 14, 2003 at 9:28 pm
  • This I would have to disagree with. 7.3 is just too new. Where I work (Primedia) we have several older postgres servers in production right now, but we are not planning to upgrade them anytime soon; ...
    Rudy LippanRudy Lippan
    May 8, 2003 at 2:48 pm
    May 14, 2003 at 12:33 am
  • Tried this once before, but couldn't make it... Any interest in a BOF @ OSCON @ Portland ? I plan on making it this year, and would be happy to try and arrange it, assuming there's a) a large enough ...
    Dean ArnoldDean Arnold
    May 1, 2003 at 4:28 am
    Jul 27, 2004 at 1:58 pm
  • Is DBI now, or will it be, a part of the basic perl installation? I know some modules are included when you install perl, but I don't know if DBI is one of them. sean
    Sean RoweSean Rowe
    May 21, 2003 at 2:46 pm
    May 23, 2003 at 12:51 pm
  • I still have a problem here. I have AutoCommit off as far as I can see. I have a nagging doubt that some of the code I'm calling could be maybe turning it back on, but I think that's unlikely. Both ...
    Steve SapovitsSteve Sapovits
    May 1, 2003 at 10:27 pm
    May 2, 2003 at 6:35 pm
  • hi i've got some very very complex sql statements and i'd like to merge some SQL requests to make it a little bit easier. the requests are full of subselects and i'd like to make it easier. therefor ...
    AlexAlex
    May 13, 2003 at 6:42 am
    May 14, 2003 at 5:15 pm
  • I recently, wiped my test machine and installed Red Hat 9 on it (used to be 7.2). So, I got a new threaded Perl 5.8.0 as well. The version of DBI went from 0.89 to 1.35 as well. I noticed that a ...
    Bill MarrsBill Marrs
    May 9, 2003 at 6:50 pm
    May 13, 2003 at 10:19 am
  • Is there any way I can recover the DSN from $dbh? I have a number of Perl functions that take as an argument a DBI database handle and read data from the database which can reasonably be assumed not ...
    Brian McCauleyBrian McCauley
    May 30, 2003 at 3:37 pm
    May 30, 2003 at 5:17 pm
  • file: $CPAN/authors/id/T/TI/TIMB/DBI-1.37.tar.gz size: 294495 bytes md5: 0113d0f47cf13b0694e0bfb2d13a5789 =head2 Changes in DBI 1.37, 15th May 2003 Fixed "Can't get dbh- {Statement}: unrecognised ...
    Tim BunceTim Bunce
    May 15, 2003 at 6:25 pm
    May 25, 2003 at 12:16 am
  • I have a big dilemma.....I am trying to INSERT into a table. I'm using DBI::CSV and I can't seem to get the following bit of code to INSERT. I can Select just fine, but when I try to insert, it ...
    Michael KovalcikMichael Kovalcik
    May 10, 2003 at 10:18 pm
    May 13, 2003 at 3:41 pm
  • Hi there, <arne@alamut.de i hope this is the right list to ask, if not maybe someone can point me to that place... i am trying to use DBD-ODBC 1.05 on a win2k machine with active-state perl 5.8. My ...
    Arne BerninArne Bernin
    May 2, 2003 at 12:32 pm
    May 5, 2003 at 1:05 pm
  • Hi, I have a function that returns a clob, the size of which depends on its input parameters. I'm using code like: my $dbh=DBI- connect('dbi:Oracle:server',$user,$pass,{...}) $dbh- ...
    Chris UnderhillChris Underhill
    May 2, 2003 at 9:03 am
    Jan 9, 2004 at 11:38 pm
  • Hi, how does one use LIKE and a wildcard with variable binding?? $q = qq |select * from x where y like ?|; ... $sth- execute($some_variable) where does the % go?? TIA! ...
    Thomas GoodThomas Good
    May 28, 2003 at 4:27 pm
    May 28, 2003 at 4:37 pm
  • I execute my program: [cohenj@Nekam DBD-Oracle]$ /home/cohenj/unixDBD.pl I get back: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/ActivePerl-5.8/lib/5.8.0/i686-linux-thread-multi ...
    JoebcohenJoebcohen
    May 19, 2003 at 5:27 pm
    May 22, 2003 at 2:42 am
  • Unable to make DBI-1.35 on Solaris using perl-5.6.1 SunOS ux-dev1 5.8 Generic_108528-13 sun4u sparc SUNW,Ultra-Enterprise Situation: Grab DBI from CPAN. gzip -dc blah | cpio -idv; cd DBI-1.35; perl ...
    Steven LembarkSteven Lembark
    May 13, 2003 at 10:15 pm
    May 15, 2003 at 2:00 pm
  • We have developed forum scripts in Perl-Cgi. When our script runs on the web server using mysql database we get following error. Kindly provide us the solution on urgent basis. Regards Pramod
    OMKAR \(Pramod Shanbhag\)OMKAR \(Pramod Shanbhag\)
    May 29, 2003 at 12:39 pm
    May 30, 2003 at 3:24 am
  • Anybody built and/or used perl with DBD Oracle with this version of Oracle? Pamela Schulz Sr. Software Engineer Verisign Telecommunications Division
    Schulz, PamelaSchulz, Pamela
    May 22, 2003 at 8:51 pm
    May 23, 2003 at 12:23 am
  • Hi, I don't know if it should be considered a generic perl bug, but here is the issue. For the below code, if the query does not fetch any rows, an attempt to access $val2 sometimes produces core ...
    Igor KorolevIgor Korolev
    May 21, 2003 at 3:15 pm
    May 22, 2003 at 8:42 am
  • Hello; is there someplace I can get a list of changes from one version to another? I currently have version 1.13 installed on my server and I'd like to update to the latest version, but when I look ...
    ESWESW
    May 21, 2003 at 2:38 am
    May 22, 2003 at 3:04 am
  • This patch will add back in the really nice error reporting earlier versions of the DBD::Oracle seemed to have that got lost in the transition to OCI8 a long time ago. I kept meaning to send this to ...
    Jason HittJason Hitt
    May 13, 2003 at 4:11 pm
    May 20, 2003 at 10:42 pm
  • I'm new to Oracle, having used MySQL for many years. When reading the DBD-Oracle documentation, I see that 1.14 supports Oracle 7 and Oracle 8. The problem I have is that we're using Oracle 9.2. It's ...
    Tom BrettinTom Brettin
    May 13, 2003 at 5:34 am
    May 14, 2003 at 11:52 pm
  • Hi all. Test script (perl_test.pl) produces this error (trace attached dbi_trace.2100): DBD::Oracle::st execute failed: ORA-04043: object cntx_vals does not exist (DBD NO_DATA: OCIAttrGet ...
    Maksim AnfilatovMaksim Anfilatov
    May 12, 2003 at 12:43 pm
    May 12, 2003 at 3:27 pm
  • I'm trying to migrate some Perl dbi code to a Red Hat 9 box running Perl 5.8.0 and DBI 1.3.2. The code has been in service and working fine for a couple of years on other Linux/Unix boxes but on Red ...
    R. Steven RainwaterR. Steven Rainwater
    May 7, 2003 at 6:04 pm
    May 7, 2003 at 10:06 pm
  • I have two Windows 2000 Adv Srvr Proliant DL380 G3 systems running an Oracle 9.2.0.3 Enterprise Edition RAC. I've successfully installed DBI 1.35 in a cygwin environment. However, when testing the ...
    HARMON,GARY (HP-Roseville,ex1)HARMON,GARY (HP-Roseville,ex1)
    May 23, 2003 at 9:26 pm
    Aug 17, 2003 at 4:54 pm
  • Hi, group In DBI, how can I spool the result to a file like sqlplus? Open a file handler and write one line after another is not an option, I am expecting the query will return 1 million rows. Thanks ...
    Charlie csCharlie cs
    May 13, 2003 at 7:16 pm
    Jul 17, 2003 at 7:27 pm
  • I would like to eliminate the overhead of creating a database connection each time a perl script runs. There are some caveats in the Apache::DBI man pages about creating client applications that ...
    Hmmm...Hmmm...
    May 24, 2003 at 7:15 am
    May 26, 2003 at 5:45 pm
  • Hello, I am migrating a program from Windows XP running against MySQL to Windows 2000 running against MS-SQL Server. I am getting an error on connection. The dsn setup is as follows: my $dsn = ...
    Bernard GoldenBernard Golden
    May 21, 2003 at 5:58 pm
    May 22, 2003 at 7:03 am
  • Hi list, I am trying to delete whole bunch of ques_codes for each ID, I have these ques_codes in a array and then pass this for bind_param. Looks like I am not passing the array value properly. ...
    RobertRobert
    May 19, 2003 at 8:21 pm
    May 21, 2003 at 1:16 am
  • Hi, First off, my apologies if this is a well discussed issue. I've had a hard time finding archives and I researched what I could. I'm using: Red Hat 9 (Shrike) Perl 5.8.0 (from the RedHat install) ...
    William FishburneWilliam Fishburne
    May 19, 2003 at 9:38 pm
    May 20, 2003 at 10:23 pm
  • Greetings -- I think this is an Informix-ESQLC and kernel problem, not Perl 5.8.0, DBI, nor DBD::Informix; but I thought I'd post it here in case I'm wrong... (I'm fishing in comp.databases.informix ...
    Jay HannahJay Hannah
    May 1, 2003 at 11:48 pm
    May 15, 2003 at 6:26 am
  • Hi All, I have been trying to find ways to use mySQL replication in perl. We are wanting the code to be easily switchable between using a replicated environment and using a single mySQL database. I ...
    Adam GentAdam Gent
    May 14, 2003 at 12:36 am
    May 14, 2003 at 2:20 pm
  • ORACLE_SID = [nr424024] ? NR424 ORACLE_HOME = [/home/app/oracle/product/8.0.6] ? to condition my enviroment to access my ORACLE database. If i do not run this, i get this error when i run my perl ...
    LindsayLindsay
    May 10, 2003 at 6:12 pm
    May 11, 2003 at 2:35 pm
  • I am writing a program which takes input from an xml file which can have varying numbers of elements depending upon what information the client program wishes to have inserted into the database. I ...
    Bernard GoldenBernard Golden
    May 2, 2003 at 8:01 pm
    May 3, 2003 at 1:41 am
  • Could someone please give me a suggestion on how to debug this? I have an elaborate POP3 email to MySQL DB perl script, which runs as a cron job once a minute. (Thanks for all the help, everybody :-) ...
    GreggGregg
    May 2, 2003 at 4:24 am
    May 2, 2003 at 4:56 pm
  • I am using the following code and would like someway to display errors and/or redirect on event of crash inside the IF block at about where the #ERROR COULD BE HERE point: #!c:/perl/bin/perl.exe ...
    DataondataDataondata
    May 31, 2003 at 1:53 am
    Jun 2, 2003 at 4:50 pm
  • Then I'd say it's broken. Tim.
    Tim BunceTim Bunce
    May 4, 2003 at 5:18 pm
    May 30, 2003 at 2:31 pm
  • Hi all, I can't get past the perl Makefile.PL step to get a good Makefile. I recently build perl 5.8.0 per the suggestion of the READMEs. This went OK after several iterations of trying to get cc ...
    Rick ResseggerRick Ressegger
    May 23, 2003 at 1:14 am
    May 23, 2003 at 10:25 pm
  • Hi, I am trying to code a CGI perl script. I know there are tons of CPAN libraries but I want to do this as an 'execise' to create my own app. Anyway, I went through the DBI doc and couldn't find the ...
    Moreno, Javier (GXS, Softtek)Moreno, Javier (GXS, Softtek)
    May 23, 2003 at 8:49 pm
    May 23, 2003 at 9:18 pm
  • I'm a newbie to Perl and completely lost! I have Mac OS 10.2.4, Apache 1.3.7, Perl 5.0.8 installed and MySQL 4.3.1 working I've installed DBI-1.37 - seems there were no errors. Now, invoking perl ...
    Alexei ZoubovAlexei Zoubov
    May 22, 2003 at 7:49 pm
    May 22, 2003 at 8:45 pm
  • Has anyone installed the DBI modules on AIX, and if so, do you find that DBI is a maintenance headache if you have to upgrade your database software? We use DB2 in house, and it was brought up at a ...
    Sean RoweSean Rowe
    May 21, 2003 at 2:48 pm
    May 21, 2003 at 4:46 pm
  • Hi all, I am sure you have seen this question before. Many times. How do I call a sql based stored procedure in Db2. Here is the error message I get. $ perl test2.pl DBD::DB2::db selectrow_array ...
    Bhala GhatateBhala Ghatate
    May 19, 2003 at 3:53 pm
    May 21, 2003 at 3:56 am
  • I've tried to download DBI::DBD from cpan shell and that's what I got: cpan install DBI::DBD Warning: Cannot install DBI::DBD, don't know what it is. So, what do I do next? I've already have Perl ...
    Alexei ZoubovAlexei Zoubov
    May 19, 2003 at 7:11 am
    May 20, 2003 at 7:19 am
May 2003
12345
Group Navigation
period‹ prev | May 2003 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions204
posts674
users207
websitedbi.perl.org

207 users for May 2003

Tim Bunce: 81 posts Michael A Chase: 33 posts Jeff Zucker: 21 posts Alan Burlison: 19 posts Alex: 17 posts M. Addlework: 16 posts Robert: 13 posts Ron Savage: 13 posts Jeff Urlwin: 12 posts Gold, Samuel (Contractor): 10 posts Ronald J Kimball: 10 posts Anil Menon: 9 posts Igor Korolev: 9 posts David Wilson: 8 posts Ian Harisay: 8 posts Jay Hannah: 8 posts Jonathan Leffler: 8 posts Moreno, Javier (GXS, Softtek): 8 posts Dean Arnold: 7 posts Mike Solomon: 7 posts
show more
Archives