FAQ

Perl > dbi-users > September 2004

Search Discussions

101 discussions - 362 posts

  • Hello: I am trying to install Perl support with MySQL. After installing MySQL (v4.0.20)I run the following commands: % echo $PATH % perl -MCPAN -e shell Note: Answer "no" to auto-configure perl. cpan ...
    Kirti S. BajwaKirti S. Bajwa
    Sep 10, 2004 at 9:05 pm
    Oct 2, 2004 at 6:15 am
  • I have a table that has a list of users with numeric user IDs. The user IDs are not sequential. There are large gaps in the list of numeric IDs. I want to pick the next unused number beginning at ...
    NIPP, SCOTT V \(SBCSI\)NIPP, SCOTT V \(SBCSI\)
    Sep 14, 2004 at 7:30 pm
    Sep 15, 2004 at 3:32 pm
  • All, Can I do this? $sth- bind_param_inout($#execute_args+1,\$new_id,38); $sth- execute(@execute_args); When I try I get the following error Can't rebind or change param :p6 in/out mode after first ...
    Martin MossMartin Moss
    Sep 13, 2004 at 5:22 pm
    Oct 21, 2004 at 4:52 pm
  • I would like to know how to insert faster using SQLite. use strict; use dbi; use Date::Manip; use Diagnostics; #Connect to the database my $dbh = DBI- connect("dbi:SQLite:data.dbl") #MSSQL Server my ...
    Lamb JosephLamb Joseph
    Sep 22, 2004 at 8:05 pm
    Sep 27, 2004 at 4:28 pm
  • I have a table with 22 columns, and my INSERT on this table is actually putting in data to possibly all 22 fields. My question is, is there a better way to write this INSERT? Here's what I have: ...
    NIPP, SCOTT V \(SBCSI\)NIPP, SCOTT V \(SBCSI\)
    Sep 7, 2004 at 8:04 pm
    Sep 8, 2004 at 7:50 pm
  • I've got a script I use for backing up MS-SQL databases via DBD::ODBC on Windows. It was working fine with ActivePerl 5.6.1 (build 633), DBI 1.30 and DBD::ODBC 0.43, but when I upgraded to ActivePerl ...
    David GoodDavid Good
    Sep 15, 2004 at 6:14 pm
    Sep 24, 2004 at 4:16 am
  • I'm trying to insert an email address into a mysql database and it seems to fail no matter what I do. Here are two different cuts at the code, neither of which works and both return pretty much the ...
    Hamilton, KentHamilton, Kent
    Sep 23, 2004 at 7:15 pm
    Sep 24, 2004 at 3:47 am
  • I just downloaded DBI-1.43.tar.gz from cpan and am trying to install on windows xp / cygwin. Make goes fine, but 'make test' hangs on the tenth test. Tail of output with TEST_VERBOSE=1 below: ...
    Paul GalbraithPaul Galbraith
    Sep 7, 2004 at 4:12 pm
    Sep 9, 2004 at 3:31 pm
  • Thanks Ron, for pointing me to right link. It's resolved now. I was hitting 4000 bytes limit, eventhough the string length is around 1390 characters due to my NLS_LANG setting(WE8..) and Oracle8's ...
    Ravi KongaraRavi Kongara
    Sep 30, 2004 at 5:00 pm
    Oct 1, 2004 at 6:33 am
  • Hello all, I am new to the list. I am trying to achieve a goal in PERL. That is: I have a table say students with fields (id int, name char(10) ) . I have data like:- ID NAME == ========== 1 Kamran 2 ...
    KamranKamran
    Sep 27, 2004 at 7:17 pm
    Sep 29, 2004 at 12:16 pm
  • Hi, I'm using DBI 1.42, DBD::Oracle1.14 built on Oracle 8, Perl 5.6.1 on Solaris 9. Purpose of the script is to compare values between source and target databases. Source db is Oracle 7.3 and target ...
    Ravi KongaraRavi Kongara
    Sep 21, 2004 at 7:30 pm
    Sep 23, 2004 at 1:45 pm
  • In looking at the ftp site I see that the Oracle tar.gz is only about 50K. The previous "beta" version I have is 201KB. Is that correct? Is it the one on the ftp site okay to use? Robert
    RobertRobert
    Sep 10, 2004 at 12:43 pm
    Sep 14, 2004 at 11:29 am
  • Hello there, one brief question: needs UnixODBC the DBI or is it totally indipendent? Gruss Christian -- Christian Stalp Institut für Medizinische Biometrie, Epidemiologie und Informatik (IMBEI) ...
    Christian StalpChristian Stalp
    Sep 7, 2004 at 8:51 am
    Sep 9, 2004 at 10:50 am
  • Got DBI version 1.3.5 (not sure which version DBD::Oracle. Is there a way to tell?) on RedHat AS 2.1. I need some advice. I'm doing an oracle query on a table that has over 23 million records and I ...
    Rob BentonRob Benton
    Sep 24, 2004 at 9:15 pm
    Sep 24, 2004 at 9:55 pm
  • Hi. I'm reasonably experienced with Perl and with databases but new to Perl-DBI. I'm trying to write a conversion program from a legacy DB at work and discovered that some values weren't copied ...
    Rutherdale, WillRutherdale, Will
    Sep 9, 2004 at 10:00 pm
    Sep 13, 2004 at 4:33 pm
  • Hi, I compiled perl 5.8.5 from source and I am now trying to install DBD::mysql via CPAN. I am running MySQL 5.0.0 using a binary build for Mac OS X. Does anybody have this working already ? Thanks, ...
    Joris VerboomenJoris Verboomen
    Sep 5, 2004 at 8:36 am
    Sep 8, 2004 at 11:42 pm
  • This isn't specifically a DBI question, but it is a part of a database script I am writing. I am parsing a CSV file and populating a MySQL database table. The problem I have run into is that a couple ...
    NIPP, SCOTT V \(SBCSI\)NIPP, SCOTT V \(SBCSI\)
    Sep 7, 2004 at 6:15 pm
    Sep 8, 2004 at 11:04 am
  • Hi, I've an Array like this: @array( ["Xaver", "Biton", "myStrasse", "1", "0725120155"], ["Xx", "Xy", "deineStrasse", "2", ], ["Robert", "sky", "seineStrasse", "2","04035210", "04035211","my@mail.de" ...
    Xaver bitonXaver biton
    Sep 1, 2004 at 9:59 am
    Sep 1, 2004 at 7:52 pm
  • Hi, I would like to connect to an Oracle database as sysdba from perl, so I use the script joined below. I use, for example : perl test.pl -database prebcc -username "t" -password "t" -sysdba But the ...
    Pierre HenonPierre Henon
    Sep 24, 2004 at 1:18 pm
    Sep 27, 2004 at 4:39 pm
  • [Copy of original email I sent to Tim, but I would value the input from anyone on this list who has any ideas] Hi there Tim, We are using DBD::Oracle as part of our web site here, and are ...
    Tristan GreavesTristan Greaves
    Sep 14, 2004 at 8:48 am
    Sep 25, 2004 at 2:08 am
  • I am having a problem in that if a field is blank, it is getting put into the database as a '0' rather than 'NULL'. The table is setup to both allow NULL values in this field as well as NULL being ...
    NIPP, SCOTT V \(SBCSI\)NIPP, SCOTT V \(SBCSI\)
    Sep 16, 2004 at 7:22 pm
    Sep 22, 2004 at 6:42 pm
  • Hi, I have a workaround for this issue, but the bug appears serious enough that I wanted to report it to maintainers. Running a DBD::ADO program against a MS SQL Server 2000 database, if I try to ...
    Sarkissian, Vahe - NCSarkissian, Vahe - NC
    Sep 15, 2004 at 8:11 pm
    Sep 22, 2004 at 9:11 am
  • [cc'd to dbi-dev but follow ups set to dbi-users] Hi all, As the number of DBI related modules I maintain has grown (currently over a dozen), I have noticed two things: my reach has exceeded my grasp ...
    Jeff ZuckerJeff Zucker
    Sep 16, 2004 at 8:36 pm
    Sep 20, 2004 at 5:51 pm
  • Hello, Is there way to set timeout in DBD::ODBC? I'm trying to make a script updating SQL server. I hear our SQL server is set 10 minutes as timeout (default). And also I hear ADO has 30 secomd ...
    H-taguchiH-taguchi
    Sep 15, 2004 at 5:32 am
    Sep 17, 2004 at 5:13 pm
  • Hi there! I've got a script, which regularly connects to a MySQL database and does something :) Last night something was wrong with the MySQL server, so the script hung up while doing "$st_query- ...
    Steffen BreitbachSteffen Breitbach
    Sep 10, 2004 at 11:50 am
    Sep 10, 2004 at 6:05 pm
  • I have created a database that has a table for the active data, and a table that basically captures the changes to that table. The second table has all of the same fields as the first with one extra ...
    NIPP, SCOTT V \(SBCSI\)NIPP, SCOTT V \(SBCSI\)
    Sep 9, 2004 at 12:47 am
    Sep 9, 2004 at 9:15 pm
  • I have following problem when tried to install perl DBD::mysql (on a Red Hat Linux AS server 3.2.3-34, a dual-processor machine): Multiple lines of Unsuccessful stat on filename containing newline at ...
    Zhiliang HuZhiliang Hu
    Sep 2, 2004 at 5:52 pm
    Sep 6, 2004 at 11:07 pm
  • Hi, everybody! I have to work with FireBird database, for a project of mine. I grabbed from CPAN a DBD-InterBase (version 0.43) to work with, and installed it on Windows. It works perfectly. I also ...
    Cristi OcolisanCristi Ocolisan
    Sep 3, 2004 at 8:38 am
    Sep 3, 2004 at 12:39 pm
  • Thanks to Jeff Urlwin there are now PPDs for DBD::Sybase available from http://ftp.esoftmatic.com/DBI/. The build is for ActivePerl 5.8.4, and was built with Sybase's 12.5.1 client libraries. If you ...
    Michael PepplerMichael Peppler
    Sep 30, 2004 at 10:41 am
    Oct 1, 2004 at 5:49 pm
  • Hi, I have already build Perl, DBI and DBD::Oracle linked with Oracle 9.2 ( full install ) on Solaris and it seems to work. Some points are not clear conceerning the build process and I have several ...
    GaGadgetGaGadget
    Sep 29, 2004 at 9:47 pm
    Sep 29, 2004 at 10:45 pm
  • I need some help installing DBI and DBD on my Unix servers here. Here's what my environment looks like 1 - App server which is a AIX P630 running 5.2 1 - DB server which is a V 2250 running HP-UX. ...
    Barron, MichaelBarron, Michael
    Sep 29, 2004 at 12:55 pm
    Sep 29, 2004 at 5:36 pm
  • Hello, I'm new to the list and am experiencing an issue that I hope some of you all have dealt with previous and can lend me some advise on.. or supply a possible fix. Perl 5.6.1 with DBI module 1.32 ...
    Chris R MarbachChris R Marbach
    Sep 2, 2004 at 12:52 am
    Sep 25, 2004 at 2:08 am
  • Hello, I am wondering if there is any kind of switch that can be passed to DBD::CSV that will enable it to parse only one EOL at a time? We are using DBD::CSV to parse files into databases, and it is ...
    AmonotodAmonotod
    Sep 20, 2004 at 5:23 pm
    Sep 20, 2004 at 10:25 pm
  • I have upgraded Oracle from 8.1.7 to 9.2, after changing to the new Oracle environment when I run the cgi script which always used to work in Oracle 8.1.7 to Oracle 9.2 is giving the following error. ...
    RobertRobert
    Sep 16, 2004 at 2:50 pm
    Sep 17, 2004 at 11:29 am
  • I hope this is a bug report, and not me having done something stupid, but I was told on #perl that it is probably a bug in DBD:ADO. I'm not subscribed to the mailing, so I'd appreciate a CC for any ...
    Hampson, PaulHampson, Paul
    Sep 16, 2004 at 3:30 am
    Sep 17, 2004 at 3:36 am
  • I have a column in a table that has a data type=LONG. The content of this column is a text file(it is not a pointer to a text file but the raw text file itself). When I try to simple select statement ...
    Shah, UrmilShah, Urmil
    Sep 14, 2004 at 4:22 pm
    Sep 14, 2004 at 8:34 pm
  • Hello, i have select statement in the format: select record1 from table where record2 in ('122','134') The problem is i don't know in fact the number passed to 'in' in the select below so when i call ...
    Jbari Mohamed SaidJbari Mohamed Said
    Sep 14, 2004 at 10:50 am
    Sep 14, 2004 at 3:58 pm
  • Hello, I need the last entry of a table. This code interates through a list but how can I get the last element ? my $dbh = DBI- connect("dbi:mysql:$DB", $USER, $PASS) || print "MySQL: can't connect ...
    Mark-walterMark-walter
    Sep 1, 2004 at 5:06 pm
    Sep 1, 2004 at 5:18 pm
  • Hello all, I'm still having just a bit of trouble with execute_array. I want to parse my input file, break it apart with Text::CSV_XS (thanks for the great recommendation!), then build arrays ...
    AmonotodAmonotod
    Sep 30, 2004 at 2:38 pm
    Sep 30, 2004 at 4:02 pm
  • Hello all, I'm having a problem with execute_array. Below is the relevant code: # Build up parameter binds... while ($temp_count < $colttl) { $DataInsert- bind_param_array($temp_count, ...
    AmonotodAmonotod
    Sep 28, 2004 at 7:13 pm
    Sep 29, 2004 at 11:25 am
  • (I think it was RC7 - the one released end of august this year) Originally I had an interesting problem - when I'd prepare a query that called a function taking nvarchar2's as arguments it would work ...
    JeffJeff
    Sep 22, 2004 at 12:45 pm
    Sep 23, 2004 at 3:16 pm
  • Hi - I an having an issue with DBI connecting to a database. My environment in IIS 4.0, NT4, SP 6a, Perl 5.8.4, with DBI and DBD::ODBC installed. when I run a .pl file through the browser, if it does ...
    Doug RehgDoug Rehg
    Sep 22, 2004 at 9:12 pm
    Sep 22, 2004 at 10:09 pm
  • Ah, this fixed _both_ problems. ^_^ The output's the same, too. So I'm well satisfied. And I don't obvserve any speed difference, but that'd be because I'm running against an SQL Server on the other ...
    Hampson, PaulHampson, Paul
    Sep 17, 2004 at 3:43 am
    Sep 21, 2004 at 1:39 am
  • Hello I have to replace any comma (,) between quotation marks ("") only, with a ~ For example "ABC", 123, 456, "DE,F", "789" ... should be "ABC", 123, 456, "DE~F", "789" ... This way I can use the ...
    Erich SingerErich Singer
    Sep 17, 2004 at 7:07 pm
    Sep 20, 2004 at 3:31 pm
  • This is a request for comment with the intent of determining a better name for one of my CPAN modules prior to it being registered with the Perl 5 Module List. The module in question has been using ...
    Darren DuncanDarren Duncan
    Sep 18, 2004 at 7:05 am
    Sep 18, 2004 at 7:17 pm
  • I'm using DBI 1.43 as part of a plugin module for the "Radiator" RADIUS protocol server. The server forks child processes to handle incoming requests. I believe that the children are dumping core at ...
    Mark Jason DominusMark Jason Dominus
    Sep 14, 2004 at 8:57 pm
    Sep 15, 2004 at 1:49 pm
  • You should listen to Oracle support. From metalink: Doc ID: Note:106607.1 Subject: ORA-600 [16365] "Half duplex violation" Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: ...
    Reidy, RonReidy, Ron
    Sep 14, 2004 at 3:03 pm
    Sep 14, 2004 at 3:12 pm
  • I'm trying to write a Perl program that filters the contents of an input file. After each line from the input file is parsed, the fields of the line are submitted to if statements to determine which ...
    Nicholas TrandemNicholas Trandem
    Sep 13, 2004 at 1:59 pm
    Sep 13, 2004 at 7:51 pm
  • Hi, I'want to write a script which update a DB in Internet. from thr local DB I do a select query and while the select query run foreach row I do a UPDATE query: $sth_orders_local- execute($lasttime, ...
    Xaver bitonXaver biton
    Sep 10, 2004 at 12:00 pm
    Sep 10, 2004 at 5:22 pm
  • I get the following message being printed to stdout: "no statement executing at /usr/local/lib/perl5/site_perl/5.6.1/PA-RISC2.0/DBI.pm line 1177." How do I go about tracing this? regards, David
    David GoodmanDavid Goodman
    Sep 9, 2004 at 8:02 pm
    Sep 9, 2004 at 9:16 pm
Sep 2004
123
Group Navigation
period‹ prev | Sep 2004 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions101
posts362
users113
websitedbi.perl.org

113 users for September 2004

Reidy, Ron: 35 posts Tim Bunce: 32 posts NIPP, SCOTT V \(SBCSI\): 12 posts Amonotod: 10 posts Jared Still: 10 posts Jeff Urlwin: 10 posts Jeff Zucker: 10 posts Ian Harisay: 7 posts Kirti S. Bajwa: 7 posts Steffen Goeldner: 6 posts Xaver biton: 6 posts David Good: 5 posts Henri Asseily: 5 posts Lamb Joseph: 5 posts Martin Moss: 5 posts Michael Peppler: 5 posts Paul Galbraith: 5 posts Ravi Kongara: 5 posts Wieland Pusch: 5 posts Christian Stalp: 4 posts
show more
Archives