Re: how to set a DEFAULT value !!

On 4/26/06, Greg Sabino Mullane [EMAIL PROTECTED] wrote: DBI is complex enough, and AIUI the DBI philosophy opposes adding features to the core that will cause implementation headaches for driver authors. The standard perl idiom for default values is You misunderstand. The DEFAULT is

Re: how to set a DEFAULT value !!

Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 NotDashEscaped: You need GnuPG to verify this message Which database server is this? This is definitely the behavior of MySQL, PostgreSQL, and Oracle, and I'm pretty sure most others follow it as well. Whoa. Be

DBD::ODBC installation problem with Easysoft ODBC-Sybase driver

Hi folks -- I've got Easysoft's latest ODBC-Sybase driver installed, and I can connect to my Sybase database at the command line with isql sunline. However, I'm having trouble getting DBD::ODBC installed. I've included complete information (except my username and password) below. At least,

Fwd: Re: DBD::Oracle ppd

VS: Depending on your Perl version, you might try http://www.cedet.dk/perl - it has copies from ftp.esoftmatic.com for AS Perl 5.8.0,2,3,4! HTH Michael Garfield Sørensen, CeDeT Quoting Jeffrey Seger [EMAIL PROTECTED]: Any other repositories anyone knows of where I can download this? I

Re: how to set a DEFAULT value !!

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is it a string that's sent, or the identifier? For NULL, it is either an identifier (not quoted) or Perl undef that denotes NULL in the DBMS. I'm not sure how you'd represent DEFAULT in Perl, or as a string rather than an identifier. DBI (or

Checking if a table exist

Hi All, Does anyone know of a good way to check if a table exist disregarding whether the table has data or not? Thanks. Peter This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use,

Re: how to set a DEFAULT value !!

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This is definitely the behavior of MySQL, PostgreSQL, and Oracle, and I'm pretty sure most others follow it as well. Whoa. Be careful what you say about Oracle. Oracle does have default values for table columns, defined by the DEFAULT

dbi.perl.org isn't working all that great

Hi, Maybe this is old news to some, but the FAQ link and support-details links (any of them) aren't working on dbi.perl.org. Jay

Re: Checking if a table exist

On 4/27/06, Loo, Peter # PHX [EMAIL PROTECTED] wrote: Does anyone know of a good way to check if a table exist disregarding whether the table has data or not? Simplest is: my $sth = $dbh-prepare(SELECT * FROM $tablename); if ($sth) { ...table exists...probably; you might need to do

Re: Checking if a table exist

On Thu, 27 Apr 2006 17:17:26 -0700, Jonathan Leffler wrote: Hi Jonathan my $sth = $dbh-prepare(SELECT * FROM $tablename); if ($sth) { ...table exists...probably; you might need to do $sth- execute to be sure as different DBMS differ... } else { ...table probably doesn't exist, or it

RE: Checking if a table exist

Thanks Jonathan. I was thinking about doing something like this: @tables = $dbh-tables(); if ((grep/$tableName/, @tables) = 0) { ... From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 5:17 PM To: Loo, Peter # PHX Cc: DBI

Re: Re: DBD::Oracle ppd

On 4/27/06, Michael Garfield Sørensen, CeDeT [EMAIL PROTECTED] wrote: VS: Depending on your Perl version, you might try http://www.cedet.dk/perl - it has copies from ftp.esoftmatic.com for AS Perl 5.8.0,2,3,4! HTH Michael Garfield Sørensen, CeDeT Michael: Thanks! You're a life-saver!