Re: debugging and stepping into ->do

2018-04-25 Thread Jeff Macdonald
Thanks again Brian. Also, no need to apologize. On Wed, Apr 25, 2018 at 3:29 PM Fennell, Brian wrote: > P.S. Two other ways to do UPSERT in mysql - INSERT IGNORE and REPLACE > > > https://chartio.com/resources/tutorials/how-to-insert-if-row-does-not-exist-upsert-in-mysql/ > >

Re: debugging and stepping into ->do

2018-04-25 Thread Jeff Macdonald
_library/c_function_fprintf.htm > > https://www.tutorialspoint.com/c_standard_library/c_function_getenv.htm > > http://rosettacode.org/wiki/Category:C > > > > And in the “more than you wanted to know” department (including xs > tutorial, perl internals, and how to use gdb on perl) > > > > http://perldoc.perl.org/perlhacktips.html > > http://perldoc.perl.org/index-internals.html > -- Jeff Macdonald Ayer, MA

debugging and stepping into ->do

2018-04-25 Thread Jeff Macdonald
ements via execute, but I don't. For example: $dbh->do('insert into foo (a, b) values (1,2)') should cause the execute method to be called, but that does not seem to be the case. Is 'do' in DBI/DBD calling some magic method? -- Jeff Macdonald Ayer, MA

Re: can $dbh->do take a prepared statement handle?

2011-06-17 Thread Jeff Macdonald
d not work with an object that > stringifies into SQL code. Better might be > >    eval {$unknown->execute();1) or $dbh->do($unknown) > > which would need to be adjusted to capture the returned values, if > needed, and would not work with an object other than a $sth that has > an execute method. > -- Jeff Macdonald Ayer, MA

Re: can $dbh->do take a prepared statement handle?

2011-06-16 Thread Jeff Macdonald
[0]->execute(); >    }else{ >     $dbh->do($_[0]); >    } > }; > so it looks like yes! I got sidetracked after I asked that message. I'm guessing this is in the DBI code? Thanks for the pointer. -- Jeff Macdonald Ayer, MA

can $dbh->do take a prepared statement handle?

2011-06-03 Thread Jeff Macdonald
subject says it all. TIA -- Jeff Macdonald Ayer, MA

Re: [cgiapp] "Best free DB for a web-based Perl app" response results...

2005-12-01 Thread Jeff MacDonald
> in the next release. However, PgSQL is still slow, hard to use, and of > questionable reliability. Slow, i'm not going to argue cause it's "fast enough for me" and I don't have numbers. Hard to use ? What do you find hard ? I find it aboslutly devine to use, and mysql to be cludgy and awkward.

Re: [cgiapp] Re: "Best free DB for a web-based Perl app" response results...

2005-12-01 Thread Jeff MacDonald
On 12/1/05, Robert Hicks <[EMAIL PROTECTED]> wrote: > "... if i only needed MySQL, i'd use SQL Lite." > > Really? I think that would be a poor choice and I like SQLite. ; ) > > Robert I'll elaborate. PostgreSQL is already installed. It's what I "grew up with" I've very comfortable with it and I f

Re: What happened to dbish?

2005-02-10 Thread Jeff Macdonald
Understood. Thanks for responding. On Wed, 9 Feb 2005 16:50:32 -0500, Thomas A. Lowery <[EMAIL PROTECTED]> wrote: > That's hasn't > > From: "Thomas A. Lowery" <[EMAIL PROTECTED]> > > And the maintainer has made any time to provide any updates or

What happened to dbish?

2005-02-04 Thread Jeff Macdonald
It seems it is no longer included, and scanning the Changelogs doesn't give me a clue why. Is there a better alternative? -- Jeff Macdonald Ayer, MA

Re: Searchable archive for the DBI mailing list?

2005-01-24 Thread Jeff Macdonald
;group=perl.dbi.users Another alternative is http://dir.gmane.org/gmane.comp.lang.perl.modules.dbi.general. -- Jeff Macdonald Ayer, MA

CLOBS and Oracle::DBD

2003-01-14 Thread Jeff Macdonald
Hi, Has anybody noticed that that a program doing clob inserts seems to grow over time? Is this a known leak that hasn't be squashed? -- Jeff Macdonald <[EMAIL PROTECTED]>