[14261] in Perl-Users-Digest
Perl-Users Digest, Issue: 1670 Volume: 9
daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Sun Dec 19 20:57:12 1999
Date: Sun, 19 Dec 1999 17:57:00 -0800 (PST)
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)
Message-Id: <945655020-v9-i1670@ruby.oce.orst.edu>
Content-Type: text
Perl-Users Digest Sun, 19 Dec 1999 Volume: 9 Number: 1670
Today's topics:
Confussed and lost - Could use a little guidance! <kitchen.table@avoncliffe.com>
Re: Confussed and lost - Could use a little guidance! <jphillip@onyx.southwind.net>
Re: Confussed and lost - Could use a little guidance! <jeff@vpservices.com>
Re: Confussed and lost - Could use a little guidance! (Abigail)
Re: Confussed and lost - Could use a little guidance! <aarond@ieighty.net>
Connect to Informnix Database through Perl <dominic01@hotmail.com>
Re: Connect to Informnix Database through Perl <kagel@bloomberg.net>
Re: Converting a string to lowercase (Abigail)
Re: Converting a string to lowercase <bbridges@seark.net>
Re: Converting a string to lowercase <cassell@mail.cor.epa.gov>
Cookie Arrays (Was Re: CGI Question Basic Question - Ki <jeff@vpservices.com>
Re: Cookie Arrays (Was Re: CGI Question Basic Question desertedge@my-deja.com
CPAN DBI <andy_longworth@bigfoot.com>
Re: CPAN DBI <newsposter@cthulhu.demon.nl>
Re: CPAN DBI <jeff@vpservices.com>
CPU load time for a message board <yutliu@indiana.edu>
Re: CPU load time for a message board (Abigail)
Re: CPU load time for a message board <yutliu@indiana.edu>
Re: CPU load time for a message board (Abigail)
Re: CPU load time for a message board <yutliu@indiana.edu>
Re: CPU load time for a message board (Abigail)
Re: CPU load time for a message board <kmsproule@worldnet.att.net>
Re: CPU load time for a message board (Abigail)
Digest Administrivia (Last modified: 16 Sep 99) (Perl-Users-Digest Admin)
----------------------------------------------------------------------
Date: Sat, 18 Dec 1999 16:13:40 -0000
From: "Karen's Kitchen Table" <kitchen.table@avoncliffe.com>
Subject: Confussed and lost - Could use a little guidance!
Message-Id: <385ba4b5_2@einstien.netscapeonline.co.uk>
Hi
I'm confused and lost in this land of PERL and could do with a
little help, or have I simply missed a basic point?
I will apologise in advance if this is the wrong newsgroup.
What I would like to achieve is to be able to test my PERL
scripts locally on my Win98 PC without having to upload them to
my webserver and then debug them online running up the phone
bill.
I've downloaded and installed the ActivePerl stuff from
http://www.activestate.com/ and it seems to work Ok with a simple
"Hello World" type PERL programme run from the command line.
But I can't get it to work if I call the .PL script via my
browser.
Perl is installed to C:\Program Files\PERL\ and the top line of
my PERL script has #!/progra~1/perl/bin
I've even been down to my local computer shop this morning and
purchased a book on PERL and CGI for the WWW but although it
looks a good book all the examples are written to run of the
server.
Any help or pointers in the right general direction would be
welcome so that I can achieve my goal.
Is ActivePerl the right stuff or doing I keen something else.
Thanks in advance
Geoff
------------------------------
Date: Sat, 18 Dec 1999 18:15:10 GMT
From: John Phillips <jphillip@onyx.southwind.net>
Subject: Re: Confussed and lost - Could use a little guidance!
Message-Id: <OaQ64.8895$Ke.496672@tw11.nn.bcandid.com>
You need a WEB server installed on your machine, such as 'Apache'.
John Phillips
Karen's Kitchen Table <kitchen.table@avoncliffe.com> wrote:
> Hi
> I'm confused and lost in this land of PERL and could do with a
> little help, or have I simply missed a basic point?
> I will apologise in advance if this is the wrong newsgroup.
> What I would like to achieve is to be able to test my PERL
> scripts locally on my Win98 PC without having to upload them to
> my webserver and then debug them online running up the phone
> bill.
> I've downloaded and installed the ActivePerl stuff from
> http://www.activestate.com/ and it seems to work Ok with a simple
> "Hello World" type PERL programme run from the command line.
> But I can't get it to work if I call the .PL script via my
> browser.
> Perl is installed to C:\Program Files\PERL\ and the top line of
> my PERL script has #!/progra~1/perl/bin
> I've even been down to my local computer shop this morning and
> purchased a book on PERL and CGI for the WWW but although it
> looks a good book all the examples are written to run of the
> server.
> Any help or pointers in the right general direction would be
> welcome so that I can achieve my goal.
> Is ActivePerl the right stuff or doing I keen something else.
> Thanks in advance
> Geoff
--
------------------------------
Date: 18 Dec 1999 18:52:46 GMT
From: Jeff Zucker <jeff@vpservices.com>
Subject: Re: Confussed and lost - Could use a little guidance!
Message-Id: <385BD79E.1684EA28@vpservices.com>
Karen's Kitchen Table wrote:
>
> What I would like to achieve is to be able to test my PERL
> scripts locally on my Win98 PC without having to upload them to
> my webserver and then debug them online running up the phone
> bill.
>
> I've downloaded and installed the ActivePerl
Good, you have Perl, that is ingredient number one.
> But I can't get it to work if I call the .PL script via my
> browser.
Good, you have a browser, that is ingredient number two.
> looks a good book all the examples are written to run of the
> server.
Well, unfortunately, you see, that is ingredient number three: a
webserver. CGI scripts and browsers do not talk to each other directly,
they need a webserver to act as an intermediary. However you seem to
have gotten confused between a server *machine* and webserver
*software*. The server machine is apparently run by your ISP and you
have to dial in to access it. On that server machine is a piece of
webserver software. But you can avoid the phone bills by installing
that webserver software on your own local machine and test your CGI
scripts to your heart's content, then later upload them to the ISP's
machine for the rest of the world to see. There are many free and easy
to install webserver softwares for win32 -- apache, xitami, omnihttpd,
tinyweb, etc. all available at websites bearing strong similarities to
their names. If you have problems installing or configuring one of
them, please ask on a newsgroup related to windoze or to webservers.
When you have it all set up and you experience difficulties with the
Perl syntax, come on back here.
Good luck.
--
Jeff
------------------------------
Date: 18 Dec 1999 16:06:57 -0600
From: abigail@delanet.com (Abigail)
Subject: Re: Confussed and lost - Could use a little guidance!
Message-Id: <slrn85o1qs.6so.abigail@alexandra.delanet.com>
Karen's Kitchen Table (kitchen.table@avoncliffe.com) wrote on MMCCC
September MCMXCIII in <URL:news:385ba4b5_2@einstien.netscapeonline.co.uk>:
//
// I'm confused and lost in this land of PERL and could do with a
// little help, or have I simply missed a basic point?
It's spelled Perl (the language) or perl (the binary). PERL is the
token used for a company (unrelated to Perl) on the stock exchange.
// I've even been down to my local computer shop this morning and
// purchased a book on PERL and CGI for the WWW but although it
// looks a good book all the examples are written to run of the
// server.
Well, yes. CGI is an interface between the server and your program,
so obviously, it assumes you have a server.
// Any help or pointers in the right general direction would be
// welcome so that I can achieve my goal.
Did you read the manual for CGI.pm? Do you use CGI.pm? If you do, and
if you understand CGI encoding, you can test your programs without the
use of a server. Else, install a server on your local machine.
Abigail
--
split // => '"';
${"@_"} = "/"; split // => eval join "+" => 1 .. 7;
*{"@_"} = sub {foreach (sort keys %_) {print "$_ $_{$_} "}};
%{"@_"} = %_ = (Just => another => Perl => Hacker); &{%{%_}};
-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
------------------------------
Date: Sun, 19 Dec 1999 01:30:41 GMT
From: Aaron D. <aarond@ieighty.net>
Subject: Re: Confussed and lost - Could use a little guidance!
Message-Id: <83hcg2$bbb$1@nnrp1.deja.com>
If you're running in Windows 9x, then the simplest solution IMHO would
be Windows Personal Web Server. It comes with the Windows CD and is
relatively easy to set up. It is NOT as powerful as, say, Apache (or
any other server actually) but for testing scripts it works quite
well. If I remember correctly, both PWS and Active Perl both have
instructions on how to make them work with eachother. Good luck!
In article <385ba4b5_2@einstien.netscapeonline.co.uk>,
"Karen's Kitchen Table" <kitchen.table@avoncliffe.com> wrote:
> Hi
>
> I'm confused and lost in this land of PERL and could do with a
> little help, or have I simply missed a basic point?
>
> I will apologise in advance if this is the wrong newsgroup.
>
> What I would like to achieve is to be able to test my PERL
> scripts locally on my Win98 PC without having to upload them to
> my webserver and then debug them online running up the phone
> bill.
>
> I've downloaded and installed the ActivePerl stuff from
> http://www.activestate.com/ and it seems to work Ok with a simple
> "Hello World" type PERL programme run from the command line.
>
> But I can't get it to work if I call the .PL script via my
> browser.
>
> Perl is installed to C:\Program Files\PERL\ and the top line of
> my PERL script has #!/progra~1/perl/bin
>
> I've even been down to my local computer shop this morning and
> purchased a book on PERL and CGI for the WWW but although it
> looks a good book all the examples are written to run of the
> server.
>
> Any help or pointers in the right general direction would be
> welcome so that I can achieve my goal.
> Is ActivePerl the right stuff or doing I keen something else.
>
> Thanks in advance
>
> Geoff
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
------------------------------
Date: Wed, 15 Dec 1999 19:18:19 GMT
From: Dominic Prakash <dominic01@hotmail.com>
Subject: Connect to Informnix Database through Perl
Message-Id: <838phe$etc$1@nnrp1.deja.com>
Group,
I would like to access Informix database from Perl. I have DBI already
installed in our Perl environment. When I tried to install
DBD::Informix 0.60, I got the error "No executable ESQL/C compiler
<..>/bin/esql". I know this is clearly specified in the DBI::Informix
README file.
I am very much new to Informix and how do I know some package is
installed or not. We are using Informix 7.24. Is that ESQL/C a
different product that is not used in Informix. When I searched the
whole directory I found only one file "bin/esqlvers". The README says,
"You must have a version of Informix ESQL/C or Informix
ClientSDK available to you. .. If you have Informix ODBC
drivers available to you, consider using DBD::ODBC instead."
Where can I locate/get ClientSDK or ODBC drivers? Is there any compiled
version of DBD::Informix available fot AIX 4.x OS.
Thanks a lot for your time.
Dominic
Sent via Deja.com http://www.deja.com/
Before you buy.
------------------------------
Date: Wed, 15 Dec 1999 15:00:49 -0500
From: "Art S. Kagel" <kagel@bloomberg.net>
To: Dominic Prakash <dominic01@hotmail.com>
Subject: Re: Connect to Informnix Database through Perl
Message-Id: <3857F371.CF7CC7B5@bloomberg.net>
If the file $INFORMIXDIR/bin/esql exists then you have ESQL/C if not you do
not have it. You can get the SDK free via download from IntraWare through
the Informix WEB Site. You have to be a registered IntraWare user but
registration is online and free. You just have to wait for the email with
your password to be returned.
Art S. Kagel
Dominic Prakash wrote:
>
> Group,
>
> I would like to access Informix database from Perl. I have DBI already
> installed in our Perl environment. When I tried to install
> DBD::Informix 0.60, I got the error "No executable ESQL/C compiler
> <..>/bin/esql". I know this is clearly specified in the DBI::Informix
> README file.
>
> I am very much new to Informix and how do I know some package is
> installed or not. We are using Informix 7.24. Is that ESQL/C a
> different product that is not used in Informix. When I searched the
> whole directory I found only one file "bin/esqlvers". The README says,
>
> "You must have a version of Informix ESQL/C or Informix
> ClientSDK available to you. .. If you have Informix ODBC
> drivers available to you, consider using DBD::ODBC instead."
>
> Where can I locate/get ClientSDK or ODBC drivers? Is there any compiled
> version of DBD::Informix available fot AIX 4.x OS.
>
> Thanks a lot for your time.
>
> Dominic
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
------------------------------
Date: 15 Dec 1999 17:37:54 -0600
From: abigail@delanet.com (Abigail)
Subject: Re: Converting a string to lowercase
Message-Id: <slrn85ga1i.4e7.abigail@alexandra.delanet.com>
Jehsom (jehsom@-NOSPAM-resnet.gatech.edu) wrote on MMCCXCVII September
MCMXCIII in <URL:news:837dd1$3fh$1@news-int.gatech.edu>:
** I'm looking at a string representing a filename. I want to make sure
** the extension is all lowercase, so I tried:
**
** s/\.([a-zA-Z0-9]{3})$/\.\l$1/g
**
** but that turned TESTING.MP3 into TESTING.mP3, whereas I wanted it to
** be TESTING.mp3.
**
** What did I do wrong?
Look on the same page, and the same table you found \l.
Abigail
--
perl -e '* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
/ / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / /
% % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % %;
BEGIN {% % = ($ _ = " " => print "Just Another Perl Hacker\n")}'
-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
------------------------------
Date: Thu, 16 Dec 1999 16:45:03 GMT
From: "Bob Bridges" <bbridges@seark.net>
Subject: Re: Converting a string to lowercase
Message-Id: <01bf47e4$550e9d80$6d2cd6cc@bbridges.seark.net>
I'm destined to be a newbie at this all my life, but maybe this will help:
$variable =~ tr/A-Z/a-z/;
Converts the letter in the left sequence to the corresponding one in the
right.
Abigail <abigail@delanet.com> wrote in article
<slrn85ga1i.4e7.abigail@alexandra.delanet.com>...
> Jehsom (jehsom@-NOSPAM-resnet.gatech.edu) wrote on MMCCXCVII September
> MCMXCIII in <URL:news:837dd1$3fh$1@news-int.gatech.edu>:
> ** I'm looking at a string representing a filename. I want to make sure
> ** the extension is all lowercase, so I tried:
> **
> ** s/\.([a-zA-Z0-9]{3})$/\.\l$1/g
> **
> ** but that turned TESTING.MP3 into TESTING.mP3, whereas I wanted it to
> ** be TESTING.mp3.
> **
> ** What did I do wrong?
>
>
> Look on the same page, and the same table you found \l.
>
>
>
> Abigail
> --
> perl -e '* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
*
> / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / /
/
> % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % %;
> BEGIN {% % = ($ _ = " " => print "Just Another Perl Hacker\n")}'
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the
World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==-----
>
------------------------------
Date: Thu, 16 Dec 1999 15:59:06 -0800
From: David Cassell <cassell@mail.cor.epa.gov>
Subject: Re: Converting a string to lowercase
Message-Id: <38597CCA.D7C18279@mail.cor.epa.gov>
[earlier posts snipped because Bob posted jeopardy-style, instead
of putting his answer *after* the quoted text]
Bob Bridges wrote:
>
> I'm destined to be a newbie at this all my life, but maybe this will help:
>
> $variable =~ tr/A-Z/a-z/;
>
> Converts the letter in the left sequence to the corresponding one in the
> right.
Bob, thanks for trying to help. But the questioner needed to
lower-case only part of his string.
Oh, and by the way, tr/// isn't as good as using the uc() and
ucfirst() functions, because tr/// doesn't understand locales.
David
--
David Cassell, OAO cassell@mail.cor.epa.gov
Senior computing specialist
mathematical statistician
------------------------------
Date: 16 Dec 1999 22:29:00 GMT
From: Jeff Zucker <jeff@vpservices.com>
Subject: Cookie Arrays (Was Re: CGI Question Basic Question - Kindof)
Message-Id: <38596749.A5A72408@vpservices.com>
[posted and mailed]
desertedge@my-deja.com wrote:
>
> I asked a question about taking the %20 out of a string, with an
> example like: $data =~ s/\%20/ /g;
> and I get the reply, "You should just use CGI." I'm not sure what to
> do when I'm advised to do that?????
I think the %20 stuff was a red herring, it distracted you and us from
your question. Here's my understanding of how CGI.pm deals with this:
when you use CGI.pm to *store* a cookie as a string that has spaces in
it, CGI.pm automatically escapes it, replacing the spaces with %20; when
you use CGI.pm to *retrieve* a string, it automatically un-escapes it
and returns the string with any %20s reconverted back to spaces. This
means you don't ever have to do anything with %20s: you don't have to
put them in when you create the cookie and you don't have to take them
out when you read the cookie, both are done by CGI.pm. These also
applies to the & and = symbols that CGI.pm uses when it creates cookies
from hashes or arrays -- CGI.pm puts them in and takes them out for you,
you don't need to deal with them by hand.
> My over all goal, is retrieving a cookie > Identifying it > Splitting
> the array from it's value > Then, of course, using the data in a
> readable form.
Ok, it seems that the part you are missing is how to send and retrieve
an array rather than a string. Basically, you create an array (@x), you
create the cookie's value as an array reference (\@x), then you retrieve
the cookie's value as an array and cycle through the array to print it.
Here's a sample:
-- start script --
#!perl -w
use strict;
use CGI qw(:standard);
my $cookie_name = 'test_cookie';
my $cookie_time = '+1h';
my @array = ('apples','bannans','oranges');
my $array_cookie = cookie( # CREATE NEW COOKIE
-name => $cookie_name,
-value => \@array, # CONTAINING AN ARRAY
-expires => $cookie_time,
);
print header(-cookie=>$array_cookie); # SEND COOKIE
if(my @cookie_array = cookie($cookie_name)){ # TEST FOR COOKIE
foreach my $array_member(@cookie_array){ # CYCLE THROUGH ARRAY
print "$array_member<br>"; # PRINTING EACH MEMBER
}
}
--- end script ---
--
Jeff
------------------------------
Date: Fri, 17 Dec 1999 15:11:38 GMT
From: desertedge@my-deja.com
Subject: Re: Cookie Arrays (Was Re: CGI Question Basic Question - Kindof)
Message-Id: <83djr5$r4v$1@nnrp1.deja.com>
In article <38596749.A5A72408@vpservices.com>,
Jeff Zucker <jeff@vpservices.com> wrote:
> [posted and mailed]
>
> desertedge@my-deja.com wrote:
> >
> > I asked a question about taking the %20 out of a string, with an
> > example like: $data =~ s/\%20/ /g;
> > and I get the reply, "You should just use CGI." I'm not sure what
to
> > do when I'm advised to do that?????
>
> I think the %20 stuff was a red herring, it distracted you and us from
> your question. Here's my understanding of how CGI.pm deals with
this:
> when you use CGI.pm to *store* a cookie as a string that has spaces in
> it, CGI.pm automatically escapes it, replacing the spaces with %20;
when
> you use CGI.pm to *retrieve* a string, it automatically un-escapes it
> and returns the string with any %20s reconverted back to spaces. This
> means you don't ever have to do anything with %20s: you don't have to
> put them in when you create the cookie and you don't have to take them
> out when you read the cookie, both are done by CGI.pm. These also
> applies to the & and = symbols that CGI.pm uses when it creates
cookies
> from hashes or arrays -- CGI.pm puts them in and takes them out for
you,
> you don't need to deal with them by hand.
>
> > My over all goal, is retrieving a cookie > Identifying it >
Splitting
> > the array from it's value > Then, of course, using the data in a
> > readable form.
>
> Ok, it seems that the part you are missing is how to send and retrieve
> an array rather than a string. Basically, you create an array (@x),
you
> create the cookie's value as an array reference (\@x), then you
retrieve
> the cookie's value as an array and cycle through the array to print
it.
> Here's a sample:
>
> -- start script --
> #!perl -w
> use strict;
> use CGI qw(:standard);
>
> my $cookie_name = 'test_cookie';
> my $cookie_time = '+1h';
> my @array = ('apples','bannans','oranges');
>
> my $array_cookie = cookie( # CREATE NEW COOKIE
> -name => $cookie_name,
> -value => \@array, # CONTAINING AN ARRAY
> -expires => $cookie_time,
> );
> print header(-cookie=>$array_cookie); # SEND COOKIE
> if(my @cookie_array = cookie($cookie_name)){ # TEST FOR COOKIE
> foreach my $array_member(@cookie_array){ # CYCLE THROUGH ARRAY
> print "$array_member<br>"; # PRINTING EACH MEMBER
> }
> }
> --- end script ---
>
> --
> Jeff
>
GOTCHA! THANKS..
Sent via Deja.com http://www.deja.com/
Before you buy.
------------------------------
Date: Fri, 17 Dec 1999 08:20:59 +0100
From: Andy Longworth <andy_longworth@bigfoot.com>
Subject: CPAN DBI
Message-Id: <3859E45B.A6FEBEA6@bigfoot.com>
I have a database running on Oracle 8.0.5..... and some perl scripts
that I wish to use to connect to the database.
The format for the query is
$sth = $dbh->prepare ('SELECT * from people WHERE lastname = ?') or
......
and to execute
$sth->execute($lastname) or ............
This is okay if I want one variable in the statement. How do I do this
for two or more, for example if I wanted to select a certain column as
well.
$sth = $dbh->prepare ('SELECT ? from people WHERE lastname = ?') or ...
Is this correct and how do I do the execute statement?
--
Andrew Longworth
Andrew_Longworth@hp.com
------------------------------
Date: 17 Dec 1999 15:21:43 GMT
From: Erik van Roode <newsposter@cthulhu.demon.nl>
Subject: Re: CPAN DBI
Message-Id: <83dke7$h6m$1@internal-news.uu.net>
Andy Longworth <andy_longworth@bigfoot.com> wrote:
> $sth = $dbh->prepare ('SELECT ? from people WHERE lastname = ?') or ...
> Is this correct and how do I do the execute statement?
Did you try it? Did it work? What results did you get and why are
they not what you expected? See DBI documentation for more
information on placeholders and bind values.
- If you have multiple placeholders, you call 'execute' with as many
values as you have placeholders.
- If you use placeholders for column names, you won't get the contents
of the column, but the string that you specified in the placeholder.
Wrong Example:
my $sth = $dbh->prepare ("
SELECT ?, ?
FROM $db_schema.Corporate_Customer");
$sth->execute ('customer_name', 'customer_id') || print $dbh->errstr;
while(my @result = $sth->fetchrow) {
# every row will contain 'customer_name', 'customer_id',
# and not the data I tried to retrieve from the database
}
Correct example:
my $columns = "customer_name,customer_id";
my $sth = $dbh->prepare ("
SELECT $columns
FROM $db_schema.Corporate_Customer");
$sth->execute || print $dbh->errstr;
You can use placeholders for 'where col2 = ?' situations.
Erik
------------------------------
Date: 17 Dec 1999 18:11:36 GMT
From: Jeff Zucker <jeff@vpservices.com>
Subject: Re: CPAN DBI
Message-Id: <385A7C7B.F87B578@vpservices.com>
Andy Longworth wrote:
>
> $sth = $dbh->prepare ('SELECT * from people WHERE lastname = ?') or
> ......
> $sth->execute($lastname) or ............
>
> This is okay if I want one variable in the statement. How do I do this
> for two or more,
Put in as many question marks as want for placeholders for values in the
WHERE clause, just make sure that the number of values in the execute or
bind_params matches that:
my $sth = $dbh->prepare("SELECT * FROM $table WHERE name = ? AND city =
?");
$sth->execute($name,$city);
> for example if I wanted to select a certain column as
> well.
No can do. It is clearly stated in the DBI documentation that you can
not use placeholders for the names of columns or tables.
--
Jeff
------------------------------
Date: Fri, 17 Dec 1999 03:07:14 -0500
From: "Yutung L." <yutliu@indiana.edu>
Subject: CPU load time for a message board
Message-Id: <83cr2a$a6b$1@flotsam.uits.indiana.edu>
Hi,
How is 0.05 seconds of CUP load time for a message board?
Is it too long?
P.S. The message board script creates the index page with the page splitting
links on the fly. 10 topics are displayed. The latest message or the message
has the latest reply will go to the top of the list. There are about 260
messages in the database(Not including the replies).
--
Yours Sincerely,
Yutung L.
------------------------------
Date: 17 Dec 1999 03:56:00 -0600
From: abigail@delanet.com (Abigail)
Subject: Re: CPU load time for a message board
Message-Id: <slrn85k2kf.66n.abigail@alexandra.delanet.com>
Yutung L. (yutliu@indiana.edu) wrote on MMCCXCIX September MCMXCIII in
<URL:news:83cr2a$a6b$1@flotsam.uits.indiana.edu>:
--
-- How is 0.05 seconds of CUP load time for a message board?
-- Is it too long?
That depends how patient you are.
Now, what has this to do with Perl?
Abigail
--
P.S. do you have a 32x speed CUP holder?
-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
------------------------------
Date: Fri, 17 Dec 1999 12:22:26 -0500
From: "Yutung L." <yutliu@indiana.edu>
Subject: Re: CPU load time for a message board
Message-Id: <83drhp$27o$1@jetsam.uits.indiana.edu>
Just want to make sure it is not using up too many system resources.
The board is at
http://www.cgi-factory.com/cgi-bin/message/view.pl?board=cgi
The cpu time is located at the button of that page.
--
Yours Sincerely,
Yutung L.
Abigail <abigail@delanet.com> wrote in message
news:slrn85k2kf.66n.abigail@alexandra.delanet.com...
> Yutung L. (yutliu@indiana.edu) wrote on MMCCXCIX September MCMXCIII in
> <URL:news:83cr2a$a6b$1@flotsam.uits.indiana.edu>:
> --
> -- How is 0.05 seconds of CUP load time for a message board?
> -- Is it too long?
>
>
> That depends how patient you are.
>
> Now, what has this to do with Perl?
>
>
>
> Abigail
> --
> P.S. do you have a 32x speed CUP holder?
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==-----
------------------------------
Date: 17 Dec 1999 12:45:18 -0600
From: abigail@delanet.com (Abigail)
Subject: Re: CPU load time for a message board
Message-Id: <slrn85l1kr.6so.abigail@alexandra.delanet.com>
Yutung L. (yutliu@indiana.edu) wrote on MMCCXCIX September MCMXCIII in
<URL:news:83drhp$27o$1@jetsam.uits.indiana.edu>:
__ Just want to make sure it is not using up too many system resources.
__
__ The board is at
__ http://www.cgi-factory.com/cgi-bin/message/view.pl?board=cgi
Well, of course it's taking too many system resources! CPU cycles are
better spend at things like RC5-64, or SETI. Usenet is fastly superior
to any CGI based message board.
And don't post Jeopardy style, not even stripping the signatures.
Abigail
--
package Just_another_Perl_Hacker; sub print {($_=$_[0])=~ s/_/ /g;
print } sub __PACKAGE__ { &
print ( __PACKAGE__)} &
__PACKAGE__
( )
-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
------------------------------
Date: Fri, 17 Dec 1999 15:23:40 -0500
From: "Yutung L." <yutliu@indiana.edu>
Subject: Re: CPU load time for a message board
Message-Id: <83e65k$35v$1@jetsam.uits.indiana.edu>
How about compare to other web based message boards. Is it taking too much
resources?
--
Yours Sincerely,
Yutung L.
Abigail <abigail@delanet.com> wrote in message
news:slrn85l1kr.6so.abigail@alexandra.delanet.com...
> Yutung L. (yutliu@indiana.edu) wrote on MMCCXCIX September MCMXCIII in
> <URL:news:83drhp$27o$1@jetsam.uits.indiana.edu>:
> __ Just want to make sure it is not using up too many system resources.
> __
> __ The board is at
> __ http://www.cgi-factory.com/cgi-bin/message/view.pl?board=cgi
>
> Well, of course it's taking too many system resources! CPU cycles are
> better spend at things like RC5-64, or SETI. Usenet is fastly superior
> to any CGI based message board.
>
>
> And don't post Jeopardy style, not even stripping the signatures.
>
>
> Abigail
> --
> package Just_another_Perl_Hacker; sub print {($_=$_[0])=~ s/_/ /g;
> print } sub __PACKAGE__ { &
> print ( __PACKAGE__)} &
> __PACKAGE__
> ( )
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==-----
------------------------------
Date: 17 Dec 1999 14:55:03 -0600
From: abigail@delanet.com (Abigail)
Subject: Re: CPU load time for a message board
Message-Id: <slrn85l985.6so.abigail@alexandra.delanet.com>
Yutung L. (yutliu@indiana.edu) wrote on MMCCXCIX September MCMXCIII in
<URL:news:83e65k$35v$1@jetsam.uits.indiana.edu>:
"" How about compare to other web based message boards. Is it taking too much
"" resources?
Posting off-topic Jeopardy style messages again, and still thinking to
get a useful answer?
Shoo.
Abigail
--
srand 123456;$-=rand$_--=>@[[$-,$_]=@[[$_,$-]for(reverse+1..(@[=split
//=>"IGrACVGQ\x02GJCWVhP\x02PL\x02jNMP"));print+(map{$_^q^"^}@[),"\n"
-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
------------------------------
Date: Fri, 17 Dec 1999 21:59:41 -0700
From: "Kevin M. Sproule" <kmsproule@worldnet.att.net>
Subject: Re: CPU load time for a message board
Message-Id: <83f41t$fav$1@bgtnsc03.worldnet.att.net>
Yutung L. wrote in message <83cr2a$a6b$1@flotsam.uits.indiana.edu>...
>Hi,
>How is 0.05 seconds of CUP load time for a message board?
>Is it too long?
>SNIP
With ~0.05 seconds of CPU per load, that would give you ~20 loads per
second. If that is ok then the execution time of your page script
(hopefully written in perl) is also ok. It all kind of depends what you are
looking for. Processors are cheap these days so you can always add more if
needed.
Digitally yours,
Kevin Sproule
PS. What do you think those seemingly meaningless Roman numerals and month
represent in Abigail's messages? MMCCXCIX September MCMXCIII = 2299
September 1993
------------------------------
Date: 18 Dec 1999 00:08:43 -0600
From: abigail@delanet.com (Abigail)
Subject: Re: CPU load time for a message board
Message-Id: <slrn85m9m8.6so.abigail@alexandra.delanet.com>
Kevin M. Sproule (kmsproule@worldnet.att.net) wrote on MMCCC September
MCMXCIII in <URL:news:83f41t$fav$1@bgtnsc03.worldnet.att.net>:
==
==
== PS. What do you think those seemingly meaningless Roman numerals and month
== represent in Abigail's messages? MMCCXCIX September MCMXCIII = 2299
== September 1993
Hmmm, let me guess. Could it mean the 2299th day of the month of September
in the year 1993? Or would that be too obvious, and it really has to do
with an obscure cult worshipping the squirrel gods?
Or perhaps Roman numerals just look pretty.
Abigail
--
perl -we '$@="\145\143\150\157\040\042\112\165\163\164\040\141\156\157\164".
"\150\145\162\040\120\145\162\154\040\110\141\143\153\145\162".
"\042\040\076\040\057\144\145\166\057\164\164\171";`$@`'
-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
------------------------------
Date: 16 Sep 99 21:33:47 GMT (Last modified)
From: Perl-Users-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin)
Subject: Digest Administrivia (Last modified: 16 Sep 99)
Message-Id: <null>
Administrivia:
The Perl-Users Digest is a retransmission of the USENET newsgroup
comp.lang.perl.misc. For subscription or unsubscription requests, send
the single line:
subscribe perl-users
or:
unsubscribe perl-users
to almanac@ruby.oce.orst.edu.
| NOTE: The mail to news gateway, and thus the ability to submit articles
| through this service to the newsgroup, has been removed. I do not have
| time to individually vet each article to make sure that someone isn't
| abusing the service, and I no longer have any desire to waste my time
| dealing with the campus admins when some fool complains to them about an
| article that has come through the gateway instead of complaining
| to the source.
To submit articles to comp.lang.perl.announce, send your article to
clpa@perl.com.
To request back copies (available for a week or so), send your request
to almanac@ruby.oce.orst.edu with the command "send perl-users x.y",
where x is the volume number and y is the issue number.
For other requests pertaining to the digest, send mail to
perl-users-request@ruby.oce.orst.edu. Do not waste your time or mine
sending perl questions to the -request address, I don't have time to
answer them even if I did know the answer.
------------------------------
End of Perl-Users Digest V9 Issue 1670
**************************************
