Click here to get back home

Perl DBI Module: SQL query where there is space in field name

 HomeNewsGroups | Search | About
 comp.lang.perl.misc    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Perl DBI Module: SQL query where there is space in field name ambarish.mitra 05-08-2008
Get Chitika Premium
Posted by Sir Robin on May 12, 2008, 2:32 am
Please log in for more thread options

>A. Sinan Unur wrote:
>
>> Nope. Post plain text in text only groups.
>
>Right. But let me pose this; In the 1980's and even in the 90's, this
>was the way things were done, and a lot of it was for technical reasons,
>right? Do those reasons still really exist? Bandwidth is cheap, screen
>resolutions large, ram plentiful, HD sizes growing like there's no
>tomorrow, so why use old tech to as a reason to prevent moving forward
>in a medium such as UseNet ? Any modern news reader should be able to
>easily handle multipart messages and at least basic HTML without
>breaking a sweat, so why stifle innovation in the name of preserving old
>20+ year old paradigms?

In most scenarios (the largest beeing the majority of all usenet messages
written in US-ASCII or with extended ASCII characterset on many
non-international newsgroups) HTML provides no benefits whatsoever and annoys
people. This alone clearly leads to conclusion that using this great
"innovation" that posting HTML copy of same text already coming in plaintext
is in regular usenet messages simply and plainly bad behaviour. Now why would
you insist on behaving badly?

>Is anyone still using an 80x25/50 column terminal?

Sometimes... Sometimes also using SSH client to remotely use my home computer
or some other remote server - very handy, very smooth even if having to use a
slow connection.

>What real systems out
>there don't have a GUI, I mean come on people, time to come out of the
>past already.

Need for a GUI depends on what purpose the particular system is set up for -
and GUI or not GUI is not even the issue here... a console newsreader could be
programmed to format HTML or open the HTML part with starting console mode web
browser (Links would be the best one of those I know of and use). But that was
never anyones point here or was it?

>I'm not saying we should all post in HTML, I prefer plain
>myself, but we should not be so afraid of posts that contain
>HTML/multiparts.

I think you have mistaken people beeing afraid here with people beeing annoyed
here. I dont think anyone is afraid of HTML usenet garbage.

--
***/--- Sir Robin (aka Jani Saksa) Bi-Sex and proud of it! ---\***
**/ email: robsku@fiveam.NO-SPAM.org, <*> Reg. Linux user #290577 \**
*| Me, Drugs, DooM, Photos, Writings... http://soul.fiveam.org/robsku |*
**\--- GSM/SMS: +358 44 927 3992 ---/**
"Jokainen linkki, jonka päätteenä on ".org", on kelvoton tiedonlähde."
- Nikolas Mäki

Posted by Martijn Lievaart on May 10, 2008, 8:10 pm
Please log in for more thread options
On Sat, 10 May 2008 09:43:15 -0700, szr wrote:

>> Any serious newsreader does not do mime-multipart.
>
> This would seem to be the opposite from what I've seen. All the major
> graphical ones (at least for Windows) to handle it, and they all allow
> you to specify which format should take precedence. I have that set to
> "plain", so I don't actually see the HTML part of a multipart posting
> :-)

I haven't "done" Windows for ages, but I used to use Xnews, which
definately did not do mime-multipart. I'ld be very surprised if anything
besides Outlook and possibly Mozilla and friends do mime-multipart.

M4

Posted by Peter J. Holzer on May 11, 2008, 9:34 am
Please log in for more thread options
> On Sat, 10 May 2008 09:43:15 -0700, szr wrote:
>>> Any serious newsreader does not do mime-multipart.
>>
>> This would seem to be the opposite from what I've seen. All the major
>> graphical ones (at least for Windows) to handle it, and they all allow
>> you to specify which format should take precedence. I have that set to
>> "plain", so I don't actually see the HTML part of a multipart posting
>> :-)
>
> I haven't "done" Windows for ages, but I used to use Xnews, which
> definately did not do mime-multipart. I'ld be very surprised if anything
> besides Outlook and possibly Mozilla and friends do mime-multipart.

On Linux, Mozilla and KNode have decent multipart support. Pan has
partial support. I'm quite sure that GNUS has good multipart support,
but since I don't like Emacs, I've never tried it. There is a patch for
slrn, but since nobody I consider worth reading is posting multipart
messages, I haven't tried that, either. I don't know about the other
text-based readers (tin, trn, ...).

        hp

Posted by Martijn Lievaart on May 11, 2008, 4:45 pm
Please log in for more thread options
On Sun, 11 May 2008 15:24:03 +0200, Peter J. Holzer wrote:

>>
>> Well, there is this slight problem of standards, encoded into RFCs. You
>> don't /have/ to follow them, but it's in general a good idea.
>
> The relevant RFC in this case would be RFC 2046. As fas as I can see
> Andrew did follow the RFC.

I beg to differ.

>
>> HTML in usenet postings is definitely not standard and in fact, any
>> serious newsreader (on any platform, even on Windows) does not render
>> it. Even worse, mime-multipart, although a standard for mail, is not a
>> standard for usenet.
>
> You are mixing up technical standards and social standards. RFC 1036

No, I'm trying not to, although I agree that the technical standards are
less than clear and the social standards important as well.

> refers to RFC 822 for the article format which has later been extended
> by the series of MIME RFCs (starting with RFC 1341 in 1992). Now one
> could argue that since 1341 came after 1036 and 1036 was never revised,
> 1341 is irrelevant - only plain text US-ASCII is allowed in usenet
> messages. However, that is clearly not practical - Usenet is used for

This is correct.

> discussions in many languages, most of which cannot be expressed
> adequately in US-ASCII. Even if the discussion language is English, the
> topic of the discussion (for example, how to process Chinese text in a
> Perl program) may require another character set. And there is absolutely
> no RFC or other authoritative document which says that MIME Content-Type
> is ok for Usenet and MIME multipart is not. Technically, you have to
> accept MIME as a whole or not at all.

This is also correct. Technically speaking, only ASCII is allowed on
Usenet by the RFCs.

That this is completely impractical, yes, I agree wholeheartedly. The
RFCs need updating, badly, which I also said in the post you are replying
to.

The current state of affairs is that most usenet readers either use
Latin-1 (or Windows1252), or pay attention to the Content-type header.
And many do this badly btw. (I would have to search for the details, I
know Pan hasn't let me down yet, but I frequently encounter other
newsreaders that make a mess. On further research it's always the other
newsreader that is at fault. Stuff like setting a correct Content-type
header for ISO-Latin-1, but forgetting to translate the message you're
replying to from utf-8).

>
> However, there is a strong *convention* that Usenet messages (outside of
> the binary groups) should contain only plain text. No images, no fancy
> markup, no sound files, no video. That's a social convention, not a
> technical one. Of course, newsreader authors often only implement
> features for which they see a need - so if nobody posts multipart
> messages, why should they implement support for them? (the newsreader
> you use - Pan - seems to be quite curious in supporting multipart/mixed,
> but not multipart/alternative).

Ah thanks for the correction. I don't do binaries anymore on usenet, so I
didn't know that.

M4

Posted by Peter J. Holzer on May 15, 2008, 5:49 pm
Please log in for more thread options
> szr wrote:
>> Sir Robin wrote:
>>> On Sat, 10 May 2008 12:23:46 -0700, Andrew DeFaria
>>>
>> [...]
>>> And there is no reason whatsoever why a newsreader should need to be
>>> able to handle HTML
>>
>> What reason is there not to, to be honest?
>
> Ooh, here's a few off the top of my head ...
>
> a) There's no single thing called HTML.
> HTML 3.2?
> HTML 3.2 with IE5 quirks?
> ...
> HTML 4.0?
> XHTML?
> CSS1?
> CSS2?
> HTML 5?

Given that HTML 4 is now over 10 years old and HTML 5 doesn't yet exist,
I don't think there's a real question about that. The level of CSS
support is more of an issue. But it's basically the same problem as in
the web - you need to produce code which can be interpreted by your
audience's software. So be conservative in what you send and liberal in
what you accept.


> b) At the moment, presence of HTML is a useful indication of SPAM.

On usenet? Not really. (Or maybe all the HTML usenet spam is filtered
before it reaches my server)


> c) Widespread adoption of (some variants of) HTML might end with many
> posts omitting any plain-text alternative parts. This might balkanise
> newsgroups.

True.


> d) Why not some other XML application like, oh, DocBook. Or maybe some
> new NewsGroup-article DTD?

None of them has any support in existing MUAs and NUAs. Several attempts
to define "richtext" content-types especially for mail/news have failed.
HTML otoh is widely used for email (as ugly as it may be for that
purpose).


> e) Why not RTF, PDF or ODF?

See d) and g)


> f) What if I want to read newsgroups on my phone or PDA using a
> low-speed Internet link - maybe bandwidth would be an issue for
> image-rich HTML or other formats.

Maybe. OTOH, there is little reason to assume that the average usenet
posting would be "image-rich". You could score down "large" postings and
only read them if they seem to be especially interesting.

And speaking of "phones or PDAs": These devices usually have a small
screen. HTML can be reformatted to fit on that screen. plain/text cannot
- it needs 80 characters horizontally (unless it's format=flowed, which
isn' too common, either).


> g) All too often I receive a word .DOC that contains just a 1 page
> meeting agenda in two fonts (title & body) - It just makes an extra slow
> step to fire up Word to view an attachment when the content would lose
> nothing from being presented as plain text. Why encourage unecessary
> complexity.

Right. So that's why you don't want RTF, PDF or ODF. These are too
complex to be embedded into a newsreader and starting a viewer takes a
lot of time. HTML is reasonably simple, there are a lot of engines which
can be embedded into applications, and even if you invoke an external
app that's relatively quick (I use w3m to perform HTML->Text conversion
in mutt - for most HTML mails that takes only a fraction of a second on
a PC several years old).


> h) The same reason I don't meed a surround-sound video-telephone when
> phoning a fried for advice about Java.

I find a telephone a very frustrating device when I want to communicate
about technical matters.


> i) The same reasons colour newspapers never completely rerplaced black
> and white newspapers I suppose.
>
> j) The same reason Gutenberg's Bible is a superior example of
> information publishing.

Superior compared to what? Contemporary hand-written bibles?

> I'm sure that neither it's aesthetics

The hand-written bibles were usually more beautiful.

> nor it's information content

The information was the same (except for illustrations, I suppose).

Gutenberg's bible was *cheap*. That's what made it a superior example of
information publishing - a lot of people who would never have been able
to pay for a hand-written bible could buy a printed copy.

I don't think that argument has any relevance to this discussion.

> k) Do you need me to add multiple fonts, tables, bullet lists etc to the
> above to make it intelligible?

No. But then you didn't have to explain any complicated data structures
or clearly distinguish multiple data streams.

> l) I'd prefer plain text markup of the sort used by GrutaTxt or ASCIIDOC
> but simplified. That way I could embed tables that work well in
> plain-text newsreaders but would also look pretty in any newsreader that
> supported that format.

Those are nice. But they have one very large drawback: There are about
46 gazillion different such formats. That's much worse than the
differences in HTML and CSS dialects.

        hp


Similar ThreadsPosted
Re: Perl DBI Module: SQL query where there is space in field name June 12, 2008, 4:21 am
query regarding perl module installation in local directory July 28, 2007, 4:08 pm
Simplest way (or module) to tweak query in CGI server-side validation June 12, 2008, 9:10 pm
matching a pattern with a space or no space?? November 9, 2005, 7:45 am
SNMP module to query net-snmp August 31, 2006, 7:08 am
CGI - How to use upload_hook and query the query string ? February 7, 2006, 1:00 pm
how to check whether the field is filled or empty in perl TK November 14, 2007, 9:40 am
How to check a form's field and exit Perl program if it has a value? July 7, 2007, 2:08 pm
Simple (!) HTML/PERL code fpr uploading files through web pages entyr field ?? November 18, 2004, 11:12 pm
Perl Regex Query November 9, 2006, 11:14 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap