FAQ

Search Discussions

158 discussions - 541 posts

  • I designed a simple script to backup my MySQL databases. Basically it loops through all the databases then through each table. This section of code retreives the table and writes it to a csv file. ...
    Jamin RothJamin Roth
    Jun 7, 2003 at 12:26 am
    Jun 10, 2003 at 9:41 am
  • #!/usr/local/bin/perl -w use strict; use DBI; my $dbh = DBI- connect($data_source, $username, $password) my $i; for ($i=1;$i<=100000000;$i++){ # memory leak is here my $j=$dbh- ...
    Монашёв МихаилМонашёв Михаил
    Jun 28, 2003 at 9:35 pm
    Jun 30, 2003 at 7:14 pm
  • I will be releasing a significantly upgraded SQL::Statement and DBD::File shortly and I have some questions about interface. I'd really appreciate some feedback. These are the features that are near ...
    Jeff ZuckerJeff Zucker
    Jun 4, 2003 at 4:19 pm
    Jun 5, 2003 at 9:16 pm
  • Hello other DBI Users I use MySQL text fields as general repositories for code, data etc but find that numbers are rounded to two decimal places. This does not happen with a similarly constructed ...
    Robbie ArmourRobbie Armour
    Jun 22, 2003 at 2:29 am
    Jun 27, 2003 at 8:49 am
  • Hello all, this topic has been discussed several times, i know. But i have not seen a solution by now. On UNIX i can open an Oracle DB "connect internal" connection by $ sqlplus "/ as sysdba" when i ...
    Christian MerzChristian Merz
    Jun 5, 2003 at 9:32 am
    Jun 6, 2003 at 7:50 pm
  • I am intalling DBI on a Sun workstation. Since I don't have root access, I simply put DBI.pm in ~/perl, and then add it to @INC at runtime via use lib "$ENV{HOME}/perl"; However, while my perl script ...
    Antonio GarciaAntonio Garcia
    Jun 5, 2003 at 5:02 pm
    Jun 5, 2003 at 8:34 pm
  • I am currently working on developing a User Account Management system. The environment I support currently has about 80 servers, and a user community of several hundred. I currently have a Account ...
    NIPP, SCOTT V (SBCSI)NIPP, SCOTT V (SBCSI)
    Jun 10, 2003 at 8:06 pm
    Jun 19, 2003 at 11:20 pm
  • Greetings. Maybe the answer for my question will be RTFM, but i still cant find it myself. The problem is: i need to fetch just list, contains column names - and i dont know how to do it. I didnt ...
    Anthony NickolayevAnthony Nickolayev
    Jun 9, 2003 at 11:33 pm
    Jun 11, 2003 at 5:09 pm
  • Hi, is it possible if I have $a="SELECT FROM table WHERE language= english"; and I want to put the statment as text into the database like so INSERT INTO selecttable values(?); $sth- execute($a); I'm ...
    AnthonyAnthony
    Jun 5, 2003 at 1:13 pm
    Jun 5, 2003 at 11:07 pm
  • When I execute this program it is giving the following error about missing comma Company is Comp1 with comp_number 100 inserting company_number 100 for company Comp1 DBD::Oracle::st execute failed: ...
    RobertRobert
    Jun 4, 2003 at 6:16 pm
    Jun 5, 2003 at 10:39 am
  • I'm trying to find a way of using DBI's internal knowlege of how bind var's are managed to format a working query for error messages. I normally use placeholders with execute or selectall*. This ...
    Steven LembarkSteven Lembark
    Jun 12, 2003 at 8:34 pm
    Jun 19, 2003 at 3:56 pm
  • We recently migrated our site from DBI-1.21 to 1.37 and have noticed that our DBD::Ingres installation broke. We were running DBD::Ingres-0.32, but I also attempted to upgrade to 0.36 and am having ...
    David CoulthartDavid Coulthart
    Jun 27, 2003 at 4:03 pm
    Jul 3, 2003 at 11:23 am
  • Hi Was wondering if anyone has a working example / code of a perl DBI connection to an ORACLE db, where the select statement for eg. contains the SQL function DECODE. I've been working with my code ...
    deadtwoU wishUknewdeadtwoU wishUknew
    Jun 5, 2003 at 4:32 pm
    Jun 5, 2003 at 5:29 pm
  • Hi there, To make it sure. My oracle client is on win2k OS and Oracle server is 8i on Solaris OS. Perl: ActivePerl 5.6 DBI version : 1.35 DBD::Oracle version is 1.12 I have tried to fetch a BLOD ...
    David KuoDavid Kuo
    Jun 24, 2003 at 7:06 pm
    Jun 25, 2003 at 1:38 am
  • hi! I'm not sure this is supposed to work yet.... I write utf-8 into mysql - that seems to work. but when I read it back, not only do I get a "classical perl string" instead of an utf8 string, but ...
    Brigitte JellinekBrigitte Jellinek
    Jun 17, 2003 at 9:58 am
    Jun 18, 2003 at 12:57 pm
  • Heya folks I've recently upgraded the DBI and DBD packages on a development server, and I'm now getting some new error messages that are raising some concern. I found references to recent changes ...
    John CougarJohn Cougar
    Jun 12, 2003 at 2:03 am
    Jun 16, 2003 at 8:44 am
  • DBD::Pg 1.30 is nearing release, and you can grab a copy of the latest beta at: http://www.remotelinux.com/rlippan/DBD-Pg-1.30_2.tar.gz There are many changes in this release and large chunks of code ...
    Rudy LippanRudy Lippan
    Jun 10, 2003 at 3:10 pm
    Jun 12, 2003 at 6:47 pm
  • Hi, Recently we shifted to Oracle9i from Oracle8.1.7 on Solaris platform. We have some perl scripts which connects with the database using DBI. After migration to Oracle9i perl scripts fail to ...
    Naveed AnwerNaveed Anwer
    Jun 2, 2003 at 7:37 am
    Jun 3, 2003 at 7:09 am
  • user list, My program successfully connected to oracle DB and performed all sql statements, but if I uses perl.exe -w then I got the following warnings. (Note: the script is still working and ...
    Chang, MeiChang, Mei
    Jun 24, 2003 at 4:43 pm
    Aug 22, 2003 at 1:20 pm
  • Hi All I am running the following script. Using ODBC for the first time <snip #!D:\Perl\bin\perl use Win32::ODBC; use DBI; use CGI qw(:standard); use CGI::Carp qw(fatalsToBrowser); my $dbh = new ...
    Aman RahejaAman Raheja
    Jun 27, 2003 at 8:53 pm
    Jul 1, 2003 at 3:00 pm
  • I recently upgrading a Win32/Activestate system to ActiveState build 806 with DBD::ODBC 1.05 and DBI 1.37. I find that I now get errors of the following type when I try to create a view over ...
    Brian McCauleyBrian McCauley
    Jun 23, 2003 at 12:59 pm
    Jun 24, 2003 at 11:00 am
  • Hi, I am a perl developer going to install Perl DBI in solaris which require make utility. But I don't have a C compiler on my UNIX Box. Is there any pre compiled version of Perl:DBI and DBD:Oracleis ...
    Biswajeet PadhyBiswajeet Padhy
    Jun 13, 2003 at 5:41 pm
    Jun 20, 2003 at 11:25 pm
  • They claim that the error does not occur when the "RETURNING linegraph(*)..." clause is removed. Alas, I don't have an Oracle instance handy to test with, but was wondering if "SELECT X, SUM(X) FROM ...
    Dean ArnoldDean Arnold
    Jun 4, 2003 at 3:13 pm
    Jun 4, 2003 at 5:59 pm
  • Okay, this is probably a basic question, but I can't find it. How do you call a stored procedure in Informix. The stored procedures I want to call don't return anything, and take zero to two ...
    Christopher MihalyChristopher Mihaly
    Jun 25, 2003 at 9:27 am
    Jun 28, 2003 at 6:12 pm
  • Can anyone tell me if DBI can run Oracle stored procedures and if so how? I'm not familiar with Oracle but I have a requirement to write a script which will be ran in a UNIX cron. This script will ...
    Ronnie CruickshankRonnie Cruickshank
    Jun 27, 2003 at 9:45 am
    Jun 28, 2003 at 1:23 am
  • I have tried and tried to compile DBD-DB2 and although the compile works once the nolimit is remove, I am not able to connect. I have tried: 1. Remove nolimit in Makefiles (would not compile unless ...
    Craig SharpCraig Sharp
    Jun 26, 2003 at 2:44 pm
    Jun 26, 2003 at 4:17 pm
  • HI, I am running the Perl DBI interface which connects to a Oracle 8.1.7 database. This all works fine. The problem that I have is that when I run a particular script ( show below) the dataset that ...
    Trevor MorrisonTrevor Morrison
    Jun 25, 2003 at 3:57 pm
    Jun 25, 2003 at 4:31 pm
  • In the code that follows, I want to return a 1 if there is an error, in this case, my error would be if the select does not return a sri_person_id. I have tried this numerous ways, but have yet ot ...
    Christopher G TantaloChristopher G Tantalo
    Jun 24, 2003 at 7:20 pm
    Jun 25, 2003 at 12:15 pm
  • Hi! I`ve got a C++ function like this: int CDBPostgres::getRowCount() { return m_pgbase- Tuples(); } Can anybody explain me, how I can write this in Perl? I need it like this: int ...
    Henner01Henner01
    Jun 24, 2003 at 1:20 pm
    Jun 25, 2003 at 3:38 am
  • Greetings, On a fully patched box running sparc Solaris 8, with perl 5.8.0 and MySQL 4.0.13, when I try to run the following test script, I get a core dump: ----------------------------------------- ...
    BuffaloBuffalo
    Jun 23, 2003 at 1:47 pm
    Jun 23, 2003 at 9:52 pm
  • Hi, I don't understand nothing with SQL. I do this $dbh= DBI- connect.............. $sth=$dbh- prepare(qq(SELECT longitude, latitude FROM place WHERE userid='?')) or die...; $sth- execute($userid) or ...
    AnthonyAnthony
    Jun 20, 2003 at 6:46 pm
    Jun 23, 2003 at 4:20 pm
  • Hi, Just noticed this problem when my database was down: #!/usr/bin/perl -w use DBI; my $dbh = DBI- connect("dbi:ODBC:testviagamb", "Fred", "Bloggs"); Use of uninitialized value in concatenation (.) ...
    Martin J. EvansMartin J. Evans
    Jun 13, 2003 at 10:52 am
    Jun 20, 2003 at 5:25 pm
  • Friends, I've worked with DBD::Oracle on various Linux and Digital boxes with no problems. I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from scratch: Perl 5.8.0 built with xlc_r With ...
    Rafael CaceresRafael Caceres
    Jun 16, 2003 at 10:56 pm
    Jun 20, 2003 at 6:13 am
  • I've been beating my head against my monitor trying to figure out how to force ODBC version 2.0 behavior instead of 3.0 in DBD::ODBC. I've gone through the man pages, all the online docs that I can ...
    Todd MorreyTodd Morrey
    Jun 16, 2003 at 4:18 pm
    Jun 19, 2003 at 9:21 pm
  • -------------------------------------------------- Here is a message for you from http://web2mail.com The easy way to read and send POP email on the web ...
    Krob427Krob427
    Jun 13, 2003 at 1:59 pm
    Jun 16, 2003 at 3:58 pm
  • Hello All, I'm trying to do a SELECT, process some data from the SELECT and then a little later, an INSERT OR SELECT in the same application. This is how I'm trying to do it but I'm not getting any ...
    Thomas CastonzoThomas Castonzo
    Jun 5, 2003 at 10:11 pm
    Jun 7, 2003 at 1:06 pm
  • Hi, i have a oracle database in a clustered environment (mc/sg on hpux) with locally installed oracle driver. To connect to a database, i have to set and export variables (mainly SHLIB_PATH to point ...
    Wolf, Dr. StefanWolf, Dr. Stefan
    Jun 6, 2003 at 12:43 pm
    Jun 6, 2003 at 11:18 pm
  • Hello all. I'm brand new to DBI. I installed DBI successfully but can't get the Oracle DBD to install. The command "perl Makefile.PL" fails saying that it can't find the file "oracle.mk". From the ...
    Kenny G. Dubuisson, Jr.Kenny G. Dubuisson, Jr.
    Jun 4, 2003 at 8:15 pm
    Jun 5, 2003 at 2:36 pm
  • Greetings, On a SPARC Solaris 8 box with all current patches, gcc-3.2.2 (compiled to use solaris ld and as), mysql 4.0.13, perl 5.8, and DBI 1.37, I get the following errors from "make test": ...
    BuffaloBuffalo
    Jun 3, 2003 at 8:20 pm
    Jun 4, 2003 at 5:48 pm
  • Ok, I'm horribly tired with SQL I don't know why I'm getting a bad sql statment I tried these, but i really don't see the error $mbx=DBI- connect("dbi:mysql:$db3","$db3log","$db3pass") || ...
    AnthonyAnthony
    Jun 27, 2003 at 2:21 pm
    Jun 27, 2003 at 2:37 pm
  • Hi List I'm tring to insert a timestamp Using DBI 1.14, ActiveState 5.6, Access 2000 SQL =INSERT INTO tblCar (date_now,time_now) VALUES (#06/23/2003#,#16:13#) Results in DBD::ODBC::st execute failed: ...
    ClintonClinton
    Jun 26, 2003 at 6:28 am
    Jun 27, 2003 at 4:41 am
  • I've now downloaded DBD-mysql-2.1027 into a directory called /u2/anthony I now run perl Makefile.PL from /u2/anthony/DBD-mysql-2 I now recieve this error: Can't exec "mysql_config": No such file or ...
    C KearnsC Kearns
    Jun 24, 2003 at 2:05 pm
    Jun 26, 2003 at 8:21 pm
  • hi SQL Server 2000 windows 2000 perl 5.8 i have an annoying problem with sql server, maybe someone have encountered something similar - it concerns special (danish) characters that im unable to ...
    Allan juulAllan juul
    Jun 25, 2003 at 3:36 pm
    Jun 26, 2003 at 3:01 pm
  • list, I wrote a simple test script to update Oracle database, but it hung on the line of $dbh- do($sql2). Oracle server: NT, oracle version 8.0.3 my script running on W2000, with perl 5.6.1.633, ...
    Chang, MeiChang, Mei
    Jun 19, 2003 at 4:47 pm
    Jun 19, 2003 at 9:36 pm
  • Hello, the programs I've written in Perl using DBI are not wirtten in oop. Of course I use the DBI methods and stuff os objects, but the rest of my code is none-oop. Now I want to switch this and ...
    Jan TheofelJan Theofel
    Jun 18, 2003 at 5:44 pm
    Jun 18, 2003 at 7:51 pm
  • Hi, I'm trying to setup some scripts that will allow me to use Perl DBI to INSERT into my table. However, I have not had any success at all. I'm using perl CGI as well so I've granted ALL permissions ...
    Kovalcik, Mike A [ITS]Kovalcik, Mike A [ITS]
    Jun 17, 2003 at 10:05 pm
    Jun 18, 2003 at 12:16 pm
  • Any pointers are appreciated. Make test failed at t/handle, test 12. I am running under W-XP-home. The output from Make test TEST_VERBOSE=1 is below, followed by perl -V. I have trimmed the output by ...
    Dominic RyanDominic Ryan
    Jun 15, 2003 at 2:37 am
    Jun 16, 2003 at 8:56 am
  • Hello ! When I try to read a dbf file, using XBase in PERL, I immediately have an error: 'DBD::XBase::st execute failed: Table xxxxxx not found: Missmatch in header of xxxxx: record_len 2048 but ...
    Isabel CarvalhoIsabel Carvalho
    Jun 6, 2003 at 4:09 pm
    Jun 11, 2003 at 4:53 pm
  • Hi, is it possible to submit administrative commands to oracle like "alter database ..." "alter system ..." "archive log current", or are only sql statements supported? TIA S. Wolf
    Wolf, Dr. StefanWolf, Dr. Stefan
    Jun 10, 2003 at 12:16 pm
    Jun 10, 2003 at 11:09 pm
Group Navigation
period‹ prev | Jun 2003 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions158
posts541
users187
websitedbi.perl.org

187 users for June 2003

Tim Bunce: 53 posts Michael A Chase: 22 posts Jeff Urlwin: 21 posts Jeff Zucker: 15 posts Rudy Lippan: 12 posts Alan Burlison: 10 posts Anthony: 10 posts Gold, Samuel (Contractor): 10 posts Hardy Merrill: 10 posts Igor Korolev: 10 posts Ronald J Kimball: 10 posts Andy Hassall: 9 posts Greg Hering: 8 posts Ron Savage: 8 posts Монашёв Михаил: 7 posts Antonio Garcia: 6 posts David N Murray: 6 posts Dean Arnold: 6 posts Jamin Roth: 6 posts Martin J. Evans: 6 posts
show more
Archives