Re: Large files

2002-09-11 Thread Joe Raube
When it dies, what error do you get? --- Rob <[EMAIL PROTECTED]> wrote: > Hi, I'm parsing a 16 meg file and my program dies 111 lines from > the > bottom. The record that it stops isn't any different from the ones > that > make it through. If I delete from there down it works ok and if I > dele

RE: perl and Oracle

2002-09-11 Thread Joe Raube
gt; > Ângelo Marcos Rigo > Webmaster Colégio Anchieta > http://www.colegioanchieta.g12.br > > > -Original Message- > From: Joe Raube [mailto:[EMAIL PROTECTED]] > Sent: quarta-feira, 11 de setembro de 2002 9:40 > To: Angelo Marcos Rigo; [EMAIL PROTECTED] > Subje

RE: perl and Oracle

2002-09-11 Thread Joe Raube
> that´s it? > > The tnsnames.ora is stored on the windows/oracle? if he does not > exists > how can i create it? > > thank´s in advance > > Ângelo Marcos Rigo > Webmaster Colégio Anchieta > http://www.colegioanchieta.g12.br > > > -Original Message-

RE: perl and Oracle

2002-09-11 Thread Joe Raube
> there is no need to point the hostname or ip adress of the > windows/oracle machine? > my $dbh = DBI->connect( > 'dbi:Oracle:testdb','USERNAME','PASSWORD',) >|| die "Database connection not made: $DBI::errstr"; The connect does this via the tnsnames.ora file, which has an alia

Re: So what is munging?

2002-07-29 Thread Joe Raube
>From Data Munging with Perl web site, http://www.manning.com/cross/ "Your desktop dictionary may not include it, but 'munging' is a common term in the programmer’s world. Many computing tasks require taking data from one computer system, manipulating it in some way, and passing it to another.

Re: Jes new to List

2002-07-25 Thread Joe Raube
So what part are you having trouble with Tell us what you don't understand. -Joe --- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Strolling thru' Learning Perl and already have a few q's in mind: > > I couldn't quite follow this program off the book. The parts not > quite > clear to m

Re: Can Perl interact with XML?

2002-07-11 Thread Joe Raube
Also see the columns on xml.com http://www.xml.com/pub/q/perlxml -Joe --- Wiggins d'Anconia <[EMAIL PROTECTED]> wrote: > Perl has a lot of resources for working with XML in most of the > standard > ways, aka DOM, SAX, etc. O'Reilly has a "Perl and XML" book that > is a > very good read for an

RE: Perl DBI and Oracle

2002-06-27 Thread Joe Raube
I think that if you posted some code, we could give better assistance with this matter. --- "Jackson, Harry" <[EMAIL PROTECTED]> wrote: > > I retrieve a load of records but because the default linesize means > that it > comes out on multiple lines when printing to a CSV. I suppose I > could

Re: Perl DBI and Oracle

2002-06-27 Thread Joe Raube
"set linesize" is a SQL*Plus command to control the size of an output line dbi is used for manipulating data from a database, the output is controlled by you... What are you trying to accomplish? -Joe --- "Jackson, Harry" <[EMAIL PROTECTED]> wrote: > Ho do you > > set linesize 1000; >

Re: unable to insert data into two tables at same time

2002-06-16 Thread Joe Raube
Add || die etc, etc to your $sth->execute() statement -- possibly the error messages will help you debug this better. --- Yuan Cheng <[EMAIL PROTECTED]> wrote: > Hi, there: > > I try to write a perl code that takes form data from > html page and inserts or updates database tables. I > have s

Re: DBI data source for MS SQL server

2002-06-11 Thread Joe Raube
What kind of help? What have you tried so far? What platform are you running Perl on? More info would be helpful... -Joe --- learn perl <[EMAIL PROTECTED]> wrote: > Hi folks, > > Need help with the connection data source for MS SQL server. > > Thanks > > Eric > > > -- > To unsubscribe, e-

Re: DBI and DBD:: Oracle problem

2002-06-07 Thread Joe Raube
What does your table look like? What is the data type of the 4th field? --- Naser Ali <[EMAIL PROTECTED]> wrote: > U have this program which connects to an Oracle 8i database but I > get the > following error message. Can anyone help please, > > = > #!/usr

Re: [Fwd: Perl documentation]

2002-05-14 Thread Joe Raube
search.cpan.org --- Eley Greg <[EMAIL PROTECTED]> wrote: > > ATTACHMENT part 2 message/rfc822 > Date: Tue, 14 May 2002 13:06:25 -0400 > From: eley greg <[EMAIL PROTECTED]> > Organization: BAH > To: Frank Wiles <[EMAIL PROTECTED]> > Subject: Re: Perl documentation > > Thank you for the input

Re: perl-modules

2002-04-06 Thread Joe Raube
Sounds more like a linux distribution question - as if you are trying to install autoconf, and it requires a package called perl-modules. What distribution are you using? -Joe --- Robert Brandtjen <[EMAIL PROTECTED]> wrote: > Umm - I can't find this at cpan.org - does it have another name ? >

Re: parsing possible multi-line sql

2002-03-18 Thread Joe Raube
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 > >

parsing possible multi-line sql

2002-03-18 Thread Joe Raube
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.

Re: help with perl/Tk

2002-03-07 Thread Joe Raube
My guess would be this line: $filebutton=$menubar->Menubutton;(-text="File", -underline=>0); with the semi-colon after the word Menubutton __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free ema