bskool bloggin

coffee-addelement_literal.xsl

In coffee-addelement_literal.xsl, in the bestwith tags the value-of select = taste, I beleive it should be equal to bestwith.

basic.p63-2.xsl

In Bud's file basic.p63-2.xsl you need to add a closing tag </xsl:template> after the line that says "The Template People." to get the stylesheet to run on miniscore.xml

Feeling like the critic

So all I blog about lately is questions from class excercises, but I promise I'll get back to more interesting items after the exam.

In Chapter 4 on excercise 3, is there a need to really use the part table in the query? Part number is listed in the order line table, and I'm not sure what benefit bringing part number in from the part table instead adds to the query.

The question was:

"For each order, list the order number, order date, part number, number of units ordered, and quoted price for each order line that makes up the order."

The code for the solution was:

select o.order_number, o.order_date, p.part_num, ol.num_ordered, ol.quoted_price
from orders o, part p, order_line ol
where o.order_number = ol.order_num
and ol.part_num = p.part_num;

I propose:

select o.order_num, o.order_date, ol.part_num, ol.num_ordered, ol.quoted_price
from orders o, order_line ol
where o.order_num = ol.order_num;

Note that in my tables I have order_num instead of order_number.

Value Vocab

In Chapter 3, excercise 16, the book asks for "part number, part descriptions, and on_hand_value (units on hand * unit price) for each part where the units on hand is more than the average number of units on hand for all parts. Professor Gibson's script is as follows:

select part_num, description, units_on_hand
from part
where units_on_hand >
(select avg(units_on_hand) from part);

I feel the script should be:

select part_num, description, on_hand*price "On-Hand Value" from part
where on_hand > (select avg(on_hand) from part);

The first script does not calculate on_hand_value, but shows the number of units on hand in its place. Just an fyi...

Cannot open file

In trying to do excercise 1 from Chapter 2 I keep getting the line SP2-0310: unable to open file "c2_figure221.sql" when I try to execute the file that inserts all of my data into my customer table. Does this mean there is an error in my lines of data or is there some other issue?

None yet...

Let's hope that this is the least active area of my blog. If it becomes active it will directly correlate to the 'frustrated' color on my mood ring.

Test Post

This is a test of my new web log 'bskool bloggin.'