Basic UltraDev

CD Content:

The Mac tutorial was left off of the CD of the first printing due to technical difficulties. It can be downloaded here.

Bettergig Access Database: The database included on the CD has some of the autonumber fields incorrectly set up as number columns. There is a corrected database that you can download here.

AcmeDatabases Database: The database included on the CD has some of the autonumber fields incorrectly set up as number columns. There is a corrected database that you can download here.

Chapter 10 contains a file named Home.cfm. The comment tag around the following line is improperly closed and will cause the page to not work:

By simply changing the ending comment tag to a valid ColdFusion comment like this, with 3 dash characters:

--->

will allow the page to be used.

Printed Content:

Page 423: 1st paragraph after ColdFusion heading, line 4. SMPT should be SMTP.

Page 425: 1st paragraph after the Note, line 6. SA-SMPTMail should be SA-SMTPMail.

Page 486: Figure 18-4 should be setting the redirect to page as login_user instead of welcome_new_user.

Page 550: Table 19-3. Run-Time value for the rqResID variable in CF is set as ResID#. This should be #ResID#

Page 765: Step 1: the code should be changed to the following:

<%
boolean RememberMe = true;
String strUsername="";
String strPassword="";
Cookie[] cookies = request.getCookies();
for (int i=0; i<cookies.length; i++) {
Cookie thisCookie = cookies[i];
if(thisCookie.getName().equals("ckRemember") &&
(thisCookie.getValue()==null)) {
RememberMe = false;
}
if(thisCookie.getName().equals("ckUsername")) {
strUsername = thisCookie.getValue();
}
if(thisCookie.getName().equals("ckPassword")) {
strPassword = thisCookie.getValue();
break;
}
}
if (RememberMe != true) {
strUsername="";
strPassword="";
}
%>

Page 551: Under the JavaScript version heading, the following line:

<%if(Session("svEmpID")!="") {%>

should be changed to

<%if(String(Session("svEmpID"))!="undefined") {%>

Page 809: The SQL is listed for a SQL Server database. I mentioned in the book that it may be different for a different RDBMS. The following query should work in MS Access:

SELECT OrderDetails.ProductID, Products.ProductName,
Products.DownloadLink, Products.DownloadCount
FROM ((Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID)
INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID)
INNER JOIN Products ON OrderDetails.ProductID =
Products.ProductID
WHERE (((Products.DownloadLink)<>"") AND
((Customers.CustomerID)=TM_userid))

The readme file for the SQL Server version of the Bettergig database wasn't included in the Database Stuff folder, but can be found in the Chapter 16 folder. The directions for running the SQL script are as follows:

--------------------------------------------
--Create the SQL Server Database
--------------------------------------------

Creating the MS SQL Server Sample Database

1 Open up the Microsoft SQL Server Query Analyzer (in SQL Server 7.0 and SQL Server 2000)
2 Open the createBettergigSQL.sql file in the Query Analyzer
3 Run the script

Chapter 20 had numerous references to the function getDocumentDom() which should have read:

dw.getDocumentDOM()

Chapter 24 had a small piece of code for deleting a line item from the cart for ColdFusion users. The code should have read (change in red):

<input type="checkbox" name="chkRemove" value="checkbox"
onClick="document.form1.txtQuantity<cfif #ArrayLen(Session.UCCart1[1])# gt 1><cfoutput>[#Evaluate(UCCart1__i-1)#]</cfoutput></cfif>.value=0,submit()">

Chapter 19 uses the Show Region server behavior that will show a message to the user on the search page if there are no matches. Considering that you may not want to show the message the first time the page is hit, you can use this conditional logic in place of the Show Region behavior that was specified in the chapter:

ASPVB:

<% If rsGetAGig.EOF And rsGetAGig.BOF And Request("search").count > 0 Then %>

ASP JS:

<% if(rsGetAGig.EOF && rsGetAGig.BOF && Request("search").count > 0 { %>