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 RedGrittyBrick on May 16, 2008, 3:26 pm
Please log in for more thread options
Peter J. Holzer wrote:
>> szr wrote:
>>> Sir Robin wrote:
>>>> Andrew DeFaria wrote:
>>>>
>>>> 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?
>>>
>>
>> [...]

Some good points. You may have not read my list in quite the spirit I
wrote it, but I enjoyed reading your reply, thanks.

>>
>> 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.
>

I think you may have over-estimated the number!

Personally, I think the very large advantage (explained above) over HTML
outweighs any advantage HTML has for me in this medium. YMMV.

--
RGB

Posted by Peter J. Holzer on May 15, 2008, 5:52 pm
Please log in for more thread options
> RedGrittyBrick wrote:
>> szr wrote:
>>> Sir Robin wrote:
>>>> 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 ...
[...]
>> 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.
>
> Which is why it would need to be crucial to have plain text versions.
> Admittedly that would only really work if there were some way a reader
> could ask the /server/ for /just/ the plain version.

Doesn't work with NNTP. But would work with IMAP, and an NNTP extension
wouldn't be that hard if there is need.

        hp

Posted by Peter J. Holzer on May 15, 2008, 5:57 pm
Please log in for more thread options
> "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." - RGB
>
> "That would be nice, but wouldn't you have the same battle on your hands
> that those pushing html currently do?" - szr
[...]
> This posting is written in a form compatible with Grutatxt. In theory a
> newreader could render it with the headings in various fonts and sizes,
> with the bullet lists shown with proper bullet characters and with the
> tables displayed in some more pleasing form..

If it recognizes the page as Grutatxt. How would it do that? The
mime-confoming way would be to use format=grutatext similar to
format=flowed.

> Is there any anti-HTML-in-newsgroups reader out there who finds the
> formatting and markup of this posting really objectionable?

I find the quoting objectionable. It's difficult to see that the two
quotes are quotes from previous messages in the same thread.

        hp

Posted by RedGrittyBrick on May 16, 2008, 6:46 am
Please log in for more thread options
Peter J. Holzer wrote:
>> "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." - RGB
>>
>> "That would be nice, but wouldn't you have the same battle on your hands
>> that those pushing html currently do?" - szr
> [...]
>> This posting is written in a form compatible with Grutatxt. In theory a
>> newreader could render it with the headings in various fonts and sizes,
>> with the bullet lists shown with proper bullet characters and with the
>> tables displayed in some more pleasing form..
>
> If it recognizes the page as Grutatxt. How would it do that?

I don't know, maybe using a header 'Content-type = text/structured'?

Don't forget many (most?) newsreaders already recognise *asterisks*
/obliques/ and _underscores_ without requiring any special indicators.
Ditto for lines starting with ">". Is there any *technical* reason they
shouldn't look out for other markup too?


> The
> mime-confoming way would be to use format=grutatext similar to
> format=flowed.

OK.

>
>> Is there any anti-HTML-in-newsgroups reader out there who finds the
>> formatting and markup of this posting really objectionable?
>
> I find the quoting objectionable. It's difficult to see that the two
> quotes are quotes from previous messages in the same thread.
>

True. That would need addressing.

I did wonder if I should have done it thus:

Fred said:
"blah blah
blah blah"

Mary retorted:
"pardon?"

But I guess a usenet-structured text format would probably retain the
existing quoting conventions.

Rather than thinking of a formal format maybe it would be best to think
off somehow adding to the *asterisk* /oblique/ _underscore_ set of
loosely respected conventions.

It's not like I have some well thought out proposal here, this is just
thinking out aloud :-)

--
RGB

Posted by Peter J. Holzer on May 18, 2008, 12:30 pm
Please log in for more thread options
> Peter J. Holzer wrote:
>>> "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." - RGB
>>>
>>> "That would be nice, but wouldn't you have the same battle on your hands
>>> that those pushing html currently do?" - szr
>> [...]
>>> This posting is written in a form compatible with Grutatxt. In theory a
>>> newreader could render it with the headings in various fonts and sizes,
>>> with the bullet lists shown with proper bullet characters and with the
>>> tables displayed in some more pleasing form..
>>
>> If it recognizes the page as Grutatxt. How would it do that?
>
> I don't know, maybe using a header 'Content-type = text/structured'?

That would probably cause a problem with many newsreaders: They don't
know what text/structured is (that's a very bad name, btw - far too
unspecific) and how it should be displayed. Some may display it as
text/plain, but others will complain or resort to external filters.


> Don't forget many (most?) newsreaders already recognise *asterisks*
> /obliques/ and _underscores_ without requiring any special indicators.
> Ditto for lines starting with ">".

Most newsreaders take great care to render these in a way which doesn't
change the content (i.e., they may render anything between the asterisks
in bold, but they don't remove the asterisks). This is because they
cannot know that these characters are intended as markup - especially in
programming language newsgroups "strange characters" often carry
meaning. Still, even though they are quite conservative, and there is
only a very limited number of markup elements, it does happen that they
render something in a misleading manner.

> Is there any *technical* reason they shouldn't look out for other
> markup too?

Every additional markup element which is used only by convention and not
according to some specified format increases the risk that the reader
won't see what the author intended.

I have nothing against grutatext, asciidoc, etc. if they are properly
labeled. But if newsreaders A treats text/plain as grutatext and
newsreader B treats it as asciidoc, then I fear that the result won't be
pretty.


> It's not like I have some well thought out proposal here, this is just
> thinking out aloud :-)

Ditto.

        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