FAQ

Search Discussions

90 discussions - 364 posts

  • well the ABSTRACT says it all... I regurgitate: <quote DBIx::DBH is designed to facilitate and validate the process of creating DBI database connections. It's chief and unique contribution to this ...
    Terrence BrannonTerrence Brannon
    Dec 1, 2004 at 2:37 am
    Dec 9, 2004 at 9:26 am
  • Tim Bunce wrote on 30 November 2004 23:32 In my case because if I connect to the same database from two different servers with two different versions of Sybase Open Client then DBD::Sybase and the ...
    Orton, YvesOrton, Yves
    Dec 1, 2004 at 11:53 am
    Dec 17, 2004 at 10:32 am
  • Here's another example of a cut of code that doesn't perform as expected. It's as if the selectrow_array() function is dying, as in (to) die. if (! database_exists($database)) { print qq(<b Database ...
    Ron WingfieldRon Wingfield
    Dec 27, 2004 at 2:26 am
    Dec 28, 2004 at 12:59 pm
  • Hi there, I am trying to install DBD-Oracle with PPM Its giving me the error:- Error installing package 'http://theoryx5.uwinnipeg.ca/ppmpackages/DBD-Oracle.ppd': Could not locate a PPD file for ...
    Vivekananda MarellaliVivekananda Marellali
    Dec 14, 2004 at 12:53 pm
    Dec 17, 2004 at 1:57 pm
  • Been working on this for a few days & haven't had any luck: I have read all of the help files & searched the internet.... I still cannot find out what my problem is. I am running winxp pro (sp2), vis ...
    Bryan ScottBryan Scott
    Dec 13, 2004 at 12:08 am
    Dec 19, 2004 at 4:49 pm
  • Hi, I am trying to install DBD-Oracle-1.16 along with DBI-1.46 DBI was installed successfully, but got errors intalling the DBD-Oracle-1.16. C:\Perl\DBD-Oracle-1.16 perl Makefile.pl Log: *** You're ...
    John BerryJohn Berry
    Dec 14, 2004 at 1:42 pm
    Dec 18, 2004 at 6:46 am
  • I am trying to save windump network trace files in MySQL. The following piece works, and am able to insert into MySQL, but only a small piece of this 50MB file is in there!!! Does anybody know what ...
    OITOIT
    Dec 13, 2004 at 5:32 pm
    Dec 15, 2004 at 12:21 pm
  • Greetings all; A question regarding setting NLS_DATE_FORMAT and getting DBI to obey it... With the code below, the statement fails to retrieve data although I know it is there. However, if I modify ...
    Stacy MaderStacy Mader
    Dec 3, 2004 at 12:17 am
    Dec 6, 2004 at 3:05 pm
  • Can you provide just wee bit more information? Such as: What is RT? What is the Perl Version (perl -V would be helpful output) What is the Database Version? A Transcript of your build and install ...
    Lincoln A. BaxterLincoln A. Baxter
    Dec 1, 2004 at 6:25 am
    Jan 20, 2005 at 11:29 am
  • "\" characters in bytea columns are not being escaped correctly; --- |- use DBI; $dbh = DBI- connect('dbi:Pg:dbname=tangram', "samv", "") or die $DBI::errstr; $dbh- do( << "SQL"); CREATE TABLE foo ( ...
    Sam VilainSam Vilain
    Dec 23, 2004 at 7:48 am
    Jan 6, 2005 at 8:47 pm
  • Hi pals, this is my first post to this mailing list. I have one problem, it is maybe for you small, but for me a big problem. If I want improve my scripts I _have_ to use parallel DB access. When I ...
    Ing. Branislav GerzoIng. Branislav Gerzo
    Dec 29, 2004 at 8:36 am
    Dec 29, 2004 at 10:53 pm
  • when I simply use perl DBI, DBD::ODBC to connect to the database and try to extract the Unicode string( there is Chinese, Japanese, Korea) string stored in it, the return value is unreadable. I wish ...
    Yonghui WangYonghui Wang
    Dec 9, 2004 at 9:09 pm
    Dec 10, 2004 at 6:43 am
  • Hi, I am using MySQL 4.0.21. Following is the problem: I want to Select ID from Reporter where Attributes_ID = something and then use the resultant IDs to find Select ID from Feature where ...
    Kaustubh shindeKaustubh shinde
    Dec 10, 2004 at 8:04 pm
    Dec 13, 2004 at 3:36 pm
  • Hi Perl Gurus, I have a perl script that accesses a BLOB of data from the DB. The data is zipped data and I need to be able to get the blob data, unzip it and then read the data (the data i zipped ...
    NRKNRK
    Dec 5, 2004 at 12:01 am
    Dec 8, 2004 at 4:48 pm
  • Hi Guys, I 've used below code to encrypt password using perl module (library) called 'Crypt::PasswdMD5" and saved it to a file. e.g. "vprasad:$1$121154.6$CeoM.iep2C7nx0ePmUaW10". use ...
    Veera PrasadVeera Prasad
    Dec 30, 2004 at 4:30 pm
    Dec 30, 2004 at 10:03 pm
  • Hello everyone, I'm having difficulty solving this code problem. I can load a popup list of states from a "states" table, but I can't seem to get-it-right when I execute a SHOW, rather than a SELECT ...
    Ron WingfieldRon Wingfield
    Dec 29, 2004 at 6:03 pm
    Dec 29, 2004 at 7:12 pm
  • I'm trying to install DBD::MySQL onto a SUSE Linux machine with the 2.4.19 kernel. I have perl 5.8.6 built for i686-linux and mysql Ver 14.7 Distribution 4.1.7 for pc-linux (i686). I have tried ...
    Tony McCrayTony McCray
    Dec 24, 2004 at 2:08 am
    Dec 24, 2004 at 2:18 pm
  • Hi, Yesterday merlyn posted a review copy of an upcoming article to the cdbi-talk list where he used the info supplied by $dbh- foreign_key_info('','','','','',$table); to automatically setup has_a ...
    Sebastian RiedelSebastian Riedel
    Dec 15, 2004 at 12:09 am
    Dec 16, 2004 at 9:44 am
  • Hello, I am sure this question has come up hundreds of times, but I must ask it again: Are bind_param_array() and array_execute() fully implemented in the DBD::Oracle driver?? If they are, is there ...
    Kieran HagzanKieran Hagzan
    Dec 8, 2004 at 4:51 pm
    Dec 9, 2004 at 8:55 pm
  • Hello all- No doubt this question has been asked but I'm mailing to this last as a last resort after nearly a full day of google searching for the results as I hate asking questions that seem so ...
    Mike GarnerMike Garner
    Dec 8, 2004 at 3:48 pm
    Dec 9, 2004 at 3:22 pm
  • hi, I am trying to query an database through a for loop (multiple query).As soon as it goes to second loop the hash (i use for storing sql results) gives a problem.it seems like hash need to be ...
    Dbsavvy2002-perlDbsavvy2002-perl
    Dec 7, 2004 at 10:43 pm
    Dec 8, 2004 at 12:30 pm
  • Hello, I was under the impression that placeholders would work in ODBC. I was hoping this was the case as I don't want to rewrite my code that works under mySQL. I'm trying to insert into MS SQL ...
    Brian RoyBrian Roy
    Dec 4, 2004 at 10:42 pm
    Dec 5, 2004 at 10:26 pm
  • Hi, I've got a problem with a simple fetch which just takes hours (literaly) to complete. It's a simple select statement which, in the current case, returns about 300 rows within seconds. But the ...
    Schoenwaelder OliverSchoenwaelder Oliver
    Dec 1, 2004 at 12:08 pm
    Dec 1, 2004 at 1:32 pm
  • Hi list, how do I specify alias in DBI/DBD-Oracle select to_char(mf.ROW_MOD_DATE,'MM/DD/YYYY') "Modify Date", mf.mf_name "Manufacture" from table1 mf DBI/DBD doesn't like double quotes, is there any ...
    RobertRobert
    Dec 25, 2004 at 2:48 am
    Dec 27, 2004 at 3:08 am
  • I googled and found a reference to this, but the link was dead :-( There no longer appears to be anything in the mail archive. DBD::Sybase::db do failed: Server message number=2762 severity=16 ...
    Anderson, James (Company IT)Anderson, James (Company IT)
    Dec 23, 2004 at 2:10 pm
    Dec 23, 2004 at 8:41 pm
  • DBD::Oracle 1.16 Oracle 10g (client 10.1.0.3) Red Hat Enterprise Linux ES release 3 (Taroon Update 3) Perl 5.8.6 (multithreaded disabled) NLS_LANG="AMERICAN_AMERICA.AL32UTF8"; NLS_NCHAR="AL32UTF8" I ...
    Alan SeegmillerAlan Seegmiller
    Dec 22, 2004 at 1:12 am
    Dec 22, 2004 at 11:27 am
  • Hi I am pulling my hair out with a simple install. I have two HP-UX servers, one Itanium and the other PA-RISC, both running Oracle 9i, HP-UX 11.11, Perl 5.8 and with gcc 3.4.2. Installation and use ...
    Simon WindsorSimon Windsor
    Dec 17, 2004 at 1:35 pm
    Dec 18, 2004 at 4:34 am
  • I am a total perl newbie and was wondering if someone could take a look at my code to determine if I am doing this the most efficient way. It works as it should, but I am sure an expert out there may ...
    Follett, RobertFollett, Robert
    Dec 16, 2004 at 10:30 pm
    Dec 17, 2004 at 1:45 pm
  • Hi Sam, Sorry for cross posting, was trying to get some solution faster. No other intentions. New to this. I have checked the following earlier and now but not found any clues for my issue. ...
    John BerryJohn Berry
    Dec 15, 2004 at 3:01 am
    Dec 16, 2004 at 2:50 pm
  • I'm getting the above error on a new machine set up with perl 5.8.0 DBD-Oracle 1.16 and DBI 1.46. This triggers the error ... $cursor=$dbh- prepare(<<__SQL__); select data_type, data_length, ...
    Dan OsborneDan Osborne
    Dec 6, 2004 at 5:04 pm
    Dec 8, 2004 at 12:48 am
  • Greeting, all, I have a script which converts query output into Excel spread sheet which is working fine, I am a UNIX scripting guy and I am having difficulty making some simple changes to the ...
    RobertRobert
    Dec 1, 2004 at 3:53 pm
    Dec 2, 2004 at 4:39 am
  • Hi there again, this may not be the best forum to ask this question but I don't think there is a DBD::Oracle list available. Does anyone have a script that can convert a mysqldump file to a sqlplus ...
    Maldonado, Daniel CW2 CTARNGMaldonado, Daniel CW2 CTARNG
    Dec 29, 2004 at 6:42 pm
    Dec 30, 2004 at 2:10 am
  • We have a new DBD install that is giving us trouble. The perl files are linked from a directory /obase/tools/perl/perl to /usr/bin/perl. The DBD is installed in the /obase/tools/perl/dbd directory. ...
    Peter BarnettPeter Barnett
    Dec 23, 2004 at 8:15 pm
    Dec 24, 2004 at 2:52 am
  • I would like to the specify the USE argument dynamically as for example: USE $database; Apparently, the scalar is not recognized (compile error). Is it possible to provide a dynamic insertion such ...
    Ron WingfieldRon Wingfield
    Dec 23, 2004 at 5:32 pm
    Dec 23, 2004 at 5:42 pm
  • Hiya I was wondering if someone could help me. I am trying to extract some information from a database using perl scripts. I have download active perl and mysql. I have also downed the perl mod ...
    Harvinder AtwalHarvinder Atwal
    Dec 21, 2004 at 3:19 pm
    Dec 21, 2004 at 10:42 pm
  • Dear Tim Bunce, Could you please let me know what the status is on the availability of Oracle::OCI ? It isn't in CPAN yet, and I haven't been able to google up a beta version. Thanks
    Teddy ChoiTeddy Choi
    Dec 20, 2004 at 7:55 pm
    Dec 21, 2004 at 3:23 pm
  • Well I am having some trouble getting DBD::ODBC up and running and so here I am. I was unable to get to http://www.fugue.com/dbi, but I sent an email to the dbi-requests email address. I am not even ...
    RconnerRconner
    Dec 20, 2004 at 11:49 pm
    Dec 21, 2004 at 11:00 am
  • Hi, how do I use like as bind variables, eg: select * from users where user.tel like '49755%'. could xou make an example? thks. xaver
    Xaver bitonXaver biton
    Dec 19, 2004 at 3:55 am
    Dec 19, 2004 at 12:35 pm
  • Original Message Hi,Tim Bunce I am presently working on a project on CGi for my 7sem Cs course Am unable to trace a DBI and DBD-ODBC packages for perl. Tried some sources ...
    Govind tarcarGovind tarcar
    Dec 18, 2004 at 8:24 am
    Dec 18, 2004 at 3:07 pm
  • Fellow DBI Users, Tim Bunce has asked me to help revise the NULLs subsection in the "Placeholders and Bind Values" section in the DBI documention for DBI 1.47. Attached is the proposed text to be ...
    CAMPBELL, BRIAN D (BRIAN)CAMPBELL, BRIAN D (BRIAN)
    Dec 16, 2004 at 5:33 pm
    Dec 17, 2004 at 2:13 am
  • There's a few bugs in the code of the section of LongReadLen, even in the latest version of DBI that is on CPAN. I quote: If you can't be sure what value to use you could execute an extra select ...
    Bart LateurBart Lateur
    Dec 11, 2004 at 12:48 am
    Dec 13, 2004 at 10:27 am
  • Are there any gotchas for installing it? Robert
    RobertRobert
    Dec 10, 2004 at 1:27 am
    Dec 10, 2004 at 11:27 am
  • I am trying to use Informix with Apache::Session, but keep on getting problems. In short, it seems like Informix doesn't want to "release" the the database connections timeously, which then causes ...
    Tielman de VilliersTielman de Villiers
    Dec 8, 2004 at 4:18 pm
    Dec 9, 2004 at 9:40 am
  • To: 'Graeme St. Clair'; dbi-users@perl.org Subject: RE: Windows to Oracle Ok -- how about this. Try (re)-reading the link I posted and tell me what I can do to improve it for you (i.e. ask me ...
    Graeme St. ClairGraeme St. Clair
    Dec 1, 2004 at 2:20 am
    Dec 4, 2004 at 10:16 pm
  • <Adjusted from top post, which is frowned on, to bottom/intersperse Jan 28th Conversation: From: liooil Response by: Paula No, the right list is the DBI-Users list ...
    Capacio, Paula JCapacio, Paula J
    Dec 29, 2004 at 10:24 pm
    Mar 7, 2006 at 6:33 pm
  • Sorry if double posted: Got a delivery error on liooil's eaddr and correcting <Adjusted from top post, which is frowned on, to bottom/intersperse Jan 28th Conversation: From: liooil Response by: ...
    Capacio, Paula JCapacio, Paula J
    Dec 29, 2004 at 10:29 pm
    Mar 7, 2006 at 6:27 pm
  • Hi, I installed ActivePerl- 5.8.6.811-MSWin32 opened MS-DOS window wrote ppm and then install DBI. The respond I got was : Error : No Valid repositories: Error : 500 Can't connect to ...
    Bender Eliyahu-Yosef-BEB067Bender Eliyahu-Yosef-BEB067
    Dec 29, 2004 at 4:05 pm
    Dec 30, 2004 at 1:43 am
  • HI, I'm trying to install DBD-mysql-2.9004. I run perl Makefile.PL I got the error that mysql_config can't be found. I have found mysql_config on my system (Raq3, perl v5.6.1 built for i586-linux) at ...
    Jim ByrneJim Byrne
    Dec 24, 2004 at 10:04 am
    Dec 24, 2004 at 10:58 am
  • Hi, I'm trying to install DBI module on my raq3 to connect with my Mysql databases. When I run the Makefile.PL for the latest version of the DBI module it quits with the error message: "Perl 5.006 ...
    Jim ByrneJim Byrne
    Dec 23, 2004 at 12:32 pm
    Dec 23, 2004 at 12:53 pm
  • I get the following error when I try to use $dbh = DBI- connect ($ORACLE_SID, $login, $password, "Oracle"); anyone have a clue? /usr/lib/dld.sl: Unresolved symbol: nlepeinit (code) from ...
    Maldonado, Daniel CW2 CTARNGMaldonado, Daniel CW2 CTARNG
    Dec 21, 2004 at 7:56 pm
    Dec 22, 2004 at 2:20 am
Group Navigation
period‹ prev | Dec 2004 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions90
posts364
users124
websitedbi.perl.org

124 users for December 2004

Tim Bunce: 37 posts Ron Wingfield: 18 posts Jeff Urlwin: 13 posts Michael A Chase tech: 12 posts Reidy, Ron: 12 posts Lincoln A. Baxter: 11 posts Michael Peppler: 10 posts Hardy Merrill: 9 posts Ron Savage: 8 posts Christopher Hicks: 7 posts Vivekananda Marellali: 6 posts John Berry: 6 posts OIT: 6 posts Orton, Yves: 6 posts Andy Hassall: 5 posts Greg Sabino Mullane: 5 posts Jeff Zucker: 5 posts John Siracusa: 5 posts Sam Vilain: 5 posts Bart Lateur: 4 posts
show more
Archives