Re: DBD::mysql - strange error with parameter binding

2002-05-23 Thread Jochen Wiedmann
Hi, Jörn, I encountered a strange bug in DBD::mysql with parameter binding. If I use an arithmetic operator (e.g. ) on a string value just before using $dbh-prepare/execute, DBD::mysql guesses a numeric data type for this variable and omits the surrounding apostrophs, which naturally

RE: iThreads

2002-07-23 Thread Jochen Wiedmann
Hi, I am getting reports that DBD::mysql has trouble with cloned handles. I apologize if my questions are stupid, but I am too much out of the Perl business to be on top, so I have to ask. (Still sad to write that. :-( 1.) What is the current state of DBI and iThreads. Usable? Not

Re: Proposed patches for PlRPC and Proxy

2003-06-09 Thread Jochen Wiedmann
Quoting Tim Bunce [EMAIL PROTECTED]: I've CC'd Jochen as he needs to apply the PlRPC patches and make a new release before I can depend on them being available. Done. Besides, Tim, I have no problems if you apply any changes. As we all know, it is very unlikely that I'll be actively developing

Re: LIMIT clause and placeholders

2004-03-05 Thread Jochen Wiedmann
Beau E. Cox wrote: my $sth = $dbh-prepare(select * from some_table limit ?); OK $sth-execute(10); same syntax error as with 'mysql' It would probably work by using $sth-bind_param and specifying the type. (DBD::mysql contained an incompatbile change that made all anonymous placeholders

Re: Minimum dependencies for DBI v2

2004-07-09 Thread Jochen Wiedmann
Tim Bunce wrote: As I've said previously, DBI v2.0 is mainly about changes to the DBI-DBD interface. Makes no difference, IMO. DBD authors have the same choice to stick with v1 or not.

Re: Porting DBI/DBD on NetWare

2004-07-22 Thread Jochen Wiedmann
Hi, Aravinda, having read your patch for DBD::mysql, I must admit that I do not like them. They all seem to have the elimination of Perl's automatic module build system in mind. For example: - Rather than trust Perl that it knows the location and name of libperl.a, you explicitly specify a

Re: Porting DBI/DBD on NetWare

2004-07-22 Thread Jochen Wiedmann
P Aravinda wrote: Hi Jochen, I am building the perl modules for NetWare. But I am using Linux as the developement Environment(since netware doesn't have any development environment of its own, I am cross compiling the modules). I can compile the perl for NetWare on gcc. But I cannot use it further

Re: Replacing $sth

2004-07-26 Thread Jochen Wiedmann
Henri Asseily wrote: I'm trying to do the following, and was wondering where I should look to get a good handle on what's going on: I have an $sth that's pointing to a dead server. I have a new $sth2 that's pointing to a good server. upon the user doing $sth-execute, I want to be able to get

Re: DBI 2.0 interface change request

2004-08-03 Thread Jochen Wiedmann
John Siracusa wrote: The tied(?) hash interfaces in DBI grate on me. You know, $dbh-{'RaiseError'}, $sth-{'Active'}, and all that jazz. I'd sorely like to see these change to normal methods with more Perl-ish names: $dbh-raise_error(0); $sth-active; $sth-ix_cursor_with_hold(1); That

Re: DBI 2.0 interface change request

2004-08-04 Thread Jochen Wiedmann
John Siracusa wrote: Boldly speaking for the Entire Perl Community (ha!) interfaces like this: $x-foo(..., {...}) are generally considered icky. Who here doesn't cringe when they see those curly braces in a newly downloaded CPAN module's POD? I don't. :-)

Re: Overriding DBI-connect() for DBD::DB2

2004-08-06 Thread Jochen Wiedmann
[EMAIL PROTECTED] wrote: Hence we wrote DBD::MSDB2, which basically sub-classes DBD::DB2: This is, IMO, the right approach. However, doing this is not as easy as you might think. I once wrote a guide, see the section SUBCLASSING DBI DRIVERS in perldoc DBI::DBD. Jochen

Re: DBI 2.0 interface change request

2004-08-06 Thread Jochen Wiedmann
Matt Sergeant wrote: And easier to implement in C. I never found any difficulties in the methods handling properties? Jochen

Re: Suggestion - use gmail accounts for receiving bug reports, etc.

2004-10-22 Thread Jochen Wiedmann
Tim Bunce wrote: Why not use the free Request Tracker queues that exist for all CPAN modules: https://rt.cpan.org/NoAuth/Bugs.html?Dist=DBD-Informix https://rt.cpan.org/NoAuth/Dists.html?Queue=Informix Seems like a better way to manage bug reports etc., as that's what RT was designed to do.

Re: RFC: changes in DBD::Anydata DSNs

2004-12-16 Thread Jochen Wiedmann
On Thu, 16 Dec 2004 22:40:28 +0100, H.Merijn Brand [EMAIL PROTECTED] wrote: On Thu 16 Dec 2004 09:11, Jeff Zucker [EMAIL PROTECTED] wrote: On another topic: I am about to release a rather major interface change to Text::CSV_XS. Obviously it's not directly DBI but it does impact those who

Re: RFC: changes in DBD::Anydata DSNs

2004-12-16 Thread Jochen Wiedmann
Jeff Zucker wrote: After the dbi:AnyData:; everything should be in name=value; format. So dbi:AnyData:format=XML;table=Test;file=test.xml; Btw, Tim, how about the following suggestion: The discussion on the DSN format is, IMO, mainly caused by the fact, that the DBI doesn't support parsing the

Re: How to call a java method in PERL

2005-01-11 Thread Jochen Wiedmann
On Tue, 11 Jan 2005 14:46:46 +0530, Manoj Kumar [EMAIL PROTECTED] wrote: I would like to know from Perl community , how to I give call to a java method from perl . http://www.oreilly.com/catalog/prkunix/info/more_jpl.html -- Sum. Cogitone?

Re: Proposing an API for the extension for simplifying database connections

2005-01-13 Thread Jochen Wiedmann
On Thu, 13 Jan 2005 00:40:49 -0600, David Nicol [EMAIL PROTECTED] wrote: Am I missing something? Yes, to convince, at least me. I still don't understand, what this should be good for. If it is fine for you, with a limited number of drivers supported, then you may very well use it. You may as

Re: Proposing an API for the extension for simplifying database connections

2005-01-15 Thread Jochen Wiedmann
On Fri, 14 Jan 2005 15:30:33 -0600, David Nicol [EMAIL PROTECTED] wrote: wow I did not expect such negativity... I admit being a negative grumbler. At the age of 41 you can live with people who know you like you are. :-) However, it simply annoys me, if someone sells a matter of taste as

DBI/DBD Wikis

2005-03-17 Thread Jochen Wiedmann
Hi, on the DBD::mysql mailing list came up the suggestion for installing a Wiki somewhere. I wholeheartly support the issue (may be, because it was initially my suggestion :-), because I have experienced that Wikis have two advantages: - people are more ready to add something to a Wiki - people

Re: DBD::mysql 3.000 Released

2005-07-01 Thread Jochen Wiedmann
On 7/1/05, Steve Hay [EMAIL PROTECTED] wrote: to remove all mention of mysql_config which doesn't exist on Win32, and to sort out problems with long long, strncasecmp, etc. As Patrick seems to be an employee of MySQL AB: A possibly better solution would be to finally add mysql_config to the

Re: DBD::mysql 3.000 Released

2005-07-06 Thread Jochen Wiedmann
Paul DuBois wrote: I suppose one problem is that Windows doesn't have /bin/sh. mysql_config is a shell script. It does have cmd.exe. And for the purpose of mysql_config, that is way enough, isn't it? Jochen

Re: DBI v2 - The Plan and How You Can Help

2005-07-09 Thread Jochen Wiedmann
Jonathan Leffler wrote: I dunno which DBMS support prepare without a database connection, but I would expect all the mainstream databases to require a database connection. +1 I'm also far from convinced that there's any significant benefit in separating the 'create a database handle' from

Re: DBI v2 - The Plan and How You Can Help

2005-07-09 Thread Jochen Wiedmann
Jonathan Leffler wrote: Can you explain which parts of the SQL:2003 mandate this notation? I've had a moderately good poke around my copy of ISO/IEC 9075-2:2003 (SQL/Foundation) and cannot find this. I'd like a few section numbers listed which describe this. I second that one too. Besides,

Re: DBI v2 - The Plan and How You Can Help

2005-07-09 Thread Jochen Wiedmann
Jonathan Leffler wrote: Oh drat - not the DBI connection string discussion again! ;-)

Re: DBI v2 - The Plan and How You Can Help

2005-07-14 Thread Jochen Wiedmann
On 7/14/05, Sam Vilain [EMAIL PROTECTED] wrote: Of course it will be entirely possible to layer support for this sort of thing atop any DBI interface; Exactly my point. Please be so kind as to implement your ideas in a DBI extension. Time and community will prove whether you are right by using

Re: Some progress on Strange selectall_hashref/fetchall_hashref problem with DBD::mysql

2006-02-16 Thread Jochen Wiedmann
On Thu, Feb 16, 2006 at 11:59:31AM -, Martin J. Evans wrote: I've finally tracked this problem down and I believe it is down to the code which turns off server_side_prepare if the SQL looks like a create statement. Uuuh, I really do not like this typical clever driver approach. First