FAQ

Perl > dbi-users > June 2002

Search Discussions

228 discussions - 689 posts

  • I've just spent the last 15 minutes looking at CPAN for a module to query a MS Access database. Which modules do I need to download? Can someone throw me a hint? :)
    Erick NelsonErick Nelson
    Jun 24, 2002 at 11:27 pm
    Jun 27, 2002 at 10:45 am
  • Does anyone have any experienc with calling cancel on a statement handle and DBD::Oracle? I am trying to use it in conjuction with alarm() to timeout a long running query without success. Any help ...
    E KolveE Kolve
    Jun 29, 2002 at 12:23 am
    Jul 10, 2002 at 12:25 pm
  • Now that we have a working emulation of the DBI written in pure-perl, I was wondering what people might be using it for... I'm finishing off my slides for this years Advanced DBI tutorial at the ...
    Tim BunceTim Bunce
    Jun 11, 2002 at 11:35 am
    Jun 12, 2002 at 10:17 pm
  • This works fine: my $sth = $dbh- prepare( "INSERT INTO stats VALUES (SYSDATE,?,?,?,?)" ) or die "Cannot prepare SQL statements from $DBI::errstr\n"; however if i try to format it like: my $sth = ...
    Kipp, JamesKipp, James
    Jun 25, 2002 at 4:45 pm
    Jun 25, 2002 at 6:25 pm
  • hi all of u, i got a simple question, why (1) is valid, however, (2) is not ?!! (1) sorting order is explicity typed in the query statement: $sth = $dbh- prepare("select student_name from students ...
    Hytham ShehabHytham Shehab
    Jun 10, 2002 at 3:16 pm
    Jun 10, 2002 at 7:46 pm
  • hi, i'm trying to commit some changes with $dbh- commit(); while using dbi::proxyserver but get the following error message DBI::ProxyServer::db=HASH(0x8389228)- func() invalid redirect method name ...
    Antoine JanssenAntoine Janssen
    Jun 11, 2002 at 2:43 pm
    Jun 18, 2002 at 12:09 pm
  • Everyone, I just installed the DBI on our Sun Solars 4 box. Perl 5.6.1, but I get the following error when trying to do a DBI- avaliable_drivers(): Can't locate auto/DBI/avaliable_d.al in @INC (@INC ...
    Bates, David A.Bates, David A.
    Jun 3, 2002 at 9:51 pm
    Jun 4, 2002 at 5:44 pm
  • I have a script which I imagine will loop every 15 to 60 seconds. Should I make the database connection at the beginning of the script, and just keep reusing it, or would it be more prudent to remake ...
    Rory Campbell-LangeRory Campbell-Lange
    Jun 26, 2002 at 8:48 pm
    Jun 27, 2002 at 4:27 pm
  • Hi, Can anybody let me know why I am getting this error? Why it keep writing to the perllocal.pod? cp Changes blib/lib/DBI/Changes.pm Files found in blib/arch: installing files in blib/lib into ...
    Li-fang ChewLi-fang Chew
    Jun 11, 2002 at 12:13 am
    Jun 11, 2002 at 4:52 am
  • Hi I want to insert records from an array iteration. not sure of the best way to enter the date and time. i read the docs, but thought i would check to see if someone has experience with this and ...
    Kipp, JamesKipp, James
    Jun 14, 2002 at 4:42 pm
    Jun 14, 2002 at 9:26 pm
  • Hello, I am new to the list, and I have searched the archives for this problem, and haven't seen an answer that works for me yet. My database is Oracle 9.2, my client is oracle 8.1.7. I am using ...
    David TottenDavid Totten
    Jun 20, 2002 at 4:03 pm
    Jun 24, 2002 at 9:55 pm
  • I am currently having an issue with sending multiple variables to a Oracle procedure. When I do this the CGI script I am using reports that the script has run successfully. But when I check the ...
    Powell, BrucePowell, Bruce
    Jun 13, 2002 at 10:29 pm
    Jun 17, 2002 at 3:20 pm
  • Hi All, I've been having a tough time coming up with a good way to do this: - I have a (postgresql) DB table containing quoteId, quote, author - I want to have a randomly selected quote appear on a ...
    Steve TylerSteve Tyler
    Jun 2, 2002 at 7:05 am
    Jun 4, 2002 at 2:49 am
  • Hi. The hosting company that I am with says that you only need "execute for scripts" permissions to run Perl scripts in my cgi-bin directory. However, I'm unable to run *any* of my scripts. Might ...
    Nick Hoffman [UWO]Nick Hoffman [UWO]
    Jun 24, 2002 at 3:11 pm
    Jun 24, 2002 at 6:35 pm
  • Hi, Does any one have experience with Apache::DBI with Perl (not mod_perl)? How good these are with persistence connections? Is there any issues for the large web sites? Please let me know. I was ...
    Kotha, NagarajuKotha, Nagaraju
    Jun 17, 2002 at 8:14 pm
    Jun 19, 2002 at 12:28 am
  • Can anybody guess as to when output parameter binding will be supported with FreeTDS? I've got a Linux box running FreeTDS 0.53, DBI-1.21, DBD::ODBC 0.39, and PERL 5.6.0. We're connecting to an MSSQL ...
    Jason LurosJason Luros
    Jun 27, 2002 at 6:37 pm
    Jul 2, 2002 at 11:14 am
  • I may have asked this or seen this asked before, but my memory is poor today: is there any way to know the process ID associated with the database backend connected to a DBD::Pg database handle? -- ...
    Jeff BoesJeff Boes
    Jun 13, 2002 at 3:26 pm
    Jun 28, 2002 at 1:10 am
  • Can someone tell me who authored the DBI module? I'm trying to locate the documentation on CPAN, and I come up with too many results when I use just use "DBI" for the search. Thanks
    Clarence SnivellwitzClarence Snivellwitz
    Jun 24, 2002 at 4:45 am
    Jun 24, 2002 at 9:58 pm
  • I'm trying to list the tables within one of my mysql databases. According to the perldoc for DBD::mysql, I should use the DBI standard interface: $dbh- tables(); over the depreciated $dbh- ...
    Cary MathewsCary Mathews
    Jun 18, 2002 at 2:44 pm
    Jun 19, 2002 at 5:03 pm
  • Hi all, I'm having trouble with obtaining locks on tables with a DBI script. I have the following function which has been run at the beginning of a long running script. However, after starting the ...
    Tim HarschTim Harsch
    Jun 6, 2002 at 9:53 pm
    Jun 10, 2002 at 5:58 am
  • Greets Folks, I wrote in yesterday as per the author of the DBI module, but the documentation i have found really doesnt seem sufficient for learning the module... Is there a book I should buy for ...
    WillWill
    Jun 25, 2002 at 7:08 am
    Jun 25, 2002 at 3:25 pm
  • I have a linux 7.3 OS, successfully installed informix-client-sdk and am trying to install DBD::Informix to no avail. The dbd install is telling me file libifsql.so can't be found...well, it doesnt ...
    KirkKirk
    Jun 18, 2002 at 5:52 pm
    Jun 22, 2002 at 4:08 am
  • I'm noticing that the fetchall_arrayref method in DBI doesn't handle multple result sets. For example, if I prepare a statement using this sql (for example): select * from A select * from B , execute ...
    Umaa RebbapragadaUmaa Rebbapragada
    Jun 18, 2002 at 8:37 pm
    Jun 18, 2002 at 9:17 pm
  • Hi, I am having problem when try to make install. Please help. cp Changes blib/lib/DBI/Changes.pm Warning: You do not have permissions to install into ...
    Li-fang ChewLi-fang Chew
    Jun 10, 2002 at 8:14 am
    Jun 10, 2002 at 10:01 am
  • Hello, I'm trying to port my programs from perl-5.6.0 unthreaded to perl-5.7.3 multi-threaded. But I doesn't manage to install DBD::Oracle under perl-5.7.3 multi-threaded. I use DBI-1.23 and ...
    Jérémy JUSTJérémy JUST
    Jun 3, 2002 at 5:13 pm
    Jun 7, 2002 at 4:49 pm
  • Greets All, A friend told me that I shouldnt use DBI's connect(), prepare(), exec()and disconnect() methods when I am using CGI.pm, but he said rather to use do(). Can anyone tell me why? And, also, ...
    WillWill
    Jun 30, 2002 at 10:19 pm
    Jul 1, 2002 at 4:50 pm
  • Hi all, I need to know how many rows are returned from a select before I start my fetch if possible. Basically if I get 1 row back then I want to do one thing with the data, if I get more than 1 row ...
    Brian AvisBrian Avis
    Jun 28, 2002 at 9:55 pm
    Jun 28, 2002 at 11:27 pm
  • Hi everyone, I'm running a script that is supposed to insert rows into a table, but consistantly don't do so. I have tried both a prepare/execute and a do statement, and neither work. The weird thing ...
    James WilliamsJames Williams
    Jun 26, 2002 at 5:37 pm
    Jun 26, 2002 at 8:42 pm
  • Hallo, I have tried to install the Mysql module. By the instruction of http://www.mysql.com/doc/P/e/Perl_installation.html I have a problem in the 3 step:make!!!(I have the sun solaris 8 system.) I ...
    Jingyuan wangJingyuan wang
    Jun 21, 2002 at 2:05 pm
    Jun 25, 2002 at 1:28 am
  • Seems to be an error with selectall_hashref method. Anyone know what the problem is? Here are the errors: [Fri Jun 14 11:00:00 2002] confirm_warning_1.0.7c.pl: DBI selectall_hashref: invalid number ...
    Randall PerryRandall Perry
    Jun 14, 2002 at 3:16 pm
    Jun 24, 2002 at 5:50 pm
  • Hello, I am trying to use the LOAD DATA LOCAL INFILE MySQL command from Perl. (I have Perl v5.6.1 . DBI.pm is dated Feb 6 2002.) As of version MySQL 3.23.49 (which is what I have), MySQL changed so ...
    Tom AtwaterTom Atwater
    Jun 21, 2002 at 2:00 pm
    Jun 23, 2002 at 2:02 pm
  • Hi, I want to store images in MySQL table. Is it by creating a table with one of its fields a BLOB type. Then how will i insert the image into the table. Thanks Saju
    SajuSaju
    Jun 15, 2002 at 10:36 am
    Jun 17, 2002 at 7:21 pm
  • All, Is there a way for a Redhat Linux box to connect to an Oracle Server without having to install Oracle Client? Is there some other DBD module which will do this? Installing Oracle Client is ...
    Philip DaggettPhilip Daggett
    Jun 13, 2002 at 8:50 pm
    Jun 17, 2002 at 4:37 pm
  • Hi, I have many many perl programs that do the following: use DBI; use DBD::Oracle; If I also put: use strict; and type: perl -cw filename.pl I get: Variable "$sth" is not imported at filename.pl ...
    James PittmanJames Pittman
    Jun 13, 2002 at 8:55 pm
    Jun 13, 2002 at 9:23 pm
  • We are having difficulty installing the DBI on Sun Solaris. Where would we find the FAQ to give us some idea how to proceed? Thanks Susan
    Susan WhiteSusan White
    Jun 11, 2002 at 4:53 pm
    Jun 13, 2002 at 2:44 pm
  • (Not certain which list this belongs on, so I'm sending to both) I've been testing my drivers with PurePerl, and ran into a little problem I'm hoping someone can enlighten me about: My test script ...
    Dean ArnoldDean Arnold
    Jun 1, 2002 at 6:52 pm
    Jun 3, 2002 at 12:12 pm
  • Can anyone suggest their preferred method for accessing the data in an appgen database? We have an appgen database from which we would like to draw information directly with perl, rather than through ...
    Chris SnyderChris Snyder
    Jun 6, 2002 at 1:33 pm
    Oct 1, 2003 at 2:38 pm
  • I am running DBD::Sybase 0.91 against SQL Server 2000 (DBI 1.20). When I select text columns that have more than 4k of data in them, the result is cut off at 4096 (4k) bytes. I have tried different ...
    Jake FeaselJake Feasel
    Jun 27, 2002 at 10:17 pm
    Jun 28, 2002 at 2:20 pm
  • Hello Everyong, I have read and heard a few times that multi-threading is not supported in DBI. I have a script that sends thousands of emails on a Windows. Of course...I can't send thousands of ...
    Ken SwiftKen Swift
    Jun 27, 2002 at 1:42 pm
    Jun 28, 2002 at 11:09 am
  • I am trying to access an Oracle 8.1.7 database. If a user enters an invalid username and password, it provide an invalid username/password error. The next time the user tries to access the database ...
    Cassell_erin_hCassell_erin_h
    Jun 27, 2002 at 4:57 pm
    Jun 27, 2002 at 8:22 pm
  • Hi, I am trying to insert a paragraph from a <textarea field on a form. This form is part of a CGI script that then inserts the textarea data into a MySQL database table through DBI. The problem is ...
    Emma GrantEmma Grant
    Jun 26, 2002 at 8:42 pm
    Jun 27, 2002 at 6:09 pm
  • Hi, I've been using DBI a lot lately, but for the first time I have to connect to an Oracle database and I'm seeing some behavior that I don't understand. Perhaps someone can give me a hint as to ...
    Alan HogueAlan Hogue
    Jun 26, 2002 at 4:37 pm
    Jun 26, 2002 at 7:05 pm
  • Hello, I'm relative new in DBI... My question is how I can eliminate the double quotes when I read a csv file which I want to use it to create a database tabel? I have a code like this: require DBI; ...
    TIBA, LIVIATIBA, LIVIA
    Jun 25, 2002 at 2:30 pm
    Jun 25, 2002 at 4:49 pm
  • Hi dears Excuseme, my english is very poor. My Name is Germán i live in Chile(South America), i have the following problem: "can't locate object method "connect" via package "DBI". If your have the ...
    GermanmarambioGermanmarambio
    Jun 24, 2002 at 3:30 pm
    Jun 25, 2002 at 4:19 pm
  • Has anyone been able to get the DBI architecture running on a Sharp Zaurus Linux PDA? I don't own one, and haven't tried... but it could be a very interesting and powerful platform if DBI were ...
    Rick OsterbergRick Osterberg
    Jun 24, 2002 at 9:06 pm
    Jun 25, 2002 at 9:59 am
  • German, Estoy apesadumbrado. No tengo ninguna experiencia con el perlcc. --Thunder dbi-users, TRANSLATION: "When I execute with Perl, I don't have any problems. When I do an executable with perlcc, ...
    PARLEY,JON (HP-MountainView,ex1)PARLEY,JON (HP-MountainView,ex1)
    Jun 24, 2002 at 3:58 pm
    Jun 24, 2002 at 4:24 pm
  • All, I have a Debian Linux machine which runs the following: Perl 5.005_03 DBI 1.25 [hopefully] DBD::Oracle 1.12 I need to write scripts which will access an Oracle 8i service which is hosted on ...
    Garrett EllisGarrett Ellis
    Jun 21, 2002 at 9:53 pm
    Jun 22, 2002 at 2:04 am
  • I'd like to bookmark the mail archive site so that I don't have to go to the list to ask for the umpteenth million time what I know has been asked on this list... I'm having problems with calling an ...
    Karyn UlriksenKaryn Ulriksen
    Jun 21, 2002 at 5:47 pm
    Jun 21, 2002 at 8:36 pm
  • Level B error. After making the following hacks, I was able to get a build - but nearly all the tests failed (Level C error). So my hacks may not have been 'good enough'. Configuration.pm (After Line ...
    Nick HansenNick Hansen
    Jun 4, 2002 at 11:33 pm
    Jun 19, 2002 at 8:03 am
  • I have Perl 5.6.1 installed from the HP application disk for HP-UX 11i. I am running HP-UX 11.11 (11i) 64 bit. I have also installed "gcc-3.1". When I try to install the DBI module (most any version ...
    Briscoe B. BrownBriscoe B. Brown
    Jun 14, 2002 at 3:03 pm
    Jun 17, 2002 at 9:30 pm
Jun 2002
12345
Group Navigation
period‹ prev | Jun 2002 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions228
posts689
users246
websitedbi.perl.org

246 users for June 2002

Tim Bunce: 59 posts Jeff Zucker: 20 posts Thomas A. Lowery: 18 posts Bart Lateur: 17 posts Michael Peppler: 17 posts Sterin, Ilya: 17 posts Kipp, James: 15 posts Paul DuBois: 15 posts Jeff Urlwin: 14 posts Michael A Chase: 14 posts Ronald J Kimball: 13 posts Li-fang Chew: 11 posts Tim Harsch: 11 posts Jeff Seger: 9 posts Nhendler: 8 posts Rory Campbell-Lange: 7 posts Scott T. Hildreth: 7 posts Tziem: 6 posts Jeff Boes: 6 posts Perl Authors Upload Server: 6 posts
show more
Archives