Update: Mac OSX 10.3 - DBI:CSV - after select undefined values in rows seems to have something to do with the eol character

hi everyone Here's an update on my problem - When I remove the linefeeds from between the lines in the csv file, it works. Here's the strange thing - those linefeeds were put in there by my insert statements from inside perl DBI::CSV under mac. so it's emiting one eol character (cr and lf) and

Mac OSX 10.3 - DBI:CSV - after select executes statement handle says rows !=0, but all values undefined

Hi everyone, I've got another newbie question - I'm able to grab the correct number of rows out of the csv file no problems now, but the actual values in the rows are blank. If I have the following file # this comment not part of the csv file custID,family,given^M 1,adams,mortica^M 1,adams,gom

FIXED: Mac OSX 10.3 - DBI:CSV - automatically updating the database handle's tables hash after opening a file

Thanks Jeff! That licked it. Yours Jin Kee > Thuan-Jin Kee wrote: > >>$code = <>INSERT INTO customer >>(custID, family, given) >>VALUES >>(1, " . $dbh->quote("adams") . ", " . $dbh->quote("mortica") . "); >>MARKER >> >>$dbh->do($code) >>or die "Cannot prepare: " . $dbh->errstr(); >> >>

Re: Mac OSX 10.3 - DBI:CSV - automatically updating the database handle's tables hash after opening a file

Thuan-Jin Kee wrote: $code = quote("mortica") . "); MARKER $dbh->do($code) or die "Cannot prepare: " . $dbh->errstr(); There are several minor problems with this code. In the first place, your SQL statement ends with a semicolon. Most DBDs do not like se

Mac OSX 10.3 - DBI:CSV - automatically updating the database handle's tables hash after opening a file

Hi everyone, I've got a problem updating the database handle's tables hash when going to read an already existing table I'm pretty new to dbi, and I'm working through the examples in the perldocs for CSV.pm and the exercises at http://www.perl.com/pub/a/1999/10/DBI.html and #http://ironbark.bend

RE: Windows to Oracle

Graeme, You must install DBD::Oracle using either CPAN or ActiveState's PPM utility (if you're using AS Perl 5.6.0). However, I' a little confused ... If you are truly trying to use ODBC, why are you specifying the Oracle driver? Shouldn't you be connecting in an ODBC-ish manner? If you are

Windows to Oracle

Newbie, I'm afraid. Context XP Pro, perl.apache.org's material. All works quite nicely talking to a skeleton MySQL d-b on the same m/c (and for that matter another XP m/c on my home LAN). Now I need to test my changes against a real (and remote) Oracle d-b - the original code connected to Oracle

Re: DBI 1.45 and perl 5.8.2 - bug 24463

On Sun, Nov 28, 2004 at 11:01:10AM -0500, Brian Facey wrote: > Dear DBI Users. > > Recently, found out about bug #24463 (perl 5.8.2 when configured with > threads and debugging enabled which causes a DBI test to fail. I want > to install DBI 1.45 and DBD-Pg 1.32. Does this mean that DBI 1.45 wil

Re: Announcement/Request for Comments: DBIx::Call

On Sun, Nov 28, 2004 at 07:15:43AM -0700, Reidy, Ron wrote: > What about allowing/forcing a has to be added to the prepare() calls to defer > describes until execute (ora_check_sql => 1)? That attribute ought to be able to be set at the $dbh level. Patches welcome. Tim. > -- > Ron Reidy > Lead

Re: A note about ConceptDraw

On Sun, 28 Nov 2004 10:18:16 -0800, Tom Mornini wrote: Hi Folks I've added DBDesigner 4 and XERD to the list. Thanx. http://savage.net.au/Ron/html/drawing-tools.html -- Cheers Ron Savage, [EMAIL PROTECTED] on 29/11/2004 http://savage.net.au/index.html

Re: A note about ConceptDraw

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Jun 28, 2022, at 9:37 PM, William Goedicke wrote: Dear Ron - "Ron" == Ron Savage <[EMAIL PROTECTED]> writes: Ron> http://savage.net.au/Ron/html/drawing-tools.html I use a tool you get at http://www.fabforce.net/dbdesigner4/ called DBDesigner4. I

DBI 1.45 and perl 5.8.2 - bug 24463

Dear DBI Users. Recently, found out about bug #24463 (perl 5.8.2 when configured with threads and debugging enabled which causes a DBI test to fail. I want to install DBI 1.45 and DBD-Pg 1.32. Does this mean that DBI 1.45 will not work with perl 5.8.2 when configured this way? If so, my version

Re: A note about ConceptDraw

Dear Ron - > "Ron" == Ron Savage <[EMAIL PROTECTED]> writes: Ron> http://savage.net.au/Ron/html/drawing-tools.html I use a tool you get at http://www.fabforce.net/dbdesigner4/ called DBDesigner4. It works nicely but, doesn't work on OS X :( Yours - Billy ===

RE: Announcement/Request for Comments: DBIx::Call

What about allowing/forcing a has to be added to the prepare() calls to defer describes until execute (ora_check_sql => 1)? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Thilo Planz [mailto:[EMAIL PROTECTED] Sent: Thu 11/25/2004 12:23 AM To: [EMAIL PROTECT

Re: DBI installation/build troubleshooting resources

Michael Peppler wrote on Sunday, 28 November 2004: >The most likely issue here is that the .cpan directory (and its >children) is not owned by the user that is running the "perl >Makefile.PL". > >My *guess* is that you originally ran the CPAN utility as root using >"sudo". It seems you are spot o

Re: DBI installation/build troubleshooting resources

On Sun, 2004-11-28 at 08:26, Oliver Boermans wrote: > Successfully installing the Perl DBI on OS X feels like a trial by fire. > I have done it before but this time my feet are getting burnt! > My attempts to install the perl DBI on my shiny new Mac have come to > dead end. Problems (and solution