BIT320 Remix: XML Archives

How To Integrate a Database with AJAX

AJAX with PHP and mySQL - a high-octane-solution

In del.icio.us/mridge, 12/20/2005 | Original | Archive

Year in Review: AJAX Desktops and Homepages

How AJAX is invading your desktop

In del.icio.us/mridge, 12/20/2005 | Original | Archive

» Structured blogging–what's in it for users?

Standardized blogging - not a good thing. Unlike other standardized things like RSS/XML

In del.icio.us/mridge, 12/20/2005 | Original | Archive

RSS Specifications and RSS Feeds

Information related to RSS and XML, including software, newsreaders, specifications, content syndication, and the history of rss.

In del.icio.us/supermatt, 12/19/2005 | Original | Archive

RSS - Team Goes for Bonus

Matt and I have been working on the RSS feed all night and we think we finally got it working! The feed is located at the following URL: http://elab-linux4.bus.umich.edu:8080/%7Ekevlers/RSS/testRSS.xsql (Bud - can you tell us if we’re all set with the feed)

The purpose of the feed is to notify customers of new store additions to the database. This is especially important to customers who do not have any stores in their immediate area. They can use the feed as a watch-list to see if any stores start carrying Denali Flavors. The xsql file pulls the information directly from the database, so it should be a valid feed, as opposed to just a well-formed document.

If any other teams are attempting to get the RSS feed working, I would recommend looking at this web site.

In Kevin's Blog, 12/19/2005 | Original | Archive | Post to del.icio.us | Technorati

xml.apache.org

Different open source tools, most of which use the Xerces implementation (DOM Level 1 & 2) as a base. Xerces itself is available in Java, C++, Perl, and COM

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

Perl XML FAQ 1.1

By Jonathan Eisenzopf. Information on using and manipulating XML with Perl.

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

webservices.xml.com

Web Services XML.com subsite. Development resources and solutions, features timely news, opinions, and tutorials, interactive forums, and newsletters.

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

InsightBuilder : XML document and web content management

Combines full featured content management with workflow control, easy use through GUI forms, flexibility to create new web site templates with XSL, multi-lingual support and management of PDF, Flash, Excel, XML and other document types.

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

Welcome to XMLSoftware

James Tauber maintains an excellent collection of available XML software products sorted by category. Very up-to-date and with useful descriptions

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

Database Software: embedded systems, database design, Embedded Database, xml database, database, real-time, embedded, Embedded, application development, XML Database, QNX, QNX, Embedded Linux, Windriver

Provides a native XML data structure with a rich set of features for database applications found in handheld devices, Internet appliances and embedded systems.

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

Internet Etc - Onsite internet training and consultancy. XML, HTML, Flash MX, Javascript, Perl, website promotion, Actionscript.

Internet Etc offers XML training in USA, UK, and Europe.

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

Processing XML with Java

Online draft of a book by Elliotte Rusty Harold.

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

Extensible Markup Language (XML) Activity Statement

An executive overview of W3C's current and historical work on the Extensible Markup Language (XML).

In del.icio.us/supermatt, 12/17/2005 | Original | Archive

Don’t write more in your blog than it takes to solve the issue

Matt observes:

HOWEVER, he went on to say:

Their problem description needed a little work, but their solution was spot on and well thought out.

This was a little disappointing to hear. Obviously, it is not a hard problem to solve, but the lessons that are behind it are important.

You guys are doing fine, just sharpen that objective. Your other points are good, but I really just meant for you to sharpen things a bit.

In Blogonautic Solutions, 12/14/2005 | Original | Archive | Post to del.icio.us | Technorati

Project Feedback - My thoughts

I was happy that many people complemented the effort and technical success that my group has achieved. Bud was kind enough to say:

All groups should aspire to the technical level that Kevin, Aga, Matt Ruprecht, and Supriya achieved.

HOWEVER, he went on to say:

Their problem description needed a little work, but their solution was spot on and well thought out.

This was a little disappointing to hear. Obviously, it is not a hard problem to solve, but the lessons that are behind it are important.

The first lesson is understand the level of comprehension of the problem on both sides of the table. For this project we are IT consultants, we are given a real business problem from a customer and we are expected to have the business and IT knowledge to solve. For any of us that are going into consulting, IT consulting, or any technical field it is important to understand more than just the problem. We need to understand how the other person understands the problem A funny example of this actually happened to me this week at Merrill Lynch. My boss at work has a dual display for his computer. He has very little understand of computers and so to keep things simple for himself he keeps Outlook open on his left monitor and Merrill software on the right monitor. When I was at work this week his Outlook (on his left monitor) froze. Since he has such a limited understand of computers, he thought there was a problem with his left monitor. Now of course this is such a simple example, but when things get technical these problem could easily exist.

The second problem is we need to understand how the person wants the problem solved. For example, we all assumed that Denali flavors would want to use html insert forms to enter data into their database (of course this assumption goes along with course materials and project requirements). The truth is that John never mentioned that he wanted us to use web form to input data. If he only wanted data to be added at the main office typing in ugly SQL language, we would have wasted our time, and not really solved the problem the way the client wanted.

The third problem is over doing it. Bud told about an experience he had in his professional career about how sometimes doing more doesn’t always help. As students we barely have enough time to do all of our required assignments let alone time to over do it. It is something to remember that extra work isn’t always worth it.

As much as doing extra work is a bad thing. I think there is value in explaining to customers the full potential of their database. For example, in my part of presentation, I made many demands for my database, and I bet that when our projects are done ALL of the groups well have solved the problems I “demands” I listed. One lesson that Bit301 taught is the value of information and databases, now in Bit320 I’m learning how to make them, I want to harness their full value. So while I will state the problem in the project that Denali wanted a well-formed normalized that database that would allow customers to search for and find their favorite flavors in their local stores. I will know and make a database that can do much more.

In SuperMatt, 12/13/2005 | Original | Archive | Post to del.icio.us | Technorati

Semantic Web Resource Center

XML's website, page focusing on the Semantic Web, the idea of making machine readable information to make the internet even more effective and open more possibilities

In del.icio.us/williamhmacy3, 12/12/2005 | Original | Archive

Frame Alternatives

As Bud already touched on, frames are generally looked down upon in the web design community. In fact, some go so far as to say that using frames is one of the top ten biggest mistakes in web design. A brief search on the term frames on Google revealed many web sites, such as this one, that discuss the downsides of using frames.

Many of you are probably wondering how to include a navigational structure on top of the XSLT pages if you can’t use frames.

One option is to include an inline frame. Inline frames are similar to frames pages except that the inline frame and its contents are embedded on an existing Web page, so you don’t need a separate frames page. Below is an example:

http://elab-linux4.bus.umich.edu:8080/~kevlers/XSQL5/VARIETY%20insert%20form/VARIETYInsertForm.html” title=”Variety Insert Form” scrolling=”no” border=”0″ frameborder=”0″><br />Your browser does not support inline frames or is currently configured not to display inline frames.<br />

Another way to include content is to use server side include. SSI
allows you add dynamically generate content into an existing HTML page, with
the following code <!–#include virtual="PageToIncludeHere.htm" –>

Another option is to simply include the navigational structure directly
in the XSLT pages. However, this becomes complicated when updating.

In Kevin's Blog, 12/11/2005 | Original | Archive | Post to del.icio.us | Technorati

rest/ahah - Microformats

AHAH is a very simple technique for dynamically updating web pages using JavaScript (http://en.wikipedia.org/wiki/JavaScript). It involves using XMLHTTPRequest (http://en.wikipedia.org/wiki/XMLHTTP) to retrieve (X)HTML (http://en.wikipedia.org/wiki/HTML)

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

Unicorn Enterprises SA

XSLT processor for Windows written in C++ [Freeware].

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

Books & free excerpts - Crane Softwrights Ltd.

Includes a free downloadable preview with helpful references. Purchase gives access to all future revisions.

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

MSXML

Microsoft XML Core Services (MSXML) allows customers who use JScript, VBScript and Microsoft Visual Studio 6.0 to build high-performance XML-based applications that provide a high degree of interoperability with other applications that adhere to the XML 1

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

Introduction to XML Programming

This basic tutorial explains step by step how to use XML Parsers (SAX and DOM), XSLT, and XML Namespaces

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

Unofficial MSXML XSLT FAQ

This is a simple URL that people can use when getting started with XSLT and IE. 19 FAQ (frequently asked questions) which are answered in great detail and with plenty of suggestions to resolve problems.

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

http://rss.hsyndicate.com/index.xml

Get Hospital news - here is the raw XML/RSS feed

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

NewsIsFree: Your Personal News Portal

Use RSS feeds to create your new portal

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

Blogdigger : RSS / Atom Search Engine - Search Blogs

Search RSS feeds

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

Jean-Yves Stervinou > RSS 2.0 traduction française

If you can read/understand french this is a great help for understanding Rss

In del.icio.us/supermatt, 12/11/2005 | Original | Archive

XSQL query statements: what’s wrong?

I’m trying to write a query XSQL page instead of an input data one (for our project). I’ve tried many different combinations but I either get only the comments to show up like here or I get errors with invalid column name, character, etc. I know I’m probably missing something basic, but ; commit end and all those little commands don’t apply here (or at least I think so). Bud, if you could please let me know what I’m missing, I’d be especially grateful. You can also look at our jEdit file that resides on Kevin’s account under XSQL5/XSQL5TEST/insertStoreTEST3.xsql.

In Pink Footsie, 12/10/2005 | Original | Archive | Post to del.icio.us | Technorati

Unicorn XSLT Processor

Freeware XSLT processor for Windows written in C++

In del.icio.us/kevlers, 12/08/2005 | Original | Archive

XSLT and XPath reference card

Quick XSLT and XPath reference card developed by Mulberry Technologies in PDF format

In del.icio.us/kevlers, 12/08/2005 | Original | Archive

Oreilly on XSLT

XSLT documents a core technology for processing XML. Free chapter by O'Reilly

In del.icio.us/kevlers, 12/08/2005 | Original | Archive

MSDN Developer's Guide

The successor to Extensible Stylesheet Language (XSL), XSL Transformations (XSLT) is an XML-based language that enables you to transform one class of XML document to another

In del.icio.us/kevlers, 12/08/2005 | Original | Archive

Error Codes and what they mean

Programming can be difficult, especially when errors occur. Luckily, when they do happen, XSLT produces a number of different error codes to help troubleshoot the issue. The error codes produced by Shady Waters’ code helped me determine what the cause of the problem is.

The first error code, ORA-06550, gives the line and column location of the SQL block where there was an error.

The second error code, ORA-00947, was a little more helpful. This code occurs when an SQL statement requires two sets of values equal in number, and the second set has fewer values than the first set.

By typing these error codes into Google (or if you want to make me happy: search.msn.com), you can see the cause as well as the solution.

In Kevin's Blog, 12/08/2005 | Original | Archive | Post to del.icio.us | Technorati

Dynamically Generated Lists… not good enough

Dynamically generated lists are all well and good, but is there a way to alphabetize the list? Especially once the list of stores or ZIP codes starts increasing in size, it can become difficult to find specific values. In an effort to make it as easy as possible for the user, there must be someway to better organize the list. Any suggestions Bud? Thanks.

In Kevin's Blog, 12/08/2005 | Original | Archive | Post to del.icio.us | Technorati

JB’s problems in her ice cream cone

JB’s group has an error. We are trying to create a customer input form. We can get the page up with the source. check it out here. But the problem we have is when we input information on a customer and we get an error that looks like this!

This is the code we used to insert the info. We pretty much took the examples from class and changed it to our specific case.

bind-params=”customerID zip flavor”>
BEGIN
INSERT INTO customer VALUES(?,?,?);
COMMIT;
END;

p>

Help us please…otherwise JB can’t eat her ice cream

In Shady Waters, 12/07/2005 | Original | Archive | Post to del.icio.us | Technorati

Office XML as ECMA and ISO Standard?

Microsoft standards using XML? Can Microsoft please the open-source crowd?

In del.icio.us/mridge, 12/05/2005 | Original | Archive

AJAX vs. desktop development

How AJAX and stand-alone software are similar

In del.icio.us/mridge, 12/05/2005 | Original | Archive

Null indicator and why it comes in handy

The xsql:query can have many different attributes, one being the null-indicator attribute. In the XSQL2 guide, Bud asked us to speculate why adding null-indicator=”yes” is useful. When set to yes, the null-indicator attribute is used on the element for any column whose value is NULL. Without this, the element would otherwise be omitted. In some cases NULL values are essential to represent missing data. For example, the actual ship date on an order may be unknown and is left as NULL until the goods are shipped out and a date is assigned to the column. Without using the null-indicator=”yes”, we would be unable to see these elements containing NULL values.

In Kevin's Blog, 12/02/2005 | Original | Archive | Post to del.icio.us | Technorati

Google Suggest

It automatically suggests completed answers. Check it out.

In del.icio.us/mridge, 11/30/2005 | Original | Archive

The “value-of” “apply-templates”

While reading throught the XSLT book (specifically chapter 4), I ran across examples using and and am confused by the difference. Take for example basic.p54-1.xsl:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:template match=”score”> <xsl:apply-templates select=”grade”/> is the critic’s rating for the musical score of <xsl:apply-templates select=”film”/>

This produces the output: 100 is the critic’s rating for th emusical score of A Little Princess

Then, I substitued “xsl:value-of” for “xsl:apply-templates”.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:template match=”score”> <xsl:value-of select=”grade”/> is the critic’s rating for the musical score of <xsl:value-of select=”film”/>

This produced the same result. So my question is, when you are trying to output literal values when do you use “xsl:apply-templates” and “xsl:value-of”? I think it might have something to do with the defaults but I’m not sure (since this section confused me a bit as well). Any thoughts?

In Matt's Musings, 11/30/2005 | Original | Archive | Post to del.icio.us | Technorati

Microsoft Drops the Office Open Standard Ball

Microsoft and XML - still not playing as nice as they should

In del.icio.us/mridge, 11/29/2005 | Original | Archive

White Spaces

So I tried to take a stab at Matt’s problem with the blank output in the line that he takes away. I couldn’t find the solution, but actually found more problems! I searched on blank lines in output and came across many websites addressing the issue of White Spaces. I still am not sure at the exact definition because it seems like there’s issues with white spaces in code, in output, and everywhere! I need to read a little bit more on it to understand what all the whitespace hype is about.

In zee124, 11/28/2005 | Original | Archive | Post to del.icio.us | Technorati

XPath and XSLT Tutorial

Covers XPath and then XSLT on an element by element basis

In del.icio.us/kevlers, 11/26/2005 | Original | Archive

XSL, XSLT, XML... FAQ

Answers to frequently asked questions on XSL, XSLT. XML jargon explained, and how special characters are handled.

In del.icio.us/kevlers, 11/26/2005 | Original | Archive

Case Conversion

Article on using XSLT to convert XML data from one case to another

In del.icio.us/kevlers, 11/26/2005 | Original | Archive

Jon Udell: Dueling simplicities

The key point here is the creation of a standard way to interact with a database using XML-based protocols. This has the potential to be really huge. We could do bit320 without the whole learning XSQL thing.

In del.icio.us/fpgibson, 11/22/2005 | Original | Archive

Lindsay Prefers XSLT for Dummies — Film at 11

Lindsay has done some good exploration of the XSLT for Dummies book and notes:

I just finished going through chapter 4 in the book and I was somewhat impressed. I actually have a better understanding of templates and template rules. It was much clearer than in class, i thought, sorry Bud.

Well, let’s hope it was clearer than in class because I think only JB even halfway got the finale of XSQL2. Generally speaking, I think you have to work it to get it, and I am glad to see people moving forward on that score.

In Blogonautic Solutions, 11/21/2005 | Original | Archive | Post to del.icio.us | Technorati

Zeenah blows me away — Error for basic.p63-2

Zeenah really takes charge with this post where she describes a fix for the problem noted by Shady and Tiger. What I like about Zeenah’s post is that she takes the time to sit down, look through the stylesheet, and apply what she learned. Impressive.

By the way, here’s the fix that Zeenah describes. You need to go from:

	<xsl:template name=\"CreditLine\">
		<xsl:value-of select=\".\"/> - Brought to you by Tumplates,
			The Template People.
	<xsl:template match=\"film\">

to:

	<xsl:template name=\"CreditLine\">
		<xsl:value-of select=\".\"/> - Brought to you by Tumplates,
			The Template People.
    </xsl:template>
	<xsl:template match=\"film\">

In Blogonautic Solutions, 11/21/2005 | Original | Archive | Post to del.icio.us | Technorati

Error for basic.p63-2

Tigerlily and Shadywaters talked about an error that was brought up when they tried to apply the template basic.p63-2. Looking at the error message itself, it says

End tag does not match start tag ‘xsl:template’.

I went back into the source basic.p63-2.xml and looked for any tags that did not have an ending tag to match and EUREKA! I found one=)

The first xsl:templatename=”creditline”> doesn’t have a coinciding end tag
I just uploaded the document onto notepad, added it in, and its working, so that should solve the problem.

I would have put in the entire code, but no matter how i do it, WordPress reads it as code and it keeps coming up as

- Brought to you by Tumplates,
The Template People.

Film:

Composer:

Anyone know how to just have the code without this craziness? I tried taking our some parts even quoting orlinking it, but it keeps coming up as that and not just the code.

In zee124, 11/21/2005 | Original | Archive | Post to del.icio.us | Technorati

XSLT for Dummies

I just finished going through chapter 4 in the book and I was somewhat impressed. I actually have a better understanding of templates and template rules. It was much clearer than in class, i thought, sorry Bud. I especially like the use of analogies (to a grocery list and so on) and how you could see the rule and associate it with the output. I am a fan of this book…but I still don’t understand this whole concept completely.

I also had a problem with the example from page 63, which returned an error similar to what shady waters got:

file:/home/usr01/bit320/lindsayy/webapps/XSLT/basic.p63-2.xsl
: XML-0121: (Fatal Error) End tag does not match start tag ‘xsl:template’.
file:/home/usr01/bit320/lindsayy/webapps/XSLT/basic.p63-2.xsl : XML-0210: (Fatal Error) Unexpected EOF.
Error occurred while parsing basic.p63-2.xsl: End tag does not match start tag ‘xsl:template’.

Why did this happen?

In Tigerlily's Blog, 11/20/2005 | Original | Archive | Post to del.icio.us | Technorati

Yet another resource on XSLT and xPath

Looks like a great tutorial.

In del.icio.us/supriya, 11/20/2005 | Original | Archive

I love this book!

So I think I’m finally figuring out how XSLT works.. I was confused on what exactly the “match” does. But now I see that it is probably one of hte most important commands. FOllownig the example, if I’m getting this right..if it calls for a match=film..It will go through each part and find where is written, and then everything undereneath that will be styled into the template chosen.

But would film have to be a node which encompasses the other information? I guess I’m still confused on where it is looking for the match.

In zee124, 11/18/2005 | Original | Archive | Post to del.icio.us | Technorati

XSQL Problemos

I decided to go through our notes for XSQL once more, but now I’m getting a weird error. WHen I try to retrieve “xsql query1.no_style.xsql” or even any other table im obtaining an error:

< ?xml version = '1.0'?>

ect customer “ID”, salary “salary”, age “age”, zip “zip”
from house
where age = ?
ORA-00942: table or view does not exist

But when I list all in the folder, it definently exists. Anyone have any solutions?

In zee124, 11/18/2005 | Original | Archive | Post to del.icio.us | Technorati

Because I’m a Dummy!

I found an excellent website which explains XML and SQL’s relationship. It also explains the best times to use XML:

When you want to store an entire block of data and retrieve the whole block later.

When you want to be able to query the whole XML document. Some implementations have expanded the scope of the EXTRACT operator to enable extracting desired content from an XML document.

When you need strong typing of data inside SQL statements. Using the XML type guarantees that data values are valid XML values and not just arbitrary text strings.

To ensure compatibility with future, as yet unspecified, storage systems that might not support existing types such as CLOB.

To take advantage of future optimizations that will support only the XML type.

And when not to use XML:

When the data breaks down naturally into a relational structure with tables, rows, and columns

When you will need to update pieces of the document, rather than deal with the document as a whole

I like the For Dummies series..It explains things so well!

In zee124, 11/18/2005 | Original | Archive | Post to del.icio.us | Technorati

XML clarificaitons

Kevin’s definitely on a roll with his clarification posts on XML which can all be found here. The thing I like about these posts is that Kevin is taking the material and digesting it into a format that he himself understands. This is ultimately what learning is all about.

Kevin’s right. We definitely have a dizzying number of file extensions. The way to make it through is to do exactly what he is doing and sort it all out for ourselves.

In Blogonautic Solutions, 11/13/2005 | Original | Archive | Post to del.icio.us | Technorati

Wordpress and special characters

Kevin has written a great post on Wordpress, explaining how to get < and > to show up. We had some problems with the post because Kevin appears to have written it in Word, causing some non-standard-compliant codes to be inserted that broke the processing chain.

Some would say this is evidence of Microsoft purposely messing things up to break open standards. Personally, I think Microsoft just does not bend over backwards to support open standards, like many other vendors, even open source ones. At the end of the day, you have to accept that there will be some breakage and work around it as it arises.

In Blogonautic Solutions, 11/13/2005 | Original | Archive | Post to del.icio.us | Technorati

The XML Faq

A very good place to go to find quick answers to questions about XML

In del.icio.us/kevlers, 11/13/2005 | Original | Archive

Wikipedia on XML

Wikipedia article on XML. Good introduction to the ins and outs of XML

In del.icio.us/kevlers, 11/13/2005 | Original | Archive

XML.gov

Government web site on the use and power of XML

In del.icio.us/kevlers, 11/13/2005 | Original | Archive

XML Tutorial

Free and helpful XML tutorials from W3Schools.

In del.icio.us/kevlers, 11/13/2005 | Original | Archive

Extensible Markup Language (XML)

Main page for World Wide Web Consortium (W3C) XML activity and information.

In del.icio.us/kevlers, 11/13/2005 | Original | Archive

Wordpress and Character Codes

As observed by Matt, Wordpress has the tendency of treating anything in brackets (<>) as code, which can sometimes cause a problem when you want others to review your code. Matt suggested placing a space between the angle brackets and the content of the brackets. A better way to do this is to use the character code. I listed the codes and the corresponding symbols below:

< is < (That's ampersand and lt;)

> is > (That's ampersand and gt;)

By using these codes in place of the brackets, your posts now should display properly.

In Kevin's Blog, 11/13/2005 | Original | Archive | Post to del.icio.us | Technorati

Kevin’s Notes: Understanding XML file types

.xml, .dtd, .xsl, .htm… what do all these file extensions mean? After logging into elab-linux4 using SSH, we are bombarded by several files ending in a host of different file extensions. I thought I would clear up the confusion and give a brief explanation of what all of these extensions mean:

.xml – This is the data document that contains all the names of tables, fields, and data in the fields.

.dtd – This schema document contains the structural definition of the tables and fields (data type, length, etc.). Click on the following link to read about the importance of using schemas.

.xsl – This document specifies the presentation of data, including fonts, spacing, etc.

.htm – This file pulls together all the previously mentioned documents into html format to display in the browser.

The .xml and .dtd files are essential to understanding the data.

In Kevin's Blog, 11/13/2005 | Original | Archive | Post to del.icio.us | Technorati

Kevin’s Notes: Importance of using schemas

Raw XML isn’t concerned about data types… and that’s a big problem. Luckily, the World Wide Web consortium, W3, recognized the need for rules and constraints by creating schemas (.dtd files). An XML schema defines how elements are related and what data can go into those elements. As discussed in class, a schema is typically referenced at the header of an XML document.

In Kevin's Blog, 11/13/2005 | Original | Archive | Post to del.icio.us | Technorati

For those for whom XML is an expertise

it is probably the most common problem for English-language XML documents

In del.icio.us/pinkfootsie, 11/10/2005 | Original | Archive

It seems I “don’t understand”

On page 20 of the slides from last class, there are some things to do “on your own.” The slide says

If you understand what we just did, you will need to change exactly 1 word in the XSLT templates we created for transforming our XSQL results to HTML.

I’ve gone over these slides about 5 times now and I still have no clue what we’re supposed to do here. By “make this work for query3.no_style” I assume we’re supposed to add a stylesheet element, save it as query3.HTML.xsql and run it on a browser. I tried that, but when I run it in a browser I just get a long row of numbers, unlike the nice table we got for query 1. I figured I wouldn’t get it right because I have no idea what to change in the “XSLT templates,” so I didn’t change anything. Does anyone understand what we’re supposed to do?
!!

In jb's blog, 11/09/2005 | Original | Archive | Post to del.icio.us | Technorati

IDs and unique identifiers

To take a stab at Matt’s question about unique identifiers I believe that the ID is a unique identifier for SQL and customernum is part of the code that identifies the sequence of records to put in (I’m not sure if it’s a necessary unique identifier at all, though in code it uniquely identifies each row). It allows for each record to be uniquely put in without the information looking like the Root example we did in class (ie customer opens and closes each command). I hope this kind of helps.

In Pink Footsie, 11/08/2005 | Original | Archive | Post to del.icio.us | Technorati

Primary Key Confusion

I was reviewing the class notes today when I decided to go to http://elab-linux4.bus.umich.edu:8080/~mattrupp/XSQL2/query1.HTML.xsql to view the formatted query results. Then I decided to view the source and this is where it gets confusing. When I looked at this data table I initially assumed that the Primary key was in fact the ID column. However when I viewed the source, it appears that “Num” is actually the primary key. To give you a better understand here is an excerpt from the source code:

        < customer num=“1″>

      < ID>30ID>

      < salary>129310.4066salary>

      < age>32age>

      < zip>48127zip>

ustomer>

As you can see there are two things which I interpret to be a primary key the “num” and

SQL, XML, & Ice Cream

A remixable web learning project at Michigan's Ross School of Business

BIT320 Remix — XML