Re: parsing possible multi-line sql

Um, let me clarify -- I parse the sql that is bracketed by BEGINSQL and ENDSQL and feed it to DBI for execution. -Joe --- Peter Scott <[EMAIL PROTECTED]> wrote: > At 01:13 PM 3/18/02 -0800, Joe Raube wrote: > >I have a file that contains, among other things, SQL that is > >bracketed by BEGINSQL

Re: parsing possible multi-line sql

At 01:13 PM 3/18/02 -0800, Joe Raube wrote: >I have a file that contains, among other things, SQL that is >bracketed by BEGINSQL and ENDSQL. > >I have written perl code that parses this out and executes it, and it >is working for 99% of the cases. Sounds like you just reinvented a fairly large wh

Re: parsing possible multi-line sql

> I have a file that contains, among > other things, SQL that is > bracketed by BEGINSQL and ENDSQL. > > I have written perl code that parses > this out and executes it, and it is > working for 99% of the cases. > > I am getting some SQL though that > spans multiple lines. > > How can I parse o

Re: parsing possible multi-line sql

From: Joe Raube <[EMAIL PROTECTED]> > I have a file that contains, among other things, SQL that is > bracketed by BEGINSQL and ENDSQL. > > I have written perl code that parses this out and executes it, and it > is working for 99% of the cases. > > I am getting some SQL though t

parsing possible multi-line sql

I have a file that contains, among other things, SQL that is bracketed by BEGINSQL and ENDSQL. I have written perl code that parses this out and executes it, and it is working for 99% of the cases. I am getting some SQL though that spans multiple lines. How can I parse out this case? Thanks.