[29476] in Perl-Users-Digest

home help back first fref pref prev next nref lref last post

Perl-Users Digest, Issue: 720 Volume: 11

daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Sun Aug 5 03:09:44 2007

Date: Sun, 5 Aug 2007 00:09:06 -0700 (PDT)
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)

Perl-Users Digest           Sun, 5 Aug 2007     Volume: 11 Number: 720

Today's topics:
    Re: define an array in perl (aka ? the Platypus)
    Re: I am giving up perl because of assholes on clpm --  <cdalten@gmail.com>
    Re: I am giving up perl because of assholes on clpm --  <waveright@gmail.com>
        new CPAN modules on Sun Aug  5 2007 (Randal Schwartz)
        New release of Config::Model v 0.612 <dominique.dumont@hp.com>
        out put from system()  ecnalbya@gmail.com
    Re: out put from system() <admiralcap@gmail.com>
    Re: out put from system() <wahab-mail@gmx.de>
    Re: out put from system() <noreply@gunnar.cc>
    Re: Prototypes/Parameters to a Function/Sub-Routine <olson_ord@yahoo.it>
    Re: Q on localizing *STDOUT and fork <socyl@987jk.com.invalid>
    Re: The Modernization of Emacs: keyboard shortcuts pain <xah@xahlee.org>
    Re: Using DBI, better option than importing into @array xhoster@gmail.com
    Re: Windows based perl editor? <savagebeaste@yahoo.com>
    Re: Windows based perl editor? <savagebeaste@yahoo.com>
        Digest Administrivia (Last modified: 6 Apr 01) (Perl-Users-Digest Admin)

----------------------------------------------------------------------

Date: Sun, 05 Aug 2007 04:42:46 GMT
From: "David Formosa (aka ? the Platypus)" <dformosa@usyd.edu.au>
Subject: Re: define an array in perl
Message-Id: <slrnfbalpm.219.dformosa@localhost.localdomain>

On Wed, 01 Aug 2007 00:51:17 -0700, mattsteel <matteo_vitturi@virgilio.it> wrote:

[...]

> This is an eval task: instead of
>   my @"$list_name";
> I'd use
>   eval "my \@$list_name";

That will not work.  The scope of the my in that block is restricted
to within the eval.


------------------------------

Date: Sat, 04 Aug 2007 15:40:55 -0000
From:  grocery_stocker <cdalten@gmail.com>
Subject: Re: I am giving up perl because of assholes on clpm -- switching to Python
Message-Id: <1186242055.553090.112680@m37g2000prh.googlegroups.com>

On Jul 25, 12:45 pm, Martha_Jo...@tx.net wrote:
> Python is a better language, with php support, anyway, but I am fed up
> with attitudes of comp.lang.perl.misc. Assholes in this newsgroup ruin
> Perl experience for everyone. Instead of being helpful, snide remarks,
> back-biting, scare tactings, and so on proliferate and self
> reinforce. All honest people have left this sad newsgroup. Buy bye,
> assholes, I am not going to miss you!!!
>
> Martha

In the beginning there was Mathematics
And all was good
Then one day God said "Let there be the Lambda Calculus"
And hence the Lambda Calculus was born.
However, God felt the the Lambda Calculus needed a mate
So god said "Let there be Lisp"
And thus, Lisp was born.

As the years went on, god became depressed by how impure the Lisp had
become.
For from the Lisp, came Emacs Lisp, Java, Perl, Ruby, and Python.



------------------------------

Date: Sat, 04 Aug 2007 19:06:01 -0000
From:  Todd Wade <waveright@gmail.com>
Subject: Re: I am giving up perl because of assholes on clpm -- switching to Python
Message-Id: <1186254361.836938.264260@x35g2000prf.googlegroups.com>

On Jul 22, 2:20 am, Bruno Desthuilliers
<bdesth.quelquech...@free.quelquepart.fr> wrote:
> Martha_Jo...@tx.net a =E9crit :
>
> > Python is a better language, with php support,
>
> Python has php support ? My, I'm a professional web developper using
> both, and I didn't knew this.
>

As an aside, perl DOES support PHP:

http://search.cpan.org/~gschloss/PHP-Interpreter/

trwww



------------------------------

Date: Sun, 5 Aug 2007 04:42:15 GMT
From: merlyn@stonehenge.com (Randal Schwartz)
Subject: new CPAN modules on Sun Aug  5 2007
Message-Id: <JMAAEF.1BIu@zorch.sf-bay.org>

The following modules have recently been added to or updated in the
Comprehensive Perl Archive Network (CPAN).  You can install them using the
instructions in the 'perlmodinstall' page included with your Perl
distribution.

Acme-Aspartame-0.01
http://search.cpan.org/~sartak/Acme-Aspartame-0.01/
raise the alarum if a source filter was used 
----
Bundle-SafeBrowsing-1.00
http://search.cpan.org/~danborn/Bundle-SafeBrowsing-1.00/
SpamAssassin plugin that scores messages by looking up the URIs they contain in Google's SafeBrowsing tables. See <http://code.google.com/apis/safebrowsing/>. 
----
CPAN-Reporter-0.47_01
http://search.cpan.org/~dagolden/CPAN-Reporter-0.47_01/
Provides Test::Reporter support for CPAN.pm 
----
DBIx-MyParsePP-0.20
http://search.cpan.org/~philips/DBIx-MyParsePP-0.20/
Pure-perl SQL parser based on MySQL grammar and lexer 
----
File-DirSync-1.16
http://search.cpan.org/~bbb/File-DirSync-1.16/
Syncronize two directories rapidly 
----
Gtk2-1.146
http://search.cpan.org/~tsch/Gtk2-1.146/
Perl interface to the 2.x series of the Gimp Toolkit library 
----
HTML-Tested-0.26
http://search.cpan.org/~bosu/HTML-Tested-0.26/
Provides HTML widgets with the built-in means of testing. 
----
HTML-Tested-JavaScript-0.06
http://search.cpan.org/~bosu/HTML-Tested-JavaScript-0.06/
JavaScript enabled HTML::Tested widgets. 
----
HTML-TreeBuilder-Select-0.111
http://search.cpan.org/~rkrimen/HTML-TreeBuilder-Select-0.111/
Traverse a HTML tree using CSS selectors 
----
Lingua-Alphabet-Phonetic-NetHack-1.02
http://search.cpan.org/~mthurn/Lingua-Alphabet-Phonetic-NetHack-1.02/
map ASCII characters to names of NetHack items 
----
List-Member-0.042
http://search.cpan.org/~lgoddard/List-Member-0.042/
PROLOG's member/2: return index of $x in @y. 
----
Math-Currency-0.45
http://search.cpan.org/~jpeacock/Math-Currency-0.45/
Exact Currency Math with Formatting and Rounding 
----
NetHack-Logfile-0.01
http://search.cpan.org/~sartak/NetHack-Logfile-0.01/
reading and writing NetHack's logfiles 
----
Panotools-Script-0.07
http://search.cpan.org/~bpostle/Panotools-Script-0.07/
Panorama Tools scripting 
----
Path-Abstract-0.071
http://search.cpan.org/~rkrimen/Path-Abstract-0.071/
A fast and featureful class for UNIX-style path manipulation. 
----
Path-Resource-0.041
http://search.cpan.org/~rkrimen/Path-Resource-0.041/
URI/Path::Class combination. 
----
Sys-Statistics-Linux-0.15
http://search.cpan.org/~bloonix/Sys-Statistics-Linux-0.15/
Front-end module to collect system statistics 
----
Test-StubGenerator-0.9.0
http://search.cpan.org/~kcowgill/Test-StubGenerator-0.9.0/
A simple module that analyzes a given source file and automatically generates t/*.t style tests for subroutines/methods it encounters. 
----
Test-WWW-Mechanize-Catalyst-0.39
http://search.cpan.org/~lbrocard/Test-WWW-Mechanize-Catalyst-0.39/
Test::WWW::Mechanize for Catalyst 
----
Test-Without-Module-0.1
http://search.cpan.org/~corion/Test-Without-Module-0.1/
Test fallback behaviour in absence of modules 
----
Text-Soundex-3.03
http://search.cpan.org/~markm/Text-Soundex-3.03/
Implementation of the soundex algorithm. 
----
Text-XLogfile-0.02
http://search.cpan.org/~sartak/Text-XLogfile-0.02/
reading and writing xlogfiles 
----
Text-XLogfile-0.03
http://search.cpan.org/~sartak/Text-XLogfile-0.03/
reading and writing xlogfiles 
----
Tie-Scalar-Random-0.01
http://search.cpan.org/~sartak/Tie-Scalar-Random-0.01/
fetch a randomly selected assigned value 
----
WebService-StreetMapLink-0.2
http://search.cpan.org/~drolsky/WebService-StreetMapLink-0.2/
An API for generating links to online map services 
----
WebService-StreetMapLink-0.21
http://search.cpan.org/~drolsky/WebService-StreetMapLink-0.21/
An API for generating links to online map services 
----
XML-Generator-PerlData-0.91
http://search.cpan.org/~khampton/XML-Generator-PerlData-0.91/
Perl extension for generating SAX2 events from nested Perl data structures. 


If you're an author of one of these modules, please submit a detailed
announcement to comp.lang.perl.announce, and we'll pass it along.

This message was generated by a Perl program described in my Linux
Magazine column, which can be found on-line (along with more than
200 other freely available past column articles) at
  http://www.stonehenge.com/merlyn/LinuxMag/col82.html

print "Just another Perl hacker," # the original

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!


------------------------------

Date: Sat, 4 Aug 2007 15:43:05 GMT
From: Dominique Dumont <dominique.dumont@hp.com>
Subject: New release of Config::Model v 0.612
Message-Id: <JM9ABt.98L@zorch.sf-bay.org>


Hello

This new version of the Config::Model perl module provides:
- some bug fixes
- the possibility to preserve the order of the keys of a 
  hash element (ordered hash)
- configuration class inherit_after parameter
- dump and read configuration data as perl data structure 

This new release has been released today on CPAN and on sourceforge.

If you want more information you can read the wiki on sourceforge:

  http://config-model.wiki.sourceforge.net/

You can also subscribe to the mailing list:

  http://lists.sourceforge.net/mailman/listinfo/config-model-users

The readme and changelog for v0.612 are (or will soon be) available at
these URLs:
  http://search.cpan.org/dist/Config-Model/README
  http://search.cpan.org/dist/Config-Model/ChangeLog

Cheers

-- 
Dominique Dumont 
"Delivering successful solutions requires giving people what they
need, not what they want." Kurt Bittner




------------------------------

Date: Sat, 04 Aug 2007 12:27:09 -0700
From:  ecnalbya@gmail.com
Subject: out put from system()
Message-Id: <1186255629.106338.86260@57g2000hsv.googlegroups.com>

Are there any ways to get system output from Perl? I want to get out
put from system() and print it out in Perl. For example,


#! /use/bin/perl
$output = system ("echo hello world");
print $output;



------------------------------

Date: Sat, 04 Aug 2007 13:11:20 -0700
From: Matt Madrid <admiralcap@gmail.com>
Subject: Re: out put from system()
Message-Id: <7cidneG98ez0QCnbnZ2dnUVZ_tijnZ2d@comcast.com>

ecnalbya@gmail.com wrote:
> Are there any ways to get system output from Perl? I want to get out
> put from system() and print it out in Perl. For example,
> 
> 
> #! /use/bin/perl
> $output = system ("echo hello world");
> print $output;
> 

perldoc -f system

This is not what you want to use to capture the output from a command, for
that you should use merely backticks or "qx//", as described in "`STRING`" in perlop.


------------------------------

Date: Sat, 04 Aug 2007 22:06:41 +0200
From: Mirco Wahab <wahab-mail@gmx.de>
Subject: Re: out put from system()
Message-Id: <f92mkc$mki$1@mlucom4.urz.uni-halle.de>

ecnalbya@gmail.com wrote:
> Are there any ways to get system output from Perl? I want to get out
> put from system() and print it out in Perl. For example,
> 
> 
> #! /use/bin/perl
> $output = system ("echo hello world");
> print $output;


either use back ticks `echo "hello world!"`
or the qx operator ...

  # without any interpolation of variables or expressions
  ...
  $output = qx'echo "hello world!"';
  print $output;
  ...

  # interpolation of variables or expressions
  ...
  $text = "hello world!";
  $output = qx{echo $text};
  print $output; 	
  ...

see http://perldoc.perl.org/perlop.html#%60STRING%60

Regards

M.


------------------------------

Date: Sat, 04 Aug 2007 22:14:06 +0200
From: Gunnar Hjalmarsson <noreply@gunnar.cc>
Subject: Re: out put from system()
Message-Id: <5hk570F3l1r5uU1@mid.individual.net>

ecnalbya@gmail.com wrote:
> Are there any ways to get system output from Perl? I want to get out
> put from system() and print it out in Perl. For example,
> 
> #! /use/bin/perl
> $output = system ("echo hello world");
> print $output;

You asked a FAQ.

     perldoc -q output.+system

Btw, did you consider to read the docs for the function you thought you 
want to use?

     perldoc -f system

-- 
Gunnar Hjalmarsson
Email: http://www.gunnar.cc/cgi-bin/contact.pl


------------------------------

Date: Sat, 04 Aug 2007 12:19:07 -0700
From:  "O. Olson" <olson_ord@yahoo.it>
Subject: Re: Prototypes/Parameters to a Function/Sub-Routine
Message-Id: <1186255147.945899.3190@b79g2000hse.googlegroups.com>

Dear Anno,

Thank you for your explanations - I think this is what I wanted. If
the have any more doubts, I would post them to another thread as they
would be unrelated to this topic.

Thanks again,
O.O.



------------------------------

Date: Sat, 4 Aug 2007 15:23:57 +0000 (UTC)
From: kj <socyl@987jk.com.invalid>
Subject: Re: Q on localizing *STDOUT and fork
Message-Id: <f925md$eg$1@reader2.panix.com>

In <1186223134.723592.105510@d55g2000hsg.googlegroups.com> Brian McCauley <nobull67@gmail.com> writes:

>On Aug 3, 8:02 pm, Brian McCauley <nobul...@gmail.com> wrote:

>On the other hand simply abstracting the code from my previous post
>into a subroutine is not too hard:

>use AtExit;
>sub save_fd {
>    my $std = shift;
>    open ( my $saved,'>&', $std) or die $!;
>    my $mode = shift;
>    open $std, $mode, @_ and new AtExit sub {
>	# Actually the or die is of dubious utility here
>	open ($std,'>&', $saved) or die $!;
>    };
>}

Thanks once more.  AtExit is a handy module to know.

kj

-- 
NOTE: In my address everything before the first period is backwards;
and the last period, and everything after it, should be discarded.


------------------------------

Date: Sat, 04 Aug 2007 18:27:24 -0700
From:  Xah Lee <xah@xahlee.org>
Subject: Re: The Modernization of Emacs: keyboard shortcuts pain
Message-Id: <1186277244.045554.308420@i13g2000prf.googlegroups.com>

The following article a extended version of previous post.
A HTML version can be found at
http://xahlee.org/emacs/emacs_kb_shortcuts_pain.html

-----------------------------------
WHY EMACS'S KEYBOARD SHORTCUTS ARE PAINFUL

Xah Lee, 2007-07

A important aspect in designing a keyboard shortcut set, for a
application that has intensive, repetitive, prolonged human-machine
interaction (such as coding and text editing), is to consider
ergonomic principles. Specifically: allocate keyboard shortcuts for
the most frequently used commands, and, the top most frequently used
commands should have most easily-pressed keystrokes. For example, they
should be on the home row.

This article shows why Emacs's keyboard shortcut set are the most
ergonomically unsound.

THE SWAPPING OF CONTROL AND META MODIFIERS

Emacs's keyboard shortcuts is very inefficient. The primary cause is
because, emacs's keyboard shortcuts are designed with a keyboard that
practically has the Ctrl and Alt key positions swapped.
Space Cadet keyboard

above: The Space-cadet keyboard (Source=E2=86=97, 2007-07) .

The common keyboard used around emacs era in the 1980s are those
keyboards from Lisp Machines=E2=86=97. (see Space-cadet keyboard=E2=86=97) =
The
keyboard on lisp machines have the Control key right besides the space
bar (similar to the position of Alt keys on PC keyboards), and Meta to
the left of Control. So, the Control key is right under the thumb, and
the Meta is secondary to Control. This is why, the shortcuts for the
most used commands in emacs involve the Control key instead of the
Meta key. (e.g. The cursor movements: C-p, C-n, C-f, C-b, C-a, C-e,
the cut/paste/undo C-w, C-y, C-/, the kill-line C-k, the mark C-SPC,
the search C-s.) Lisp Machine's keyboards fell out of use alone with
Lisp Machines. Since the 1990s, the IBM PC keyboard=E2=86=97 (and its
decedents) becomes the most popular and is used by more than 99% of
personal computers today. The PC keyboard does not have Meta key but
have Alt instead, which is practically used as Meta for emacs. The
Ctrl and Alt key's position are essentially swapped from the Control
and Meta on the Lisp Machine's keyboards. Emacs however, did not
change its keyboard shortcut set by switching the commands that are
mapped to the Control and Meta keys. This makes emacs keyboard
shortcuts very painful, and the frequent need to press the far-away
Control key makes the Emacs Pinky syndrome. (Many emacs-using
programer celebrities have injured their hands with emacs. (e.g.
Richard Stallman=E2=86=97, Jamie Zawinski=E2=86=97), and emacs's Ctrl and M=
eta
combinations are most cited as the major turn-off to potential users
among programers)

THE CHOICE OF KEYS

The shortcut's key choices are primarily based on first letter of the
commands, not based on key position and finger strength or ease of
pressing the key. For example, the single char cursor moving shortcuts
(C-p previous-line =E2=86=91, C-n next-line =E2=86=93, C-b backward-char =
=E2=86=90, C-f
forward-char =E2=86=92) are scattered around the keyboard with positions th=
at
are most difficult to press. (these shortcuts all together accounts
for 43% of all commands executed by a keyboard shortcut) Of these, the
most frequently used is C-n (next-line), which accounts for 20% of all
shortcut calls, but is assigned to the letter n, positioned in the
middle of the keyboard, which is one of the most costy key to press.
Similarly, the second most used among these is the C-p (previous-
line), accounting for 16% of all shortcut command calls, is located in
a position above the rigth hand's pinky, also one of the most costy
key to press.

(Here we assumes the QWERTY keyboard layout. On the Dvorak layout, it
is about as bad.)

OUTDATED COMMANDS

A significant portion of emacs's major shortcuts (those with M-=C2=ABkey=C2=
=BB
or C-=C2=ABkey=C2=BB) are mapped to commands that are almost never used tod=
ay.
Some of these occupies the most precious space (Home row with Meta:
e=2Eg. M-s (center-line), M-j (indent-new-comment-line), M-k (kill-
sentence)). Most programer who have used emacs for years never use
these commands. For example:

digit-argument, M-1 to M-9
negative-argument, M--

move-to-window-line, M-r
center-line, M-s
transpose-words, M-t
tab-to-tab-stop, M-i

M-g prefix, M-g
indent-new-comment-line, M-j
tmm-menubar, M-'

zap-to-char, M-z
back-to-indentation, M-m
tags-loop-continue, M-,
find-tag, M-.

NO EMPLOYMENT OF THE SHIFT KEY

For historical reasons, emacs do not use any keybindings involving the
Shift with a letter. (e.g. there's no =E2=80=9Cmeta shift a=E2=80=9D, or =
=E2=80=9Ccontrol
shift a=E2=80=9D) This is so because in early computing environment, such k=
ey
combination cannot be distinguished, due to a practical combination of
ASCII=E2=86=97, Computer terminal=E2=86=97, telnet=E2=86=97.

Today, however, employing the Shift key as part of a shortcut with
other modifiers is common and convenient. For example, on Mac OS X,
Undo and Redo are Cmd+Z and Cmd+Shift+Z, Save and Save As are Cmd+S
and Cmd+Shift+S. On Mac and Windows, moving to next/previous field/
window/application often use the Shift key for reversing direction. In
text editing on both Mac and Windows, a modifier key with a arrow key
will move cursor by word/paragraph, and with Shift down will select
them while moving.

Using the Shift key as a reverse operation is very easy to remember,
and doesn't take another precious shortcut letter. By not using the
Shift key, commands with a logical reverse operation necessarily have
to find other key space, and overall making the shortcut set more
difficult to remember, or scattered, or more difficult to press.

A FLAW IN KEYBINDING POLICY

Any major software, maintains a guide for the developers about the
choices of keyboard shortcuts, so that the shortcuts will be
consistant. Emacs has this in its Emacs Lisp manual: Elisp Manual: Key-
Binding-Conventions.

This guide, indicates that the only key space reserved for users to
define, are the function keys F5 to F9, and key stroke sequence
starting with Ctrl+c followed by a single letter key.

This is a severe restraint to the utility of customized shortcuts. F5
to F9 are only 6 keys. The key sequence starting with C-c followed by
a letter, is a difficult sequence to execute, and there are only 26
spaces there.

The function keys, F1 to F12, are very good candidates for user
defined shortcut space, similarly for the digit key shortcuts, 0 to 9.
These series of key space can be multiplied by any combination of
modifiers of Control, Meta, Shift. For example, a user might define
the them to insert various templates, headers/footers, a system of
customized HTML/XML tags. Or, she might assign them to various special
emacs modes such as dired, shell, ftp, email, calendar, calc,
*scratch*, make-frame-command (Open a new window), insert signature.

It seems too drastic a policy, to limit user defined keys to only F5
to F9, and key sequence of Control+c followed by a single letter key.

EPILOGUE: FAILURE TO CHANGE

Today, most commonly used keyboard shortcuts have been somewhat
informally standardized. For example, C/X/V is for Copy/Cut/Paste. O
is for Open. S is for Save, Shift-S is for Save As. P is for Print. F
is for Find/Search. Tab is for next, Shift tab for previous. These are
common conventions today in every application across Microsoft Windows
and Macintosh (and most Linuxes).

These shortcuts conventions are primarily brought about by Apple
Computer Inc's Human interface guidelines=E2=86=97 and IBM's Common User
Access=E2=86=97 in the 1990s.

In the early 1990s, DOS era software, each application has its own
scheme of shortcuts. The following is a excerpt from the Wikipedia
article on Common User Access=E2=86=97:

CUA was a detailed specification and set strict rules about how
applications should look and function. Its aim was in part to bring
about harmony between MS-DOS applications, which until then had
implemented totally different user interfaces.

Examples:

    * In WordPerfect, the command to open a file was [F7], [3].
    * In Lotus 1-2-3, a file was opened with [/] (to open the menus),
[W] (for Workspace), [R] (for Retrieve).
    * In Microsoft Word, a file was opened with [Esc] (to open the
menus), [T] (for Transfer), [L] (for Load).
    * In WordStar, it was [Ctrl]+[K]+[O].
    * In Emacs, a file was opened with [Ctrl]+[x] followed by [Ctrl]+
[f] (for find-file).

Some programs used [Esc] to cancel an action, some used it to complete
one; WordPerfect used it to repeat a character. Some programs used
[End] to go to the end of a line, some used it to complete filling in
a form. [F1] was often help but in WordPerfect that was [F3]. [Ins]
sometimes toggled between overtype and inserting characters, but some
programs used it for =E2=80=9Cpaste=E2=80=9D.

Thus, every program had to be learned individually and its complete
user interface memorized. It was a sign of expertise to have learned
the UIs of dozens of applications, since a novice user facing a new
program would find their existing knowledge of a similar application
absolutely no use whatsoever.

Commercial software have updated themselves with time (or went
extinct), but emacs has not.

  Xah
  xah@xahlee.org
=E2=88=91 http://xahlee.org/



------------------------------

Date: 04 Aug 2007 20:11:29 GMT
From: xhoster@gmail.com
Subject: Re: Using DBI, better option than importing into @array
Message-Id: <20070804161131.866$pf@newsreader.com>

"Peter J. Holzer" <hjp-usenet2@hjp.at> wrote:
> On 2007-07-30 22:33, J. Gleixner <glex_no-spam@qwest-spam-no.invalid>
> wrote:
> > Jason wrote:
> >>   my $topiclist = $dbh->selectall_arrayref("SELECT `id`, `subject`,
> >> `postdate`, `username`, `email`, `comment` FROM $forum_posts WHERE
> >> id=" . $dbh->quote($id) . " ORDER BY postdate ASC");
> >
> > Look into placeholders and bind_columns
>
> I second that advice.
>
> > and you don't need any of those '`'.
>
> Nope. The backticks are to delimit identifiers. You cannot substitute
> identifiers with placeholders.

I think you are misinterpreting Jason's advice.
1) look into placeholders.
2) you don't need those backticks.

No causation implied between them.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB


------------------------------

Date: Sat, 4 Aug 2007 22:45:08 -0700
From: "Clenna Lumina" <savagebeaste@yahoo.com>
Subject: Re: Windows based perl editor?
Message-Id: <5hl6beF3k0b05U1@mid.individual.net>

~greg wrote:
> "Mr. Shawn H. Corey" > wrote ...
>>
>> I did not post three times; the internet did it for me.
>> ... Normally, there is a unique ID attached to each message but
>> sometimes this gets lost.
>
>
>
> The headers don't support the excuse.
>
> Each of the 3 posts has a different Message-ID
> (two of them having been assigned by "...@magma.ca",
> which corresponds to the From address,
> and the 3rd was assigned by "...@PRIMUS.CA",
> for some reason that I don't understand.)
>
> And they each have different X-Trace lines (whatever that is)
> and different Xref lines,
> (which happen to be in sequential order:
> ...635013, ...635014, ...635015)
>
> ~~
>
> But I'm not being anal. :)
>
>
> I have been trying to work out the best way
> to thread usenet posts for an archives.
>
> And "robustness" is a major objective.
>
> Lots of little problems have to be solved.
> For example, I assign a permanent index to
> every ID seen, whether in a Message-ID line
> or in a References line. And this index ~ message-id
> correspondence is the single most important aspect
> of the database. So it's vitally important that
> every post have a good Message-ID.
> Which presents the problem of what to do
> when an otherwise perfectly good post
> just happens to be missing a message-id.
>
> Which I have never actually seen an instance of.
>
> But don't laugh! I have actually seen something
> like it, once in my life.
> I have see one post that contained one ID
> in its References line that had one of its
> bits in one of its bytes obviously mangled
> during transmission! (Which was easy to see,
> -- after it was guessed that that was the problem,
> --by comparison with all the other posts
> in the same thread.)
>
> So I don't think that it is literally impossible that perfectly good
> post (vs a malevolent one) is missing a message-id.
> In any case that's the reason I was curious
> about the current stutter-post situation.
>
> (What my threader does if it ever comes across
> a true case of this kind of thing,
> is invent a message-id for the post,
> made up of the SHA-1 of the
> Subject line + Date line + body lines.
> The idea is that this should be sufficient to
> to distinguish two different ID-less posts,
> while identifying two copies of the same
> ID-less post that happen to come by different
> routes, and therefore have many different headers.
>
> (I don't use the From line in the SHA
> because Google mundges From lines.
> It is still possible to get the "original usenet format"
> from Google, but they don't make it easy to do,
> and it probably isn't possible to harvest them
> from Google by bot anymore).
>
>
> In this case the 3 Subjects are identical.
> And the SHA of the bodies are identical.
> But the dates are different.
>
> The 2nd one was sent about a minute after the 1st.
> And the 3rd, about 10 seconds after the 2nd.
>
> Which I can't say actually refutes the excuse given
> (because I don't actually understand the excuse given.)
>
> But I think that can safely be said
> that it doesn't confirm it. :)

Actually some smaller ISP's and UseNet providers don't have their own 
UseNet feeds and instead relay through someone else, and this extra step 
can sometimes create anomalies, such as when/if header rewriting occurs, 
or if bad retry and router setups are employed, rather than just getting 
a genuine feed.

-- 
CL 




------------------------------

Date: Sat, 4 Aug 2007 23:24:39 -0700
From: "Clenna Lumina" <savagebeaste@yahoo.com>
Subject: Re: Windows based perl editor?
Message-Id: <5hl8lkF3kh9tqU1@mid.individual.net>

l v wrote:
> Bill H wrote:
>> I have been using Edit (in a dos box) on Windows for editing perl for
>> the past 8 years or so, and though it is fine for me, I think it is
>> time to step up to a windows based editor. Can anyone recommend a
>> good windows based perl editor?
>>
>> My wish list for what the editor would be able to do is:
>>
>> 1. Allow me to run the program I am editting in a dos box (using
>> active state perl)
>> 2. Have multiple undos
>> 3. Create multiple back up files as I save changes (a form of version
>> control so I can step back to a previous "version" if what I did
>> doesnt work right).
>> 4. Syntax hilighting
>> 5. Multiple programs open at the same time
>> 6. Some form of project structure to allow me to group all the files
>> together
>>
>> Most of these "wishes" come from the MS Visual C++ editor I used to
>> use before discovering perl.
>>
>> Searching the internet I came across Perl Express (http://perl-
>> editor.perl-express.com/) but am leary of downloading programs I find
>> on the internet without knowing if they are safe.
>>
>> I am not sure if this would influence your recommendtions but the
>> majority (99%) of the perl I write is used on web servers.
>>
>> Any / all suggestions are appreciated.
>> Bill H
>>
>
> PerlBuilder from www.solutionsoft.com (not free) is a good lightweight
> perl IDE.  No need to define a project to edit a standalone single
> perl script.  Would love to have Komodo.
>
> A very nice fee editor is Notepad++.

I believe he meant "free" and not "fee", as they do not charge a fee to 
use it :)

-- 
CL 




------------------------------

Date: 6 Apr 2001 21:33:47 GMT (Last modified)
From: Perl-Users-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin) 
Subject: Digest Administrivia (Last modified: 6 Apr 01)
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: due to the current flood of worm email banging on ruby, the smtp
server on ruby has been shut off until further notice. 

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 V11 Issue 720
**************************************


home help back first fref pref prev next nref lref last post