DBD::mysql & DBD::Pg email.

2004-01-19 Thread Rudy Lippan
Hey all, I have been pretty much offline for the past 2 weeks or so because of an illness in the family so that is why I have not been responding to any DBD::mysql/DBD::Pg related email (actually any email whatsoever). I will be sorting through spam and answering email tomorrow. Rudy

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread John Siracusa
On 1/19/04 7:41 PM, Tim Bunce wrote: > On Mon, Jan 19, 2004 at 07:19:05PM -0500, John Siracusa wrote: >> What about the other direction, allowing arbitrary code >> (\&my_deflate_thingie) to run during calls like: >> >> $sth->execute($val1, $val2, ...); > > I'm much less inclined to do that. S

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread Tim Bunce
On Mon, Jan 19, 2004 at 07:19:05PM -0500, John Siracusa wrote: > On 1/19/04 7:13 PM, Tim Bunce wrote: > > On Mon, Jan 19, 2004 at 11:19:04PM +, Tim Bunce wrote: > >> When I said "But I do think a "column type system" is needed to > >> provide the hooks that'll enable you to do what you want" I'

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread John Siracusa
On 1/19/04 7:13 PM, Tim Bunce wrote: > On Mon, Jan 19, 2004 at 11:19:04PM +, Tim Bunce wrote: >> When I said "But I do think a "column type system" is needed to >> provide the hooks that'll enable you to do what you want" I'm >> thinking in terms of some way to say "use this code ref by default

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread Tim Bunce
On Mon, Jan 19, 2004 at 11:19:04PM +, Tim Bunce wrote: > On Mon, Jan 19, 2004 at 02:32:17PM -0500, John Siracusa wrote: > > On 1/19/04 2:22 PM, Tim Bunce wrote: > > > Short answer: no. > > > > Can I please have the long answer? :) > > I have no time, I've a plane to catch. Perhaps others can

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread Tim Bunce
On Mon, Jan 19, 2004 at 02:32:17PM -0500, John Siracusa wrote: > On 1/19/04 2:22 PM, Tim Bunce wrote: > > Short answer: no. > > Can I please have the long answer? :) I have no time, I've a plane to catch. Perhaps others can share there views and examples. > Passing code > refs to bind_columns()

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread John Siracusa
On 1/19/04 2:22 PM, Tim Bunce wrote: > Short answer: no. Can I please have the long answer? :) I really think this type of thing is common enough that, at the very least, there should be convenient hooks for parsing and formatting dates (or possibly any column types). Passing code refs to bind_c

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread Tim Bunce
Short answer: no. If you want to use DateTime then I'd recommend the DateTime::Format::DBI module or something like it: http://search.cpan.org/~cfaerber/DateTime-Format-DBI-0.031/lib/DateTime/Format/DBI.pm Tim. On Mon, Jan 19, 2004 at 10:15:05AM -0500, John Siracusa wrote: > On 1/18/04 6:33 PM,

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread John Siracusa
On 1/19/04 4:28 AM, Matt Sergeant wrote: > On 18 Jan 2004, at 17:14, John Siracusa wrote: >> This topic came up before, when DateTime was just getting off the ground. >> DateTime is a lot more mature now, and I still think it's a good idea :) >> >> Along those lines, all of my DBI wrappers have al

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread John Siracusa
On 1/18/04 6:33 PM, Tim Bunce wrote: > My preference is that after doing: > > $sth->bind_column(1, undef, SQL_DATE); > $sth->bind_column(2, undef, SQL_DATETIME); > $sth->bind_column(3, undef, SQL_TIMESTAMP); > > the driver should ensure that it returns values for those three column in the > corre

Re: DBI version 2 - DBD-specific date parsing and formatting using DateTime

2004-01-19 Thread Matt Sergeant
On 18 Jan 2004, at 17:14, John Siracusa wrote: This topic came up before, when DateTime was just getting off the ground. DateTime is a lot more mature now, and I still think it's a good idea :) Along those lines, all of my DBI wrappers have also had a uniform API for DB-specific date parsing a