[sf-perl] Quick question on regular expression and substitution

[Loo, Peter # PHX]

Hi David,

We have the need to transfer data between several different types of
databases.  (Oracle, Netezza, SQL Server, Sybase, MySQL, etc...)  What I
have done is that I created sub-routines to accommodate inserts
dynamically.

Thanks.
 
Peter

-----Original Message-----
From: sanfrancisco-pm-bounces+peter.loo=source.wolterskluwer.com at pm.org
[mailto:sanfrancisco-pm-bounces+peter.loo=source.wolterskluwer.com at pm.or
g] On Behalf Of David Fetter
Sent: Wednesday, June 28, 2006 10:50 AM
To: San Francisco Perl Mongers User Group
Subject: Re: [sf-perl] Quick question on regular expression and
substitution

On Wed, Jun 28, 2006 at 10:05:11AM -0700, Loo, Peter # PHX wrote:
> 
> Hi David,
> 
> The problem is I won't know what position I need to change.  It is all

> dependent on the query.

I'm sorry to have to put it this way, but it looks like you're trying to
machine-generate SQL.  After years of watching smart people attempt
this, I have come to believe that machine-generated SQL has strong AI as
a component, which is Dave-ese for "Don't go there."

How about just writing out your SQL in the first place, keeping it
somewhere safe, and editing that somewhere at need?

Cheers,
D
--
David Fetter <david at fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
_______________________________________________
SanFrancisco-pm mailing list
SanFrancisco-pm at pm.org
http://mail.pm.org/mailman/listinfo/sanfrancisco-pm


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, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.