Click here to get back home

DBD-ODBC - Running stored procs, can't bind default values.

 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
DBD-ODBC - Running stored procs, can't bind default values. Pablo S 10-15-2004
Get Chitika Premium
Posted by Pablo S on October 15, 2004, 7:55 pm
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 Rhesa Rozendaal on October 16, 2004, 7:26 pm
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
Neat way of setting default values June 1, 2005, 7:44 pm
How to call PL/SQL procs using Oraperl ? December 8, 2004, 12:32 pm
setting of session values from a script for the same session in which it is running May 23, 2005, 12:35 am
Using DBI, Bind with Update August 10, 2007, 5:58 am
wildcard the port in bind January 18, 2005, 3:27 am
Using Bind Params in MySQL April 21, 2005, 6:29 am
bind only "normal" keys in Tk December 20, 2005, 4:05 pm
Bind 9 administration module(s) February 14, 2007, 12:09 am
Oracle DBI/DBD and bind vars - so slooooowwwww August 25, 2004, 9:40 am
Syntax error? What syntax error? Assignment fo default values? November 18, 2007, 11:36 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap