FAQ

Perl > dbi-users > March 2005

Search Discussions

88 discussions - 302 posts

  • Hi All, Finally, a newsgroup where I haven't got a clue (most of the time) what you lot are talking about! Anyway, above statement proving my newbie status so I need help with : Retrieve email ...
    Gav....Gav....
    Mar 25, 2005 at 1:41 am
    Apr 4, 2005 at 1:13 pm
  • Hi all, I have a script that writes a single record to a single row on a GLOBALSettings table. I have a web page that does that and it does so successfully. I go into the database with SQL Server ...
    Moreno, JavierMoreno, Javier
    Mar 10, 2005 at 3:10 pm
    Mar 11, 2005 at 5:36 pm
  • Help -- I am lost trying figure out what occurs to me a really simple problem. CGI- Perl- MySQL. Users pounding data into a CGI-Perl web page feeding MySQL. If the user enters a special character it ...
    Ron StephanRon Stephan
    Mar 31, 2005 at 6:53 pm
    Apr 1, 2005 at 2:55 pm
  • I am working on a script that parses a csv file. The actual field delimiters in the file are pipes |. The problem I am running into is that if the field is empty, then the database is getting a '0' ...
    NIPP, SCOTT V \(SBCSI\)NIPP, SCOTT V \(SBCSI\)
    Mar 16, 2005 at 4:08 pm
    Mar 17, 2005 at 2:26 am
  • Hi all, Since we seem to be on the subject of Stored Procedures, I thought I'd throw my problem out there, since I can't figure out what I'm doing wrong. The SP builds a temp table, updates the ...
    David N MurrayDavid N Murray
    Mar 1, 2005 at 11:48 pm
    Mar 2, 2005 at 11:42 pm
  • Hi All, A firewall is terminating my connection with a mysql database after a period of inactivity. I've used the following code (with ref to cpan docs and connect) and it still causes a hang. ...
    Chris MastersChris Masters
    Mar 19, 2005 at 5:37 pm
    Mar 24, 2005 at 9:24 am
  • Can someone explain why I can't do the following: $ cat uu #!/usr/bin/perl -l use strict; use warnings; use DBI; my $dbname = 'foo'; my $host = 'myhost'; my $dbh = DBI- ...
    Brandon MetcalfBrandon Metcalf
    Mar 29, 2005 at 5:40 pm
    Mar 29, 2005 at 8:36 pm
  • Yes, currently Text::CSV_XS returns empty string for both empty strings and NULLs. I am considering providing an option to differentiate the two and return undef for NULLs. DBD::CSV also currently ...
    Jeff ZuckerJeff Zucker
    Mar 16, 2005 at 5:16 pm
    Mar 17, 2005 at 2:47 am
  • Hi all, This is probably a dumb question, but how do I run stored procedures with the DBI? I am using DBD::ODBC. Regards, Javier Moreno
    Moreno, JavierMoreno, Javier
    Mar 1, 2005 at 5:50 pm
    Mar 1, 2005 at 9:36 pm
  • For the same reason you wouldn't modify data in a C structure belonging to an API you're using. It violates the general software engineering principles of information hiding and encapsulation. There ...
    Rutherdale, WillRutherdale, Will
    Mar 29, 2005 at 8:53 pm
    Mar 29, 2005 at 11:34 pm
  • For the past couple of days, I have been getting blank messages from Kim Nielsen KN@uniscrap.dk every time I post to dbi-users. Anyone else? -- Jeff
    Jeff ZuckerJeff Zucker
    Mar 23, 2005 at 7:06 pm
    Mar 23, 2005 at 7:49 pm
  • Does DBI have a print method similar to the print in the old Pg.pm interface? With the old print method I could print out query results as they would appear if I ran the query directly with the ...
    Brandon MetcalfBrandon Metcalf
    Mar 23, 2005 at 5:36 pm
    Mar 23, 2005 at 7:04 pm
  • Where I can get DBI.ppd binary for Perl 5.8.6 ? I tried using 5.8.4 and it asked me to Test-Simple, when I tried to install Test-Simple.ppd , it's telling me "no suitable implementation found for ...
    Marina GreensteinMarina Greenstein
    Mar 8, 2005 at 9:01 pm
    Mar 15, 2005 at 8:51 am
  • Gentlemen, I'm hoping you can answer a question for me. I am using an XP Pro platform accessing an MSSQL 2000 server. I use ActivePerl 5.8.4 to access my database via ODBC. The latest versions of the ...
    Charles LawrenceCharles Lawrence
    Mar 8, 2005 at 8:20 pm
    Mar 11, 2005 at 8:30 am
  • I am working on a Perl MySQL problem. Basically, the script parses a text file and then checks a database table to see if it needs to be updated. If the entry is NOT in the table, it inserts the ...
    NIPP, SCOTT V \(SBCSI\)NIPP, SCOTT V \(SBCSI\)
    Mar 15, 2005 at 7:25 pm
    Apr 4, 2005 at 4:28 am
  • Hi all, I am trying to access an MS Access database via perl DBI and I am unable to. I checked the security and there is only one 'Admin' user with no password and I use that in my connection string. ...
    Moreno, JavierMoreno, Javier
    Mar 30, 2005 at 11:41 pm
    Mar 31, 2005 at 6:12 pm
  • Hi All: I have this code... #!/opt/perl64/bin/perl -w # v5.8.4 built for PA-RISC2.0-LP64 use Getopt::Long; my %optctl = (); Getopt::Long::GetOptions( \%optctl, "x!", "z!") or die "\nOption ...
    Vergara, Michael \(TEM\)Vergara, Michael \(TEM\)
    Mar 25, 2005 at 9:59 pm
    Mar 27, 2005 at 5:28 am
  • I have several cases where if I try to prepare() a statement and then execute() it, I get the following: DBD::Pg::st execute failed: ERROR: column "report_time" is of type integer but expression is ...
    Brandon MetcalfBrandon Metcalf
    Mar 23, 2005 at 9:11 pm
    Mar 23, 2005 at 10:02 pm
  • Strangely it is not giving any error. When I see the web server's log, it has no errors. Any other place to see for errors? I gave some prints after connect statement. The db handle returned by ...
    Sunil A.V.Sunil A.V.
    Mar 22, 2005 at 6:30 pm
    Mar 22, 2005 at 8:26 pm
  • This works, and demonstrates that a cursor got from PL/SQL may be passed back to PL/SQL. However, I doubt that it is necessary. Tracing shows that, if I let $sth2 go out of scope, the destructor ...
    Charles JardineCharles Jardine
    Mar 16, 2005 at 4:25 pm
    Mar 19, 2005 at 12:52 am
  • If someone has seen the error message for the following perl script please let me know. I am new to DBI and appreciate your support. use strict; use DBI; my $dbh = DBI- ...
    Appelt, DietmarAppelt, Dietmar
    Mar 18, 2005 at 8:29 pm
    Mar 19, 2005 at 12:47 am
  • ----- Forwarded message from Rouquart Wim <Wim.Rouquart@cronos.be ----- Delivered-To: tim.bunce@pobox.com X-SPF-Guess: pass (seems reasonable for Wim.Rouquart@cronos.be to mail through ...
    Tim BunceTim Bunce
    Mar 8, 2005 at 5:13 pm
    Mar 17, 2005 at 8:00 am
  • i would like to connect to a remote postgresql 8.1 server using a perl script. The machine i'm trying to connect from is running Debian and perl v5.6.1. In order to connect to the remote postgresql ...
    Gokul P. NairGokul P. Nair
    Mar 4, 2005 at 5:08 am
    Mar 4, 2005 at 6:13 pm
  • I'm able to install DBD::ODBC 1.11, however, I can not install 1.12 or 1.13. Following is a complete log of the steps used to build 1.13. If anybody has any idea what might be going on, I would ...
    Jonathan GillespieJonathan Gillespie
    Mar 2, 2005 at 6:38 pm
    Mar 3, 2005 at 1:40 pm
  • Hello, I have a database application that selects about 50,000 rows one by one, does some process in Perl, and then executes a SELECT statement for each one, with slight variations in the SQL and ...
    Mark StosbergMark Stosberg
    Mar 29, 2005 at 3:32 pm
    Apr 4, 2005 at 2:10 pm
  • To those who could help me with a problem connecting to an Oracle database on HP-UX from within a perl script that uses DBI I have a perl program on a unix (HP-UX) host(A) running Oracle 8.1.6 In the ...
    Kairam, RajKairam, Raj
    Mar 23, 2005 at 7:25 pm
    Apr 4, 2005 at 4:36 am
  • DBI Version 1.42 Can't set DBI::db=HASH(0x8fd1834)- {User}: unrecognised attribute or invalid value at //ms/dist/perl5/PROJ/DBI/1.42-5.8/lib/perl5/DBI.pm line 634, <DATA chunk 1. ...
    Anderson, James H \(Company IT\)Anderson, James H \(Company IT\)
    Mar 24, 2005 at 4:55 pm
    Mar 24, 2005 at 7:33 pm
  • Hi! This statement $SqlStr_pstes_i = "insert into zplus_pstes\@$dwh_link (PSTES_OC, PSTES_ECO_SCHAPO, PSTES_DATUM) ". "select PSTES_OC, PSTES_ECO_SCHAPO, PSTES_DATUM ". "from zplus_pstes ". "where ...
    FarkaspFarkasp
    Mar 23, 2005 at 6:56 pm
    Mar 24, 2005 at 10:10 am
  • I am having a problem install the DBD::DB2 module on my IBM server running AIX 5. I download DBI-1.48 from the CPAN site and successfully installed it. I also downloaded DBD-DB2-0.78 from the CPAN ...
    Richard RiceRichard Rice
    Mar 19, 2005 at 7:08 pm
    Mar 23, 2005 at 11:23 am
  • Hi I have a problem with text containing newline characters when using DBI:CSV. I put in a string containing a newline and I get back a string containing "\n". Please have a look at this sample code: ...
    Steffen G.Steffen G.
    Mar 21, 2005 at 5:21 pm
    Mar 22, 2005 at 4:17 pm
  • Hi to all Has anyone tried to install DBD::Oracle with success while Oracle Client is installed? In my case oci.h and some other headers were not found and i ultimately enforced to install the whole ...
    JohnJohn
    Mar 19, 2005 at 2:46 pm
    Mar 21, 2005 at 2:36 pm
  • Joachim GoernerJoachim Goerner
    Mar 17, 2005 at 8:11 am
    Mar 18, 2005 at 9:30 am
  • I want know about the deatails of the how to use DBI connectivity in perl language with MySQL database.And for the datails of the How to Insert an item into the MySQL using DBI interface in Perl ...
    Venkatesh shapurVenkatesh shapur
    Mar 15, 2005 at 4:51 am
    Mar 15, 2005 at 12:52 pm
  • Hello, I'm with one problem on connect to Pgsql I'm newbie in perl programming and DBI Driver. marcos@zeus:~/perl$ ./connect.pl install_driver(pg) failed: Can't locate DBD/pg.pm in @INC (@INC ...
    MarcosMarcos
    Mar 12, 2005 at 5:35 pm
    Mar 13, 2005 at 3:24 pm
  • I've not seen any new messages on dbi-users since Friday, and I'm curious to know whether there's a breakage in the list, or whether something else is up (like I've been unsubscribed). -- Jonathan ...
    Jonathan LefflerJonathan Leffler
    Mar 6, 2005 at 11:58 pm
    Mar 7, 2005 at 3:41 pm
  • I am using dbd::mysql on activestate perl 5.8. When I select a row in my program, change the row using the mysql administrator tool, and select the row again in the program, the results are not ...
    David NicolDavid Nicol
    Mar 28, 2005 at 6:10 pm
    Mar 29, 2005 at 8:44 pm
  • Hi Tim, I was wondering if it is possible to use mysqlhotcopy to use rsync instead of cp in order to make an incremental backup of a database. cp is the only copy method supported, but if you ...
    Jesus AltuveJesus Altuve
    Mar 27, 2005 at 12:12 am
    Mar 28, 2005 at 2:34 pm
  • Dear all, I have a simple program to delete spam comments from Wordpress. How do I return the number of comments deleted? Current code: #!/usr/bin/perl use warnings; use strict; use DBI; my $db = ...
    Gavin HenryGavin Henry
    Mar 27, 2005 at 4:58 pm
    Mar 27, 2005 at 7:08 pm
  • ----- Forwarded message from Qaseem Shaikh <qaseemshaikh@yahoo.com ----- Delivered-To: tim.bunce@pobox.com X-SPF-Guess: pass (seems reasonable for qaseemshaikh@yahoo.com to mail through ...
    Tim BunceTim Bunce
    Mar 25, 2005 at 8:47 pm
    Mar 25, 2005 at 10:19 pm
  • Using DBD::Oracle on Linux 2.4.19 (i686), I get the following somewhat unexpected behavior: $ DBI_PUREPERL=2 perl -MDBI -e'DBI- connect("dbi:Oracle:ourserver","u","p")' Had to create DBI::_dbistate ...
    Warfield, BenWarfield, Ben
    Mar 21, 2005 at 11:29 pm
    Mar 22, 2005 at 9:08 pm
  • Oracle has a syntax for nested selects. E.g. select a, cursor(select b, ....) ..... In each row fetched from such a select, some of the column values are themselves result sets. DBS::Oracle version ...
    Charles JardineCharles Jardine
    Mar 16, 2005 at 5:13 pm
    Mar 17, 2005 at 8:17 pm
  • James B SchmidtJames B Schmidt
    Mar 9, 2005 at 9:02 pm
    Mar 17, 2005 at 8:07 pm
  • Hi all who help others, i would like to create a database handle to informix database on alpha maschine. what do i have: # uname -a OSF1 trm61 V4.0 878 alpha # /usr/informix/bin/tbstat -z RSAM ...
    PerlDiscuss - Perl Newsgroups andPerlDiscuss - Perl Newsgroups and
    Mar 15, 2005 at 7:59 pm
    Mar 16, 2005 at 1:06 pm
  • Perl dbi users: (This task might be able to be done independent of the DBI). I am trying to format and parse a colon-delimited MS Access .LDB (Locking Database) file out to a .csv file but really ...
    Willis, Frank AWillis, Frank A
    Mar 14, 2005 at 9:21 pm
    Mar 14, 2005 at 9:39 pm
  • Hello Has anyone tried the MySQL::Backup module with sucess? I tried, but the export didn't go well.
    JohnJohn
    Mar 11, 2005 at 3:54 pm
    Mar 11, 2005 at 4:04 pm
  • I just tripped over a curious thing. It turned out that my d-b contained the occasional column with accidental leading blanks. I altered the query to:- SELECT TRIM(LEADING ' ' FROM CUST_NAME) AS CN, ...
    Graeme St. ClairGraeme St. Clair
    Mar 10, 2005 at 9:53 pm
    Mar 11, 2005 at 1:54 am
  • I was trying to get DBD::Oracle9, off of there but I get a connection error... Robert
    RobertRobert
    Mar 31, 2005 at 3:51 pm
    Apr 4, 2005 at 1:18 pm
  • Hi, I am trying to fetch data from CLOB datatype in Database. I am getting an Error as : error:ORA-03127: no new operations allowed until the active operation ends (DBD ERROR: OCISessionEnd). I guess ...
    Rishi Bansal, Japan ITRishi Bansal, Japan IT
    Mar 18, 2005 at 5:39 am
    Apr 4, 2005 at 4:31 am
  • Just my opinion, but I don't think this is good advice. For one, it creates extra administration on the system, by forcing the user/programmer /sysadmin/webadmin to create an ODBC DSN setting for ...
    AmonotodAmonotod
    Mar 31, 2005 at 3:03 pm
    Apr 3, 2005 at 8:12 pm
  • Basically we are trying to establish a database connection from an HPUX box running on a network. Our database server is remote on another HPUX box. We have Perl 5.8.6 installed with all the current ...
    Cory CoxCory Cox
    Mar 31, 2005 at 5:52 pm
    Apr 1, 2005 at 8:27 am
Mar 2005
12
Group Navigation
period‹ prev | Mar 2005 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions88
posts302
users111
websitedbi.perl.org

111 users for March 2005

Brandon Metcalf: 15 posts Jeff Zucker: 15 posts Tim Bunce: 15 posts Michael A Chase tech: 13 posts Hardy Merrill: 11 posts Reidy, Ron: 11 posts Ronald J Kimball: 11 posts Kevin Carothers: 8 posts David N Murray: 7 posts Moreno, Javier: 7 posts NIPP, SCOTT V \(SBCSI\): 7 posts Gav....: 6 posts Jeff Urlwin: 6 posts Richard Rice: 4 posts Anderson, James H \(Company IT\): 4 posts Chris Masters: 4 posts Ian Harisay: 4 posts John: 4 posts Jonathan Leffler: 4 posts Marcos: 4 posts
show more
Archives