Re: Does DBD::Sybase support a way to get the number of rows affected by a statement?

2004-12-09 Thread Michael Peppler
On Thu, 2004-12-09 at 23:03, David Goodman wrote: > I checked that DBD::Sybase documentation and did not > find a way to get the number of rows affected by the > previous statement. > > Is there an equivalent for ct_res_info()? Or is select > @@rowcount the only way to do it? ct_res_info() (in C

Re: Does DBD::Sybase support a way to get the number of rows affected by a statement?

2004-12-09 Thread Matthew Persico
True. You might as well just count along as you fetch. If you do() an insert/update or delete, the return value from the do is the number of rows (OEO on none, undef on error?) On Thu, 9 Dec 2004 20:45:20 -0500, Chuck Fox <[EMAIL PROTECTED]> wrote: > But for DBD::Sybase and most others it only t

Re: Does DBD::Sybase support a way to get the number of rows affected by a statement?

2004-12-09 Thread Chuck Fox
But for DBD::Sybase and most others it only tells you after you have fetched/processed the whole result set. Matthew Persico wrote on 12/9/2004, 7:56 PM: > Check the DBI docs - I seem to remember a generic function to call > for all DBDs which should be implemented to work for particular DBDs

DBD::mysql on OSX

2004-12-09 Thread Robert
Are there any gotchas for installing it? Robert

Re: Does DBD::Sybase support a way to get the number of rows affected by a statement?

2004-12-09 Thread Matthew Persico
Check the DBI docs - I seem to remember a generic function to call for all DBDs which should be implemented to work for particular DBDs On Thu, 9 Dec 2004 14:03:57 -0800 (PST), David Goodman <[EMAIL PROTECTED]> wrote: > I checked that DBD::Sybase documentation and did not > find a way to get the

Low reactivity in the update of ActivePerl ?

2004-12-09 Thread St�phane Lepolozec
Want excuse me for the brutal manner to say the things but it seems me to notice a rather low reactivity in the update of ActivePerl since the absorption of ActiveState by Sophos. A certain number of modules are not up to date any more and not the least as DBD::MySQL which remains blocked with vers

Low reactivity in the update of ActivePerl ?

2004-12-09 Thread St�phane Lepolozec
Want excuse me for the brutal manner to say the things but it seems me to notice a rather low reactivity in the update of ActivePerl since the absorption of ActiveState by Sophos. A certain number of modules are not up to date any more and not the least as DBD::MySQL which remains blocked with

Does DBD::Sybase support a way to get the number of rows affected by a statement?

2004-12-09 Thread David Goodman
I checked that DBD::Sybase documentation and did not find a way to get the number of rows affected by the previous statement. Is there an equivalent for ct_res_info()? Or is select @@rowcount the only way to do it? regards, David

RE: how can I extract String as UTF-8 under UNIX, my data was in SQL Server Database and stored as Unicode data

2004-12-09 Thread Jeff Urlwin
DBD::ODBC has not even been tested with UTF-8 data. Patches/tests most welcome!! Regards, Jeff > -Original Message- > From: Yonghui Wang [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 09, 2004 4:09 PM > To: [EMAIL PROTECTED] > Subject: how can I extract String as UTF-8 un

how can I extract String as UTF-8 under UNIX, my data was in SQL Server Database and stored as Unicode data

2004-12-09 Thread Yonghui Wang
when I simply use perl DBI, DBD::ODBC to connect to the database and try to extract the Unicode string( there is Chinese, Japanese, Korea) string stored in it, the return value is unreadable. I wish to get UTF-8 string so that those double byte language can be readable. so, what configuration

Re: Oracle Bulk Bind / Execute_Array

2004-12-09 Thread Ron Savage
On Thu, 9 Dec 2004 09:50:14 +, Tim Bunce wrote: Hi Folks >> Are bind_param_array() and array_execute() fully implemented in >> the DBD::Oracle driver?? Lateral thinking suggests you might try generating a data file and using Oracle's bulk load facility to read that quickly... -- Cheers Ron

Re: Oracle Bulk Bind / Execute_Array

2004-12-09 Thread Tim Bunce
On Thu, Dec 09, 2004 at 10:07:37AM -0500, Jeff Urlwin wrote: > > > > At least DBD::ODBC supports it. Not sure of any others. > > Er, ummm, not yet. Uh. Oh well. Tim. p.s. You forgot to say "Patches Welcome" :)

RE: MySQL 4.1.7 req'd DBD Version

2004-12-09 Thread Mike Garner
-Original Message- From: Rudy Lippan [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 6:05 PM To: Mike Garner Cc: [EMAIL PROTECTED] Subject: Re: MySQL 4.1.7 req'd DBD Version On Wed, 8 Dec 2004, Mike Garner wrote: > Hello all- > > No doubt this question has been asked but I'

RE: Oracle Bulk Bind / Execute_Array

2004-12-09 Thread Jeff Urlwin
> > At least DBD::ODBC supports it. Not sure of any others. Er, ummm, not yet. Jeff

Re: DBD::Informix and Apache::Session

2004-12-09 Thread Tielman De Villiers
On Thu, 2004-12-09 at 07:25 +, Jonathan Leffler wrote: > On Wed, 08 Dec 2004 16:18:06 +, Tielman de Villiers > <[EMAIL PROTECTED]> wrote: > > I am trying to use Informix with Apache::Session, but keep on > getting > > problems. > > This is the error in my apache log file: > > > > DBD

Re: DBIx::DBH - Perl extension for simplifying database connectio ns

2004-12-09 Thread Peter J. Holzer
On 2004-12-08 10:21:35 +1300, Sam Vilain wrote: > Orton, Yves wrote: > >DBD::Ingres does something similar. DBD::Oracle appears to be closer to > >Sybase/MySQl: > >"dbi:Oracle:host=myhost.com;sid=ORCL" > > Normally you don't bother with connection parameters with Oracle at all: > > DBI->connect

Re: Oracle Bulk Bind / Execute_Array

2004-12-09 Thread Tim Bunce
On Wed, Dec 08, 2004 at 11:50:02AM -0500, Kieran Hagzan wrote: > Hello, > > I am sure this question has come up hundreds of times, but I must ask it > again: > > Are bind_param_array() and array_execute() fully implemented in the > DBD::Oracle driver?? No. I've had offers of patches but

Re: DBIx::DBH - Perl extension for simplifying database connectio ns

2004-12-09 Thread Peter J. Holzer
On 2004-12-07 19:34:42 -0500, Christopher Hicks wrote: > On Wed, 8 Dec 2004, Andy Hassall wrote: > >>>The fact still remains that the generic "Host" slot could > >>>be used for this purpose quite easily, as could the "DB" slot. > >> > >>I really really object to the DB slot being called DB. Oracle

Re: Another db schema drawing tool: Dico and Druid

2004-12-09 Thread Ron Savage
Hi Folks New ones: Dico and Druid. Both require Java. http://savage.net.au/Ron//html/drawing-tools.html -- Cheers Ron Savage, [EMAIL PROTECTED] on 9/12/2004 http://savage.net.au/index.html

Re: DBIx::DBH - Perl extension for simplifying database connections

2004-12-09 Thread Peter J. Holzer
On 2004-12-07 22:36:58 -0800, Jonathan Leffler wrote: > ConnectionStrings.com - Forgot that connection string? You will ... > www.connectionstrings.com - All connection strings in one place! Here > you'll find the syntax for ... > > > It seems like someone else has already done it :-) > > (No, I