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.

November 22, 2004 in Code Issues | Permalink | Comments (0) | TrackBack (0)

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

November 16, 2004 in Code Issues | Permalink | Comments (0) | TrackBack (0)

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.

October 20, 2004 in Code Issues | Permalink | Comments (0) | TrackBack (1)

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

October 13, 2004 in Code Issues | Permalink | Comments (0) | TrackBack (0)

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?

October 06, 2004 in Code Issues | Permalink | Comments (0) | TrackBack (0)

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.

September 09, 2004 in Code Issues | Permalink | Comments (0)

Test Post

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

September 09, 2004 in Class Issues, Code Issues, Information Business, Project Issues | Permalink | Comments (3)

About

Recent Posts

  • Closing the Semester
  • Double Edged Sword for Sheridan
  • Ctools and IFS
  • How Cool are We?
  • XML's growing pains- ADTmag.com
  • Gray-haired Inboxes
  • Two Questions Regarding Final Project
  • coffee-addelement_literal.xsl
  • Blogonaut: RissRoss: The Dream Team
  • Kornstein999: Project 2 will be fun
Subscribe to this blog's feed
Blog powered by Typepad

Categories

  • Class Issues (12)
  • Code Issues (7)
  • Information Business (5)
  • Project Issues (4)
See More