RE: fetchall_hashref error: invalid number of parameters?

2004-01-03 Thread Ron Goral
Thanks Rob - There is a difference between what is on CPAN and what is at perldoc.com. The CPAN manpage shows that fetchall_hashref will return only a single field so it is $sth->fetchall_hashref($keyfield) as you pointed out. The method to use for what I want to do is to use $sth->fetchall_array

Re: Help find info for CPAN update config questions

2004-01-03 Thread Daniel Staal
--As off Saturday, January 3, 2004 3:41 PM -0800, J Ingersoll is alleged to have said: (Snipped) As for my request for documentation, it was mainly for --- Q: Should all FTP connections be passive (y|n) ? One way visibility ... So for these types of firewall FTP connec-

RE: Simple db - PERL vs MS SQL Server

2004-01-03 Thread Tim Johnson
This is kind of a misleading subject line. Personally, I would say that if you already have access to a SQL Server DB then you should stay with it. Trying to roll your own flat file DB would be a whole new can of worms. Why waste your time reinventing the wheel when you can work on the most e

Re: opening textfile on macosx

2004-01-03 Thread James Edward Gray II
On Jan 3, 2004, at 3:08 PM, Johan Meskens CS3 jmcs3 wrote: hi Hello there. i am on macosx 10.2 Welcome fellow Mac fan. i am creating file.txt with otherfile.pl i would like to open file.txt in the app TextEdit through otherfile.pl There is a command line app called 'open' you can shell out to f

Re: Help find info for CPAN update config questions

2004-01-03 Thread J Ingersoll
--- Owen <[EMAIL PROTECTED]> wrote: > On Thu, 1 Jan 2004 05:18:00 -0800 (PST) > J Ingersoll <[EMAIL PROTECTED]> wrote: > > > IS THERE a manual / document somewhere that explains in a little > > detail what is being asked in this config process? > > perldoc CPAN > > That will answer all your

Simple db - PERL vs MS SQL Server

2004-01-03 Thread Andy
Hi all, I currently have a very simple, fairly small (25,000 records), one table database in MS SQL Server that is accessed for read only & read / write (dependant on user interface) via ASP on IIS (running on NT4 SP6). I am considering moving the from ASP to PERL CGI for accessing & rendering th

Re: fetchall_hashref error: invalid number of parameters?

2004-01-03 Thread Rob Dixon
Ron Goral wrote: > > From: Rob Dixon [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 03, 2004 9:51 AM > To: [EMAIL PROTECTED] > Subject: Re: fetchall_hashref error: invalid number of parameters? > > > > > > Ron Goral wrote: > > > > > > I am trying to hit a MySQL database using DBI::mysql. I

RE: fetchall_hashref error: invalid number of parameters?

2004-01-03 Thread Ron Goral
Hey Rob - fetchall_hashref is an array ref of hash refs (one hash ref per row contained in an array ref), so I have to dereference and iterate the array ref to get to the hash refs underneath. The DBI Manpage says: "It returns a reference to an array that contains one hash of field name and value

Re: adding the date::calc module

2004-01-03 Thread Rob Dixon
Stuart White wrote: > > I've been told that I can add the date::calc module > from the command line using a one line command as > opposed to going to perl.org and compiling it. > Unfortunately though, I can't get into that email acct > where that email with instructions is stored. > > Does anyone k

Re: adding the date::calc module

2004-01-03 Thread Kenton Brede
On Sat, Jan 03, 2004 at 08:56:42AM -0800, Stuart White wrote: > I've been told that I can add the date::calc module > from the command line using a one line command as > opposed to going to perl.org and compiling it. > Unfortunately though, I can't get into that email acct > where that email with

adding the date::calc module

2004-01-03 Thread Stuart White
I've been told that I can add the date::calc module from the command line using a one line command as opposed to going to perl.org and compiling it. Unfortunately though, I can't get into that email acct where that email with instructions is stored. Does anyone know how I can install it from th

Re: Drawing an Arc at an angle.

2004-01-03 Thread Fred Nastos
On January 2, 2004 05:22 pm, Dan Muey wrote: > Hello List, > > I've made a funtion to calculate the Fresnal zone for wireless connections. > > What I'd like to do is generate an image based on that. Something like the > example at: http://ydi.com/calculation/fresnel-zone.php > > However the two con

Re: fetchall_hashref error: invalid number of parameters?

2004-01-03 Thread Rob Dixon
Ron Goral wrote: > > I am trying to hit a MySQL database using DBI::mysql. I am trying to get > table information using the SQL - "SHOW TABLE STATUS". > > The statement handle prepares and then executes as it should, but when I try > to get the info via $sth->fetchall_hashref, I get the following

fetchall_hashref error: invalid number of parameters?

2004-01-03 Thread Ron Goral
Howdy all - I am trying to hit a MySQL database using DBI::mysql. I am trying to get table information using the SQL - "SHOW TABLE STATUS". The statement handle prepares and then executes as it should, but when I try to get the info via $sth->fetchall_hashref, I get the following error: ===

Re: Integer out of range.....

2004-01-03 Thread Rob Dixon
John W. Krahn wrote: > > Bee wrote: > > > > Anything I can do to working like this ? > > > > print for ( 0.. 3410068347520) ; > > for ( my $i = 0; $i <= 3_410_068_347_520; ++$i ) { > print $i; > } Except that standard integer arithmetic is only good for about fifteen significant digits. It ma

Re: regex multiple lines

2004-01-03 Thread Rob Dixon
Ramprasad A Padmanabhan wrote: > > James Taylor wrote: > > > > On Jan 2, 2004, at 5:38 PM, James Taylor wrote: > >> > >> I'm trying to parse a bit out of an HTML file, where the formatting > >> could change daily as far as spaces/newlines go. Say for example I > >> have something like this: > >> >

Re: regex multiple lines

2004-01-03 Thread Ramprasad A Padmanabhan
James Taylor wrote: ok, well I ended up dropping the regex and splitting the strings and re-building them after being inspired by another thread. so, my $str="text text to be replac ed"; my $repl="replacement text"; my ($a,$b)=split('',$str); my ($c,$d)=split('',$b); $str=$a.$repl.$d; I'd still

Re: Integer out of range.....

2004-01-03 Thread John W. Krahn
Bee wrote: > > Anything I can do to working like this ? > > print for ( 0.. 3410068347520) ; for ( my $i = 0; $i <= 3_410_068_347_520; ++$i ) { print $i; } John -- use Perl; program fulfillment -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PRO

Re: Help find info for CPAN update config questions

2004-01-03 Thread Owen
On Thu, 1 Jan 2004 05:18:00 -0800 (PST) J Ingersoll <[EMAIL PROTECTED]> wrote: > IS THERE a manual / document somewhere that explains in a little > detail what is being asked in this config process? perldoc CPAN That will answer all your questions -- Owen -- To unsubscribe, e-mail: [EM

Re: from bash to perl; source() equivalent

2004-01-03 Thread Ramprasad A Padmanabhan
> Thanks, Ram. I was rather hoping there was something simpler than fully-fledged > modules. > > Basically what I've done is set up a single script and a bunch of config files. > Each config file ends in > > #%include bin/script.pl > > And I use a minimalist PerlPP to include it. This is s