Click here to get back home

DBI::ADO problem... execute() doesn't return valid rows from MSSQL
 Home | NewsGroups | Search | About
Login Password
Register Now! Lost Password?
 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
DBI::ADO problem... execute() doesn't return valid rows from MSSQL doug 06-06-2005
Get Chitika Premium
Posted by doug on June 6, 2005, 10:51 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 Julia De Silva on June 7, 2005, 10:27 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
WIN32::OLE MSSQL return value December 1, 2008, 5:16 pm
CGI::upload() fails to return valid handle January 9, 2005, 8:12 pm
Looking for best solution - FastCGI, ODBC, FreeTDS, MSSQL September 6, 2005, 2:37 pm
Beginner's list/return/glob problem December 23, 2004, 11:40 am
manupulating string having two rows June 7, 2006, 5:13 am
hashing mutliple rows from sql results? May 15, 2005, 5:57 am
any easy way to print a few tables in the same rows? March 22, 2007, 2:08 am
removing rows based on two duplicate fileds September 12, 2007, 7:31 pm
Merge multiple rows and remove duplicates --based on the first value January 26, 2006, 5:47 pm
did not produce a valid header June 20, 2005, 12:32 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap