Click here to get back home

using DBIx::Class with native SQL query??

 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
using DBIx::Class with native SQL query?? easy 04-20-2006
Get Chitika Premium
Posted by easy on April 20, 2006, 5:19 am
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Posted by John on April 21, 2006, 5:31 am
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Posted by Robert Sedlacek on April 21, 2006, 8:44 am
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Similar ThreadsPosted
Tricky subclassing problem: Parent class method uses static value from child class September 26, 2006, 4:45 am
Native Cut&Paste on Win* and Mac? March 2, 2006, 8:22 pm
Re: DBIx::XML::DataLoader April 24, 2008, 3:25 am
Native language versions June 22, 2006, 7:03 am
DBD::pg suitable version for DBIx::Textindex 0.25 March 12, 2006, 11:20 pm
DBIx::Simple, authentication fails June 27, 2007, 9:40 am
DBIx::Simple, fails with no error (not CGI this time!) June 28, 2007, 10:15 am
DBIx::Simple variable interpolation problem July 6, 2007, 6:29 am
[newbie]How to call stored procedure using DBIx? December 28, 2007, 8:19 am
CGI - How to use upload_hook and query the query string ? February 7, 2006, 1:00 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap