Question regarding dbi:ADO isolation level,Connection and command properties , and streams

Hi all I have a few questions that I have not seen anything in the archives for. I have ADO2.1 installed on DBI 1.16 1. dbi:ADO supports setting Isolation Level but only as a number. Is there a reason that it does not seem to use the ado_const's, eg adXactBrowse 2.dbi:ADO supports setting Connec

Re: ANNOUNCE: DBD::Oracle 1.07

On Wed, Jun 06, 2001 at 09:27:56AM +0200, H.Merijn Brand wrote: > > cc -c -I/pro/oracle/v7341/rdbms/demo -I/pro/oracle/v7341/rdbms/public -I. >-I/pro/oracle/v7341/rdbms/demo -I/pro/oracle/v7341/rdbms/demo >-I/pro/lib/perl5/site_perl/5.6.1/PA-RISC2.0/auto/DBI -DDEBUGGING -Ae -D_HPUX_SOURCE >-I/

Re: DBI Mysql socket problems

Here's a hunch: You upgraded MySQL recently. Here's why I'm thinking this. The location of mysql's socket file is a compile time option. You installed mysql, then installed DBD::mysql (or Msql-Mysql-modules...). When the DBD drivers are compiled against the mysql libraries, they get the location

Generic DBI "insert_hash" subroutine

Just thought I would send a bug fix on a very nice piece of code sent by Doug Wilson - Doug's generic subroutine "insert_hash": sub insert_hash { my $table = shift; my $ref = shift; #Sort fields so we can effectively cache the statement my @fields = sort keys %$ref; my @values = @{$ref

RE: Generic DBI "insert_hash" subroutine

-Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 7:21 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Generic DBI "insert_hash" subroutine > The line that contains the "insert into $table" contains one > small but significant bug -

DBD::Pg and date operations

I have a date expression in a scalar like this: $mydate = q!timestamp 'today' - interval '30 days'!; I want to execute a statement like this: $stmt = $dbh->prepare('SELECT * FROM foo WHERE date_added > ?'); $stmt->execute($mydate); DBD::Pg reports that the date is invalid. But if I change thi

RE: Generic DBI "insert_hash" subroutine

This ought to work (left in debug print statement) (its more limited than the insert since where clauses can include more than just 'and' conditionals): use strict; sub update_hash { my $dbh = shift; my $table = shift; my $upd_ref = shift; my $where_ref = shift; my @upd_fields = sort keys %

RE: :Pg and date operations

Looks like a quoting problem. print $dbh->quote($mydate); will print out the exact string that is binded to the query and you can debug from there. Ilya Sterin -Original Message- From: Jeff Boes To: [EMAIL PROTECTED] Sent: 6/6/01 8:43 AM Subject: DBD::Pg and date operations I have

Re: DBD::Pg and date operations

On Wed, Jun 06, 2001 at 10:43:52AM -0400, Jeff Boes wrote: > > I have a date expression in a scalar like this: > > $mydate = q!timestamp 'today' - interval '30 days'!; > > I want to execute a statement like this: > > $stmt = $dbh->prepare('SELECT * FROM foo WHERE date_added > ?'); > $stmt->exe

I want to unsuscribe

Please i've tryied to unsuscribe for at least 3 weeks, please unsuscribeme, the topics are very interesting but there are too many

RE: I want to unsuscribe

Funny how no one ever says "I sent a message to [EMAIL PROTECTED] X days ago and I'm still not unsubscribed." -Original Message- From: Juan Sebastian Jaramillo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 8:51 AM To: [EMAIL PROTECTED] Subject: I want to unsuscribe Please i'

RE: Marketing DBI

More PRO arguments: If "use strict;" is used (and I use it all the time), you get error checking, which will save lots of debugging time. Of course, you get error checking in PL/SQL but not much in shell scripts. It's easy to waste lots of time trying to troubleshoot a typographical error in a

RE: I want to unsuscribe

> Funny how no one ever says "I sent a message to > [EMAIL PROTECTED] X days ago and I'm > still not unsubscribed." > Strange phenomenon, isn't it? Mind you the old list manager inserted a footer to every mail with instructions on just how to do this. This seems to have gone now. Perhaps it coul

Re: I want to unsuscribe

You have a point -- But I also subscribe to Unix Tip of the day, and they provide the following in each email: # # # # # # # SNIP # # # # # # # # # # -- To Subscribe:http://www.ugu.com/sui/ugu/show?tip.subscribe To Uns

RE: I want to unsuscribe

At 05:07 PM 6/6/01 +0100, John Reid wrote: >Mind you the old list manager inserted a footer to every mail with >instructions on just how to do this. This seems to have gone now. Perhaps it >could be reintroduced? Nope, it's still there. I see the following with every email in the header: List-P

RE: I want to unsuscribe

My suggestion would be to employ the RulzWizard of whatever email client you are using. Just have it filter out messages sent TO [EMAIL PROTECTED] and send them to their own, very special DBI Spam folder. There is too much good stuff going on in here to let logistics get in the way. ;> Eric

DB connection problems

Hi, I have a number of scripts which pull info from remote database's, this info is in turn loaded into a local db for metrics. The problem I have is while the script runs no problem, if one of the remote db's is down it bombs the whole script, is there any way to skip if there is a error ?

DBD-Oracle-1.07

There is a lost "fi" at line 2670 in the Makefile (DB-Oracle-1.07). I have noticed the same at the previous DBD-Oracle version (DB-Oracle-1.06) What shall I do ? Can I just take it off ? Thanks, Katja See part of the code below : > IBSKGXPD_STATIC=$(RDBMSLIB)$(LIB_PREFIX)$(SKGXPD_NA

RE: DB connection problems

This would be one place to either: 1) NOT use 'RaiseError=>1' and check every DBI statement and handle failures however you want. OR 2) use 'RaiseError=>1' on the connect, but do it in an eval block and skip this database if the connect fails. -Original Message- From: Gilmour Sean-WSG014

Re: Question regarding dbi:ADO isolation level,Connection and command properties , and streams

On Wed, Jun 06, 2001 at 11:17:25AM +0100, [EMAIL PROTECTED] wrote: > Hi all I have a few questions that I have not seen anything in the archives > for. I have ADO2.1 installed on DBI 1.16 > 1. dbi:ADO supports setting Isolation Level but only as a number. Is there a > reason that it does not seem

Re: I want to unsuscribe

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, Jun 06, 2001 at 05:07:42PM +0100, John Reid wrote: > Mind you the old list manager inserted a footer to every mail with > instructions on just how to do this. This seems to have gone now. Perhaps it > could be reintroduced? Waste of bandwidth

RE: I want to unsuscribe

Yes, And wouldn't this world be a better place if all people were replaced by androids too. -Original Message- From: Stephen Clouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 11:28 AM To: John Reid Cc: Wilson, Doug; [EMAIL PROTECTED] Subject: Re: I want to unsuscribe

Re: I want to unsuscribe

Steven -- I admit that 99.9% (100%) of all computer errors are user generated in some way, but don't you think that it would improve the usabiity of the list ? The problem is that these people who are disinterested and throw away the manual create OT traffic on the list, making it 'noisy' for

RE: I want to unsuscribe

I agree with Stephen. I definitelly don't want my space wasted with 500 extra bytes of junk for each email, not that people don't have sufficient space or that it's expensive these days (dirt cheap), this is a professional list, not a [EMAIL PROTECTED], where these people need to be told every de

Re: I want to unsuscribe

On Wed, 06 Jun 2001 11:58:35 -0400, Sean Cooper wrote: >You have a point -- But I also subscribe to Unix Tip of the day, and they >provide the following in each email: >To Subscribe:http://www.ugu.com/sui/ugu/show?tip.subscribe >To Unsubscribe: http://www.ugu.com/sui/ugu/show?tip.unsubscri

Re: I want to unsuscribe

On Wed, 6 Jun 2001, Bart Lateur wrote: > On Wed, 06 Jun 2001 11:58:35 -0400, Sean Cooper wrote: > > Check the mail headers for every mail distributed through this list. In > there you can see: > > >List-Unsubscribe: > >List-Subscribe: Plus,

RE: I want to unsuscribe

You have to remember, though, that alot of us use crippled email bloatware (Outlook) and can't view all the headers. (At least I am not aware how to do it). -Original Message- From: Bart Lateur [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 12:01 PM To: mailing list Subject: Re

Newbie looking for some Win32::ODBC Help

Could some one help me here and tell me what's wrong with the following code: #= $DSN= "IPMac"; $Table="dbo_Network_DATA"; $Table2="dbo_Computer_System_data"; $Table3=" dbo_User_data"; $Ta

RE: I want to unsuscribe

This keeps drifting farther and farther off-topic, but If the information from the headers were transfered to a small footer appended to each message, you would be moving the "500 bytes" rather than increasing the overall message size. And the information would be accessible to everyone and

RE: I want to unsuscribe

But then when you try to read an email that has been replied to 6 times, you must fussing with 6 footers:-) That can't be fun. Ilya Sterin -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 6/6/01 1:32 PM Subject: RE: I want to unsuscribe This keeps drifting farther

Re: I want to unsuscribe

On Wed, Jun 06, 2001 at 02:04:51PM -0600, Sterin, Ilya wrote: > But then when you try to read an email that has been replied to 6 times, you > must fussing with 6 footers:-) That can't be fun. Only if the person replying didn't bother to trim the message he was replying to. Sort of like half th

RE: I want to unsuscribe

Of course ... With a good mailing list engine it could automatically remove the duplicate footer lines. And with Perl that should be easy to do =:) -Original Message- From: Ronald J Kimball [mailto:[EMAIL PROTECTED]] On Wed, Jun 06, 2001 at 02:04:51PM -0600, Sterin, Ilya wrote: >

Memory persistent

Hi you all. I need your help. I am making a CD-ROM for shipping with PERL2EXE. How do i make the executable module memory persistent ? Thank you for your help and sorry about my english. Vivian.

ANNOUNCE: Alzabo 0.45

Alzabo is a program and a module suite, with two core functions. Its first use is as a data modelling tool. Through either a schema creation interface or a perl program, you can create a set of schema, table, column, etc. objects to represent your data model. Alzabo is also capable of reverse eng

RE: I want to unsuscribe

Well depends. Sometimes you don't want them trimmed, so if someone comes in in the middle of the thread, they don't have to read each and every message, but rather the last one. Ilya -Original Message- From: Ronald J Kimball To: Sterin, Ilya Cc: '[EMAIL PROTECTED] '; '[EMAIL PROTECTED]

RE: Memory persistent

This question is not related to DBI. You might want to try a list where this will be on topic. Ilya Sterin -Original Message- From: webmaster To: [EMAIL PROTECTED] Sent: 6/6/01 2:38 PM Subject: Memory persistent Hi you all. I need your help. I am making a CD-ROM for shipping with PERL

Re: I want to unsuscribe

On Wed, Jun 06, 2001 at 02:57:05PM -0600, Sterin, Ilya wrote: > Well depends. Sometimes you don't want them trimmed, so if someone comes in > in the middle of the thread, they don't have to read each and every message, > but rather the last one. That's ridiculous. If someone comes in in the mid

RE: I want to unsuscribe

You are right as far as subscribing, but I was thinking about something else. For example when I get to work in the morning and check the email, being an international mailing list, there are already many messages in my mailbox. One message has ten replies, but if I or anyone else needs to get i

Re: I want to unsuscribe

As my inclusion of the previous message implies I prefer to have not have messages trimmed on occassion... many times the thread goes over several days and either I don't want to search for the original message, or have already deleted the original message, or don't have access to the archive

Re: I want to unsuscribe

Alt-Enter. It doesn't matter where you put the information. It could be in blinking letters aross the top and you'd still get the same number of clueless asking the same question. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll

Re: I want to unsuscribe

On Wed, 6 Jun 2001 12:09:11 -0700 , Wilson, Doug wrote: >You have to remember, though, that alot of us use crippled email >bloatware (Outlook) and can't view all the headers. (At least >I am not aware how to do it). If you're talking about Outlook Express (not quite the same thing, but I don't h

DBD-Oracle 1.0.7/AIX make problem

Hi, I am working on the following environment: AIX 4.3.3, Oracle 8.1.6i, Perl 5.00503 , DBI 1.15, DBD-Oracle 1.0.7 I am trying to install want to install DBD-Oracle 1.0.7. After perl Makefile.PL, make gives me the following error message: >make Makefile:2425: *** missing separator (did you me