The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Printed |
Page xiv
Resources, Boutell FAQ |
Deleted ", with some specifics on integration with Perl and DBI."
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page xiii
first link under "Resources" |
http://www.symbolstone.org/technology/perl/DBI
NOW READS:
dbi.perl.org
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page xvi
last paragraph |
"reviewers to gave us" NOW READS "reviewers that gave us"
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page v
8th bullet |
DBD::MySql
NOW READS:
DBD::mSQL.
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 13
code |
### Remove the newline that acts as a record delimiter chop;
NOW READS:
### Remove the newline that acts as a records delimiter chomp;
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 16
3rd uncommented code line |
Changed
unless @ARGV == 5;
to
unless @ARGV == 6;
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 19
last line on page, ch02/updatemegadata/updatemegadatafixed code example |
The last line on page 19 now reads:
next unless unpack( "A64", $_ ) eq $siteName;
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 20
The line |
substr( $_, 64+64, 16, pack( "A16", $siteMapRef ) );
now reads
substr($_, 64+64, 16) = pack( "A16", $siteMapRef ) );
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 20
The line |
substr( $_, 64+64, 16, pack( "A16", $siteMapRef ) );
NOW READS:
substr($_, 64+64, 16) = pack( "A16", $siteMapRef );
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 36
code section "### Insert some data rows" |
$database{'Callanish I'} =
"This site, commonly known as the "Stonehenge of the North" is in
the form of a buckled celtic cross.";
The inner quotes HAVE BEEN CHANGED to two separate opening single quote characters and
then two separate closing single quote characters, rather than as double quotes, as previously published.
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 57
4th paragraph (under Date datatypes, Chapter 3, Datatypes and NULL values |
In the second paragraph of the subheading "Date datatypes", the last sentence is missing the initial upper case "D" in the word "datatypes".
|
Anonymous |
|
|
| Printed |
Page 61
2nd paragraph, last 2 lines |
Changed
which would return the C<name> and C<location> fields
for the "Avebury" and "Stonehenge" rows.
to
which would return the C<name> and C<location> fields
for the "Stonehenge" row, but reject the "Avebury" row.
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 64
Changed second code example to |
SELECT name, description, location, url, content_type
FROM megaliths, media
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 65
Changed first code example to |
SELECT name, description, url, content_type
FROM megaliths, media
WHERE megaliths.id = megaliths_id
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 66
Changed second code example to |
SELECT mega.name, mega.description, med.url, med.content_type
FROM megaliths mega, media med
WHERE mega.id = med.megaliths_id
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 70
1st paragraph |
On the third line, the word "and"previously appeared twice. This HAS BEEN CORRECTED.
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 72
"IN =" now reads "IN". |
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 73
2nd Paragraph, last words |
Eliminated double space between "go" and "wrong"
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 75
last paragraph |
On the second line from the bottom, it did read CREATETABLE; it now reads
CREATE TABLE. One space in between.
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 82
2nd-to-last paragraph, last sentence |
In the text:
Because DBI dies if it can't load an initialize a driver, this method
should be called inside an eval{} block if you need to catch that error.
"eval {}" REMAINS in constant width font, but "block" NOW APPEARS in normal body font.
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 84
table |
order of arguments for an mSQL connect is written as :
dbi:mSQL:hostname:database:port_number,
NOW READS:
dbi:mSQL:database:hostname:port_number.
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 94
Near the top of the code example |
In this statement:
$dbh = DBI->connect(...)
"%attr" now reads "\%attr".
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 113
example following 3rd paragraph |
print "Megalithic site $arrayref->[0] is a $array_ref->[1]
";
NOW READS:
print "Megalithic site $array_ref->[0] is a $array_ref->[1]
";
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 115
near the bottom |
"...it's a little slower then we'd like..."
"then" now reads "than".
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 115
"uppercase" now reads "lowercase" in the comment (###) line. |
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 117
line 2 |
The Perl code line:
$rows = $sth->dump_results( 80, '
', ';', *FILE );
NOW READS:
$rows = $sth->dump_results( 80, "
", ';', *FILE );
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 119
6th paragraph, "The second and subsequent itterations..." |
"itterations"
NOW READS:
"iterations"
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 123
last paragraph |
"four different SQL"
NOW READS:
"three different SQL".
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 129
last line |
"foreach $item" now reads "foreach $name."
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 130
above 3rd paragraph: |
"foreach $item" now reads "foreach $name".
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 131
second paragraph under "Batch Fetching" |
The last sentence of the paragraph ("They are invoked...statement handle")
HAS BEEN REMOVED.
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 131
2nd paragraph, 6th line |
"type"
NOW READS:
"mapref".
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 133
10th line, "for the rows name and location..." |
"rows"
NOW READS:
"columns".
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 165
2nd-to-last SELECT statement |
In the "outer" CONCAT, a comma HAS BEEN ADDED between its two arguments.
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 166
Table |
The following table list is supposed to show which are supported by Win32::ODBC and DBI modules. Right sides of table are blank.
|
Anonymous |
|
|
| Printed |
Page 167
fourth non-indented paragraph |
In the text "and search for SQLGetInfo returns", the entire word "returns"
NOW APPEARS in constant width font.
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 170
footnote |
NOW READS: "They are available from..." because there are two
[portable Open Source driver managers].
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 178
Figure 8-1 |
"RPC::pClient" now reads "RPC::PlClient"
"RPC::pServer" now reads "RPC::PlServer"
"DBD::ProxyServer" now reads "DBI::ProxyServer"
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 179
Setting up a proxy server |
...since PPM currently does not currently support bundles...
NOW READS:
...since PPM does not currently support bundles...
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 195
7th line from the bottom |
"bind_column" NOW READS "bind_columns".
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 209
In the selectcol_arrayref section |
"selectall_arrayref will return..."
now reads
"selectcol_arrayref will return..."
|
Anonymous |
|
Mar 01, 2000 |
| Printed |
Page 213
last paragraph of "table (NEW)" |
"Note that table_info might not return records for all
tables."
"table_info" NOW READS "tables".
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 228
NUM_OF_PARAMS (integer, read-only) |
There is no "Substitution Variables" to refer to anywhere in this book.
|
Anonymous |
|
|
| Printed |
Page 230
3rd paragraph, last sentence |
It's use is not recommended.
NOW READS:
Its use is not recommended.
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 233
did read |
A German translation of this text and other Perl module documentation (all
probably slightly out-of-date) is available, thanks to O'Reilly, at:
http://www.oreilly.de/catalog/perlmodger
now reads:
A German translation of this text is available, thanks to O'Reilly, at:
http://www.oreilly.de/catalog/9781565926998ger/
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 281
FLOAT(M,D) |
Allowable values are -3.402823466e+38 to -1.175494351e-38,
0 and -1.175494351e-38 to 3.40282346 6e+38.
NOW READS:
Allowable values are -3.402823466e+38 to -1.175494351e-38,
0 and 1.175494351e-38 to 3.402823466e+38.
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 298
4th paragraph from the bottom |
" The NUMBER datatype stores positive and negative fixed
and floating-point numbers with magnitudes between 1.0
* 10-130 and 9.9...9 * 10125 (38 nines followed by 88
zeroes), with 38 digits of precision."
In "1.0 * 10-130", "-130" HAS BEEN SUPERSCRIPTED.
In "9.9...9 * 10125", "125" HAS BEEN SUPERSCRIPTED.
|
Anonymous |
|
Apr 01, 2005 |
| Printed |
Page 304
"Stored Procedures" |
The first code example:
$sth = $dbh->prepare("BEGIN foo(:1, :2) END;");
now reads:
$sth = $dbh->prepare("BEGIN foo(:1, :2); END;");
Similarly, the second code example:
$sth = $dbh->prepare("BEGIN :result = func_name(:id, :changeme) END;");
now reads:
$sth = $dbh->prepare("BEGIN :result = func_name(:id, :changeme); END;");
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 310
string matching operators table |
The last example, for the glyph '!~*':
'thomas' !~ '.*vadim.*'
NOW READS:
'thomas' !~* '.*vadim.*'
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page 316
7th paragraph |
"SearchServer does not really supports joins, however it does support a kind of view mechanism."
"supports" NOW READS "support"
|
Anonymous |
|
Apr 01, 2005 |
