Errata

Programming the Perl DBI

Errata for Programming the Perl DBI

Submit your own errata for this product.

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.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

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 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