Re: DBD::Sybase make check errors

2005-05-13 Thread Michael Peppler
On Fri, 2005-05-13 at 15:27, Mark Vaughan wrote: > All, > I am receiving numerous errors when running the 'make check' for > DBD::Sybase. > > My environment: > Solaris 2.8 > Perl 5.6.1 > Freetds 0.63 > > Here is the output from 'make check': > > Running make test > PERL_DL_NONLAZY=1 /usr/bin/p

ANNOUNCE: SQL-Routine-SQLBuilder 0.18 (and SQL-Routine 0.62)

2005-05-13 Thread Darren Duncan
2005-05-13 Darren Duncan <[EMAIL PROTECTED]> -- Special Friday the 13th Release! Version 0.62 of SQL::Routine (SRT), a fully atomic and portable abstract syntax tree to define any database tasks, has been uploaded to CPAN; it should appear on your

Re: insert column if not exist

2005-05-13 Thread Ron Savage
On Fri, 13 May 2005 07:26:49 -0700 (PDT), Job Miller wrote: Hi Job > maybe a one time schema compare to ensure that the schema the app A CGI script giving you a color-coded diff between schemas is here: http://savage.net.au/Perl-tuts-1-30.html#tut_26 -- Cheers Ron Savage, [EMAIL PROTECTED] on

DBD::Oracle on MacOSX using Instant Client

2005-05-13 Thread Hilmar Lapp
As another episode of the DBD::Oracle on MacOSX quest, I tried the Oracle 10g Instant Client for 10.3 on Panther, using DBD::Oracle 1.16 (the latest I believe). First the good news (and it's primarily good news). The Instant Client is a charm to download and install (unless you can't type cp co

Re: insert column if not exist

2005-05-13 Thread Christopher Hicks
On Fri, 13 May 2005, Job Miller wrote: do you guys have users out there dropping columns that once existed? or do you just want to have applications that work regardless of whether the schema is actually the same or not? Neither of those. seems like if a column is missing, and it is worth checkin

Re: insert column if not exist

2005-05-13 Thread Job Miller
do you guys have users out there dropping columns that once existed? or do you just want to have applications that work regardless of whether the schema is actually the same or not? seems like if a column is missing, and it is worth checking for in a perl script, that there may be many other se

DBD::Sybase make check errors

2005-05-13 Thread Mark Vaughan
All, I am receiving numerous errors when running the 'make check' for DBD::Sybase. My environment: Solaris 2.8 Perl 5.6.1 Freetds 0.63 Here is the output from 'make check': Running make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/l

Re: insert column if not exist

2005-05-13 Thread Ing. Branislav Gerzo
Michael A Chase [MAC], on Thursday, May 12, 2005 at 05:48 (-0700) made these points: MAC> I'd do something like this: MAC>my $sth = $dbh -> column_info( undef, $sSchema, $sTable, $sColumn ); MAC>my @sColumnInfo = (); MAC>eval { # The eval isn't needed if RaiseError == 0. MAC> @sCo

Re: Perl Performance Help.

2005-05-13 Thread Shiva kumar
Look like problem lies with the Database Query. To check run the query from SQL prompt and checkout the time taken by the query(From ur explanation,seems query is taking two minutes). If the query is taking more time, then try indexing where clause columns --- Divya <[EMAIL PROTECTED]> wrote: >