Re: panic: DESTROY (dbih_clearcom) in trace output

2007-06-08 Thread Martin Evans
Tim Bunce wrote: On Thu, Jun 07, 2007 at 08:53:56PM +0100, Martin J. Evans wrote: (in cleanup) panic: DESTROY (dbih_clearcom) inner handle HASH is not a hash ref at /usr/lib/perl5/site_perl/5.8.8/DBIx/Log4perl/db.pm line 55. I can find in the following in dbih_inner /* extra

Re: Duplicate table structure

2007-06-08 Thread Peter Scott
On Thu, 07 Jun 2007 08:47:00 +0200, Dr.Ruud wrote: Peter Scott schreef: Is there a simple way to create a new table with the same structure as a given one in a *different* database? That means the CREATE TABLE foo AS SELECT * FROM bar WHERE 1=2 method won't work. I'd need to have two

Typo in documentation

2007-06-08 Thread Evan Duffield
Was reading your documentation and found a typo. Thought you might like to know. Due to the potentially high memory cost and unknown risks of loading in an unknown number of drivers that just happen to be installed on the system, this method is nor recommended for general use. It is

Re: panic: DESTROY (dbih_clearcom) in trace output

2007-06-08 Thread Tim Bunce
On Fri, Jun 08, 2007 at 11:58:23AM +0100, Martin Evans wrote: Tim Bunce wrote: On Thu, Jun 07, 2007 at 08:53:56PM +0100, Martin J. Evans wrote: (in cleanup) panic: DESTROY (dbih_clearcom) inner handle HASH is not a hash ref at

Error creating temporary tables using DBD::ODBC MSSQL

2007-06-08 Thread Hernan Arredondo
I all, I white the script: #!c:/Perl/bin/perl.exe use DBI; use DBD::ODBC; $dbh = DBI-connect('dbi:ODBC:DSN', 'user', 'pwd'); #$str_sql1 = ' #declare @rownum int #SELECT @rownum = (select count(*) #from master..sysprocesses (nolock) #where

Re: Typo in documentation

2007-06-08 Thread Tim Bunce
On Thu, Jun 07, 2007 at 03:38:48PM -0700, Evan Duffield wrote: Was reading your documentation and found a typo. Thought you might like to know. Due to the potentially high memory cost and unknown risks of loading in an unknown number of drivers that just happen to be installed on

Re: Duplicate table structure

2007-06-08 Thread Jared Still
On 6/8/07, Peter Scott [EMAIL PROTECTED] wrote: The suggestion of another poster to use dbms_metadata (see, e.g. http://builder.com.com/5100-6388-5054021.html) was a good one; I'd not heard of it before. If I have to do more than just column type definitions, or multiple tables, in the