FAQ

Search Discussions

197 discussions - 647 posts

  • Hi guys, gals! I have a pretty big string that I am inserting into MySQL via the $dbh- quote($str) function, this works great however now when I pull the data back out of the database and go to write ...
    Brian SpindlerBrian Spindler
    Mar 27, 2003 at 4:19 pm
    Mar 27, 2003 at 6:21 pm
  • Hello, I have changed from MySQL DB to CSV File (DBD::CSV). And also from Linux to Windows A) But now I discovered few problems: On the same hardware system the same select for the same table 1) ...
    Peter SchuberthPeter Schuberth
    Mar 3, 2003 at 12:31 pm
    Mar 10, 2003 at 11:48 pm
  • Greetings Please forgive what is probably a newbie breach of netiquette, but I have hit a wall. I am trying to access a mysql database using DBI:mysql with perl 5.8. My query: etc etc my $rth = $dbh- ...
    Michael MuratetMichael Muratet
    Mar 28, 2003 at 6:37 pm
    Apr 1, 2003 at 3:33 pm
  • Seeing all that 'line noise' makes me think we need a neater way. Personally I'd have written it more like my $sql = qq{ INSERT INTO table ( } . join( ", ", @cols ) . qq{ ) VALUES ( } . join( ", ", ...
    Tim BunceTim Bunce
    Mar 10, 2003 at 10:15 pm
    Mar 18, 2003 at 2:44 am
  • Hi all, Currently in a project to convert our existing 7.3.4 and 8.1.7 Databases to Oracle9i.( Either the 9.0.1 or 9.2 version ) Now I'm having some problems connecting to some test databases I have ...
    Bjorn NaessensBjorn Naessens
    Mar 25, 2003 at 8:02 am
    Mar 26, 2003 at 4:47 pm
  • And what are some of the better solutions to that? I've taken to putting the entire DB connection syntax in a separate module so that I have: use StandardModules::DB; my $dbh = ...
    Paul BoutrosPaul Boutros
    Mar 18, 2003 at 7:16 am
    Mar 23, 2003 at 7:40 pm
  • I know there's probably a better way to do what I'm trying to accomplish so I'd like some opinions. I have 2 cgi programs. One has a form full of text boxes sending data to the 2nd program. What I ...
    Rob BentonRob Benton
    Mar 8, 2003 at 9:55 pm
    Mar 10, 2003 at 9:30 pm
  • hi someone able to help me about this? i'm absolulty confused... the Update will work in EE without any problems, the select, too. what is wrong with this code? i have tested with ActiveState Perl ...
    AlexAlex
    Mar 9, 2003 at 11:22 pm
    Mar 15, 2003 at 6:19 am
  • Hi, I'm trying to find out which users in a passwd file are not in a database. What I've tried so far(see below) finds a few but misses even more. I'm thinking it might be the way I'm preparing the ...
    RobRob
    Mar 27, 2003 at 6:06 pm
    Mar 27, 2003 at 11:50 pm
  • hi i've got problems understanding - how to put a select result to array and get the items back... someone able to explain me what is wrong with this code? sub testsub1 { my $sth8 = $dbh- ...
    AlexAlex
    Mar 16, 2003 at 10:01 am
    Mar 18, 2003 at 10:53 am
  • Hi all, I'm working on a perl-script connecting to myqsl using the above modules. This script works fine on one database-server, but if I try another on (both mysql-version 3.23.55) I get a warning ...
    Stephan HarrenStephan Harren
    Mar 11, 2003 at 8:23 pm
    Mar 13, 2003 at 9:39 am
  • Strangely enough, splitting the request into 2, first is Use db and second is whatever else still seems to work. Not sure why. Also, problem seems to be confined to scripts run for the DOS prompt. ...
    E. Scott StrickerE. Scott Stricker
    Mar 27, 2003 at 3:21 pm
    Apr 4, 2003 at 1:59 pm
  • Hi i am using Red Hat Linux 8 as a server for a project i am working on. i have installed MySQL automatically with the install of the OS. and then i installed Apache Server. i would like to install ...
    Mel awaisiMel awaisi
    Mar 7, 2003 at 3:30 pm
    Mar 29, 2003 at 12:39 am
  • I have switched webhosts. I cannot get DBI and DBD working correctly from a local directory on that host. (Readyhosting does not have installed -- and will not install -- DBI or DBD:ODBC.) I suspect ...
    VaranasiVaranasi
    Mar 22, 2003 at 6:03 pm
    Mar 24, 2003 at 3:20 pm
  • Normal column aliasing I have no problems. When I try to concatenate two columns and then make an alias (ie. Session) then I will get DBD::Oracle::db prepare failed: ORA-00923: FROM keyword not found ...
    Markham, RichardMarkham, Richard
    Mar 14, 2003 at 4:06 pm
    Mar 14, 2003 at 7:08 pm
  • Does anyone use ODBC to connect to SSA? I am on 5.8 and Windows XP. Bob
    Bob XBob X
    Mar 5, 2003 at 11:27 pm
    Mar 7, 2003 at 1:39 pm
  • Hi all, I am an absolute newbie to DBI and have read the documentation and am still unsure. I am attempting to connect to a SQL7 DB that is on a server other than the webserver. I am unsure as to ...
    Barlow, NeilBarlow, Neil
    Mar 24, 2003 at 11:43 am
    Mar 24, 2003 at 3:11 pm
  • I've been unable to install DBD::Oracle on MacOS X I have: MacOS X 10.2.4 Perl 5.8.0 DBI-1.35 DBD::Oracle-1.13 Oracle Developer Editior 9iR2 for MacOS X the core errors that I receive are during ...
    Brook SchofieldBrook Schofield
    Mar 19, 2003 at 12:07 pm
    Mar 20, 2003 at 7:15 pm
  • I have this script: use strict; use warnings; use DBI; my %attr = ( PrintError = 0, RaiseError = 1 ); my @drivers = DBI- available_drivers(); foreach my $driver(@drivers) { print "Driver: $driver\n"; ...
    Bob XBob X
    Mar 3, 2003 at 9:25 pm
    Mar 4, 2003 at 9:58 pm
  • Hi All, I recently upgraded one of my machines to DBD::Sybase 0.95. I am seeing a new behavior that is causing me problems and wondered if anyone could help me out. Also, I'm seeing that "$self- ...
    Karyn UlriksenKaryn Ulriksen
    Mar 31, 2003 at 7:39 pm
    Apr 1, 2003 at 6:36 pm
  • Hi All -- I'm having a problem trying to get a site which uses Sybase::Dblib working. Simply using the module will cause a segfault. FWIW, I do not have this problem with DBD::Sybase. Unfortunately, ...
    Jesse ErlbaumJesse Erlbaum
    Mar 19, 2003 at 2:19 pm
    Mar 31, 2003 at 7:59 pm
  • Jeremy RichardsJeremy Richards
    Mar 26, 2003 at 6:03 am
    Mar 28, 2003 at 10:04 am
  • Hi, I'm trying to insert date type values in SQL Server 7.0, but I always get the next error: DBD::ODBC::st execute failed: [unixODBC] Msg 8115, Level 16, State 2, Server PROSDK01, Line 1 The table ...
    Illera, FernandoIllera, Fernando
    Mar 24, 2003 at 12:19 pm
    Mar 24, 2003 at 3:25 pm
  • Is there a general DBI call , or DBD::ODBC call, to retrieve the autonumber generated after an insert ? Or is my best bet to do the insert, then do a select for the id, using the inserted values in a ...
    Joshua CaesarJoshua Caesar
    Mar 14, 2003 at 6:40 am
    Mar 15, 2003 at 8:33 pm
  • Greetings, My code follows. Should be enough for some bright person to figure out what I'm doing wrong. To me, it all looks fine. #!/usr/bin/perl use DBI; use Pg; use Getopt::Std; ...
    Jay G. ScottJay G. Scott
    Mar 12, 2003 at 9:03 pm
    Mar 12, 2003 at 9:20 pm
  • I am calling bind_param like this: $sth- bind_param($col_idx, $value, {TYPE = DBI::SQL_VARCHAR}); for a column defined as varchar(8), not null When $value == ' ' (one space) or $value == ' ' (two ...
    Matthew O. PersicoMatthew O. Persico
    Mar 11, 2003 at 3:55 am
    Mar 12, 2003 at 4:19 am
  • I'm having trouble with date time in Access with DBI/ODBC I'm trying to do this: SELECT * FROM some_table WHERE date_time_field 11/30/99 That's giving me all dates, where: SELECT * FROM some_table ...
    Jeff ThiesJeff Thies
    Mar 5, 2003 at 12:21 pm
    Mar 5, 2003 at 11:06 pm
  • While trying to test some multiprocessing on Win2K (ActiveState 633), I ran into an issue I'm hoping you can shed some light on. If I open a $dbh before forking off some kids that also open some ...
    Dean ArnoldDean Arnold
    Mar 4, 2003 at 10:42 pm
    Mar 5, 2003 at 4:21 pm
  • file: $CPAN/authors/id/T/TI/TIMB/DBI-1.34.tar.gz size: 290116 bytes md5: f0056760bea3d5697c21d64358617895 NOTE: Future versions of the DBI *will not* support perl 5.6.0 or earlier. : Perl 5.6.1 will ...
    Tim BunceTim Bunce
    Mar 1, 2003 at 5:45 pm
    Mar 2, 2003 at 11:49 am
  • Hi, there is a strange problem with usage of DBI inside the FETCH method of a tied hash. I have inherited the maintenance of a perl module which contains some configuration data and was filled in the ...
    Silvio WankaSilvio Wanka
    Mar 28, 2003 at 3:27 pm
    Apr 27, 2003 at 7:35 pm
  • hi, i am using the following method to write into two oracle dbs simultaneously... my @dbh; my @tns; my @def_tns = ('ops$xxxxx@xxxxx','xxxxx','ops$xxxxx@xxxxx','xxxxx'); my %dbpw; sub new { my $type ...
    S H A NS H A N
    Mar 29, 2003 at 3:04 pm
    Apr 2, 2003 at 2:30 pm
  • Hi, I'm not so expert on Solaris... and I have a machine that wasn't installed by me, but I can make changes as root if it's necesary. I always compile de module for linux with no problem. I ...
    Mariano FernandezMariano Fernandez
    Mar 28, 2003 at 3:14 pm
    Mar 29, 2003 at 11:14 am
  • Hi, We have been stuck with a CGI script that is tracking clickthrus, and my first impulse to deal with this problem is to just use mod_perl and a persistent connection with Apache::DBI, but we don't ...
    Eric FrazierEric Frazier
    Mar 27, 2003 at 5:52 am
    Mar 27, 2003 at 6:52 pm
  • I'm using Windows Nt 4.0, DBD-ODBC-1.05 y Dbi-1.34, my database is SQL Server 7.0 ----------- Mensaje Original -------------- De: Fernando Luna [FLUNA@tideworks.com] Para: fysaccis@cantv.net ...
    FysaccisFysaccis
    Mar 26, 2003 at 9:27 pm
    Mar 27, 2003 at 1:55 pm
  • Hi, I've searched all over and can't seem to find an answer to this... I have perl code using DBI and DBD::Oracle where I'm trying to selectively copy rows from one table to another table on a remote ...
    Chen, AllenChen, Allen
    Mar 25, 2003 at 11:55 pm
    Mar 26, 2003 at 11:35 am
  • I've got a strange problem with Apache::Session, and DBD::Oracle: [Tue Mar 25 10:01:03 2003] [error] Invoking view: /security/list-users.html -- DBH LONG READ LEN: 256000 <-- -- STATEMENT LONG READ ...
    Ken MillerKen Miller
    Mar 25, 2003 at 4:57 pm
    Mar 26, 2003 at 11:33 am
  • Ok, I'm going crazy with this. I know that if I use placeholders (?) in my queries, and pass the values via execute() that it's supposed to automatically call quote() on them. And it does that about ...
    Aaron TurnerAaron Turner
    Mar 20, 2003 at 2:47 am
    Mar 21, 2003 at 3:36 pm
  • Where can I find the latest (stable) version of the DBI-module? And if any of you know of a good online documentation, please list it/them! Best regards MatchWork World Wide A/S Thomas Haggren ...
    Thomas HaggrenThomas Haggren
    Mar 13, 2003 at 6:19 am
    Mar 14, 2003 at 10:57 am
  • Hi My error is as the subject says, i have a script that i am trying in it to locate where a directory with images are. the part in the script that the error i think is arising from is my $dir = ...
    Mel awaisiMel awaisi
    Mar 12, 2003 at 2:43 am
    Mar 12, 2003 at 10:24 am
  • How do I trap the db server messages that result from the sql I pass to the database?
    Markham, RichardMarkham, Richard
    Mar 7, 2003 at 12:31 am
    Mar 7, 2003 at 8:37 pm
  • I have a very long running Perl process. I recently upgraded the DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking memory. Given the complexity of the project, it's not possible ...
    Philip MolterPhilip Molter
    Mar 5, 2003 at 2:13 pm
    Mar 7, 2003 at 4:17 pm
  • I am trying to do either :- Retrieve data from an Oracle table with a nested table column or Retrieve data from an Oracle object table based on an object which contains a nested table Either attempt ...
    Simon TaylorSimon Taylor
    Mar 3, 2003 at 6:22 pm
    Mar 3, 2003 at 9:44 pm
  • Why does this example work... $dbh = DBI- connect("DBI:mysql:database=$database:host=$hostname", $user, $password) ...but this doesn't... $connect_string = ...
    Jefferies, BrianJefferies, Brian
    Mar 31, 2003 at 2:44 pm
    Mar 31, 2003 at 5:05 pm
  • All Before submitting the following issue as a bug report, I wanted to run it by this list, in order to: a) Check that I am not missing something. b) Get an opinion on whether the issue is with DBI ...
    Kevin RuscoeKevin Ruscoe
    Mar 24, 2003 at 7:50 pm
    Mar 25, 2003 at 5:49 pm
  • Dear Sirs, could you help me in resolving the following error installing DBD under Slackware? Here is the error: bash-2.05a# perl Makefile.PL Using DBI 1.33 installed in ...
    Salvatore SorrentinoSalvatore Sorrentino
    Mar 24, 2003 at 3:58 pm
    Mar 25, 2003 at 10:39 am
  • I'm having a problem installing the DBI module on a Red Hat 8.0 system, using Perl 5.8.0. There are two problems that show up in the build, relating to t/40profile.t test and t/42prof_data.t. I've ...
    SMITH,MICHAEL C (HP-PaloAlto,ex1)SMITH,MICHAEL C (HP-PaloAlto,ex1)
    Mar 21, 2003 at 10:43 pm
    Mar 22, 2003 at 11:23 pm
  • Hi, Parley. I used perl2exe compiled perl. If I rebuild perl from the source, will it work with perl2exe? Thanks, Vassiliy PARLEY,THUNDER (HP-MountainView,ex1) wrote:
    Vassiliy TruskovVassiliy Truskov
    Mar 20, 2003 at 12:27 am
    Mar 21, 2003 at 3:24 pm
  • Hi: I try to install the DBI-1.35 software on the Sun Solaris 5.8 server using the existing perl software from Sun. When I do the make command, I got the following error: root@servername # make cc -c ...
    Patrick LeePatrick Lee
    Mar 12, 2003 at 8:46 pm
    Mar 19, 2003 at 2:09 pm
  • Hello, Does anybody has any script that could give, detailed information about the performance of an Oracle Database. regards, Filipe Vasconcelos
    Filipe VasconcelosFilipe Vasconcelos
    Mar 14, 2003 at 9:48 am
    Mar 14, 2003 at 3:09 pm
  • First of all, thank you for all of your help so far. Particularly, for explaining where all of those _method calls go. The bad news is that I did try it and posted a problem I was having to the list ...
    Bryan YeungBryan Yeung
    Mar 13, 2003 at 1:45 pm
    Mar 14, 2003 at 2:14 pm
Group Navigation
period‹ prev | Mar 2003 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions197
posts647
users209
websitedbi.perl.org

209 users for March 2003

Tim Bunce: 89 posts Michael A Chase: 31 posts Jeff Urlwin: 24 posts Frans Postma: 13 posts Jonathan Leffler: 11 posts Alex: 10 posts Bob X: 10 posts Brian Spindler: 10 posts Jeff Zucker: 10 posts Markham, Richard: 9 posts Ron Savage: 9 posts Rudy Lippan: 9 posts Michael Peppler: 8 posts Scott R. Godin: 8 posts Dan Muey: 7 posts Matthew O. Persico: 7 posts Mel awaisi: 6 posts Paul Boutros: 6 posts Paul DuBois: 6 posts Rob Benton: 6 posts
show more
Archives