Thanks Ronald. Peter Loo Wolters Kluwer Health (602) 381-9553 -----Original Message----- From: Ronald J Kimball [mailto:[EMAIL PROTECTED] Sent: Friday, April 14, 2006 6:51 AM To: Loo, Peter # PHX; dbi-users@perl.org Subject: RE: dump_results
Loo, Peter # PHX [mailto:[EMAIL PROTECTED]: > I am passing the correct arguments to dump_results, but it appears > that the records are not getting separated with new line. > > $maxlen = 500; > $lsep = '\n'; > $fsep = '|'; > $fh = \*FH; > > $rows = $sth->dump_results($maxlen, $lsep, $fsep, $fh); Single quoted strings do not do backslash substitution (except for \\ and \'). You meant $lsep = "\n"; > Also, how can I force it so that the output does not have the quotes > for every field? DBI::neat() won't quote the value if it knows it's a number. Unfortunately, I'm not sure how to let it know it's a number in this case. Sorry. Ronald This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message. This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.