BIT320 Remix — ClassIssues

December 18, 2005

Responding to Aga

Topics:

Aga, saw your two posts. I was unaware of the jEdit problem. You can log into two separate hosts under different user names, i.e., thecommunityengine.com and elab-linux4.bus.umich.edu. I guess, per your report, not the same host though.

As for your other issue, I fixed it. We should talk. The general strategy is what I outlined here, but a few of the details were missing in your effort. You were right. You almost had it.

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

Almost there: Please help

Topics:

We’re getting the query form to work and we’re almost there. I got it to work (it’s simple, but the big complicated baby is being born tomorrow). I got everything to work except for the data to show up as a table. I’ve been trying to figure out what’s not working with connecting the simpleTable.xsl to the final output file and the only thing I could come up with was the templatematch command which refers to the rowset-element. I think everything is right so I’m out of ideas. Something’s missing and I’m determined to make this work. Please help. The files that interlink are on Kevin’s account under webapps/XSQL5/XSQL5TEST called createStoreInsertFormAGA1.xsql, customerHTMLAGA.xsl, insertStoreHTMLAGA.xsl, insertStoreAGA.xsql. THANK YOU SO MUCH!

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

December 17, 2005

RSS Project Question, SuperMatt Goes for Bonus

Topics:

Matt references an RSS question Aga raised last week. Frankly, I confused this one with a bookmark someone had made about RSS resources they had found for the project. The bookmark sounded like people were charging ahead. Matt and Aga want some ideas for how RSS could be used for Denali. Here’s a couple of ideas:

  1. A feed of the most recent flavor requests from customers. Maybe the zip code could be a category element (i.e., a tag). You could easily aggregate requests by zip. Flavor might be another category element.
  2. You could also have a feed of salesperson updates.

Basically, the ideas is to use RSS as a notification format. Categories give you convenient ways to aggregate the information in the feed.

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

RSS Question still not answered

Topics:

A week ago Aga wondered:

 

We’re wondering what kind of functionality would you like us to have involving RSS? We have a couple of ideas on how we could feed, but we’re wondering what are some options or preferential ways to feed into (let’s say we have a website…what do we feed it to? is there anything else we should consider?). Though we haven’t gotten to it, we’d like to attempt this portion though we may not get it to work. Any feedback would be greatly appreciated.

 

We still haven’t resolved this issue and now I am trying to decide which data I should try to transform into valid RSS feeds.  Any ideas or thoughts are welcomed.  Thank you

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

December 13, 2005

Question for Tigerlily

Topics:

Thanks to Tigerlily for looking at our code, and coming up with a possible solution. I have a quick question. When you entered ?RETAILERNAME=MEIJER, where did you enter this? As in, did you enter it in the Where clause or along with xsql:query bind-params=”RETAILERNAME”? I actually entered in with the Where clause but that is still giving me an error. Also, do you still define the bind param with the command xsql:query bind-params=”RETAILERNAME”?

Thanks again for your help :)

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

December 12, 2005

Project: Problem with XSL File

Topics:

We have another problem with our XSL file. We modified the original XSL file that we used to create forms to input store information and was working to create another file to create a form that the customer would enter the query and retrieve the store information. So, the xsl file is called insertStoreHTMLTEST3.xsl  and we converted the xsql to TEST6.xml. Now, when we do oraxsl insertStoreHTMLTEST3.xsl TEST6.xml, we get the following error:

Error occurred while parsing insertStoreTEST3.xsl: /home/usr01/bit320/kevlers/webapps/XSQL5/XSQL5TEST/insertStoreTEST3.xsl (No such file or directory)

But insertStoreTEST3.xsl does exist in the directory. Could you please look into our files, and tell us where we are going wrong?

Thank you.

 

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

Question regarding project

Topics:

We made the changes as advised by Bud in his post and added the RETAILNAME parameter in place of the ?.   However, our XSQL is still not working. Our files are in Kevin’s account in the directory kevlers>webapps>XSQL5>XSQL5TEST. We created two versions - insertStoreTEST5.xsql has the code as advised by Bud. The other file - insertStoreTEST3.xsql has the same code as the other but we defined the bind param in the code above.

However, neither of the two files are working.

When we run the file insertStoreTEST3.xsql, we get the followin error:

&lt ?xml version = ‘1.0′? &gt
&lt page &gt
        &lt xsql-error code=”1006″ action=”xsql:query” &gt &lt statement &gt SELECT RETAILERNAME, ZIPCODE, STORESTREET, STORECITY, STORESTATE, STOREPHONE
        FROM STORE
        WHERE RETAILERNAME='’ &lt/statement &gt &lt message &gt ORA-01006: bind variable does not exist
&lt /message &gt &lt /xsql-error &gt
&lt /page &gt

Then, when we run the file insertStoreTEST5.xsql, we get the error:

&lt ?xml version = ‘1.0′? &gt
&lt page &gt 
        &lt ROWSET&gt
&lt  /page &gt

Could you please tell us what is going wrong. We replaced the ? with the RETAILERNAME parameter, and then tried two ways: with and without defining RETAILERNAME parameter, but none of it is working. Thank you :)

 

 

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

December 7, 2005

JB’s problems in her ice cream cone

Topics:

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

November 30, 2005

CD Sophistication at its best

Topics:

Pink Footsie seems to be having some issues with the Secure Shell we use in class. Some help might be found on this site that Blogstar found in response to a post Tiger Lilly.

But as a suggestion, just type in “cd” and it should pop you back into the very original directory that you start out in when you log in. Hopefully that will help ;) It’s not a really sophisticated solution but it gets the job done ;)

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

CD: change directory issue

Topics:

I just have a quick question regarding the simple cd command. When I first get into Secure Shell and try to get down to the directory i want it allows me to do so by doing cd and then the name of the directory I want to get into. But for some reason i cannot do so in reverse lately: ie. once I’m let’s say in Chp6 in webapps it doesn’t allow me back to change into webapps or any of the other directories above the stream. I tried to backtrack directory by directory but it doesn’t work. So the only thing I’m left to do is exit and re-login. The errors I get are always

cd: webapps: No such file or directory
which of course doesn’t make any sense since i see it in jEdit and they’re not typos either. Any suggestions or reasons for why this is happening?

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

November 24, 2005

A basic XML question.

Topics:

I was just debating whether or not to post this rather simple question. But I just wanted to clairfy something with the XML gurus out there.

I was just reading Zee124’s post which was in response to the question posted by Tigerlily. As Bud describes:

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

	 		 - Brought to you by Tumplates, 			The Template People. 	
mplate name=\\"CreditLine\\"> 		 - Brought to you by Tumplates, 			The Template People.

My simple question: Instead of adding the closing tag line , can we just not add a forward slash to the line . Or does that not work cause we have other lines in between the start and end commands? I guess my question is that why can we close the within the same command line but not do /> instead of adding ?

p>

In supriya, 11/24/2005 | Original | Archive | Post to del.icio.us | Technorati

Question- xsl:copy versus xml:copy-of

Topics:

Like TigerLily, I was too very impressed reading Chapter 4 of the dummies book. I think it really explains each command in detail.

However, I still have a few open questions. I have read the part on xsl:xopy and xsl:copy of a few times, but I am not sure if I understand exactly when I would use one versus the other. Pg.58 of the book provides a good summary on the parts included in the result tree from the two elements. Can someone give me a practical example (besides the book one on miniscore.xml) as to how to distinguish b/w the two commands?

Happy Thanksgiving :)

In supriya, 11/24/2005 | Original | Archive | Post to del.icio.us | Technorati

November 8, 2005

Question about Bookmarks

Topics:

I have been posting new bookmarks, and I just noticed that they are not showing up under the Bookmarks link. However, they show up under the Everything link. Why is that? Its almost been an hour since I posted some of my bookmarks, and as I remember the time lag for updates is around 15 minutes.

Any clue?

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

October 7, 2005

Stuffy nose doesn’t help

Topics:

So I’ve tried to catch up with my reading though I’m fighting a nasty cold and really feel like snoozing (hot cocoa would really help right now). On page 7 of section 3 in our ER reading just above problem 6 there is a paragraph that I don’t understand. Mainly what is the main difference between entity and entity type. Here’s what I mean:

 

Realize that this is a different distinction than that between entity types and entities. In this example, BIT320 is one specific instance of the entity type Course and section 2 of BIT320 in Winter 1962 is one specific instance of the entity type Section. Thus, both are entities and neither one is an entity type.” (can also find this here).

 

Can someone explain? I’m sorry I’ve had too much NyQuil and everything sounds foreign to me.

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

October 3, 2005

Blog problems

Topics:

Supriya notes several issues with her blog:

First, it won’t let me publish my blogs and give me errors regarding the headers. Aga also complained having the same problem a few days back. Surprisingly, the blog still posts in spite of the error.

Now, as I am trying to create links— instead of making my text a hyperlink, it just inserts the actual link

On the first issue, we have noted this in the past. It’s just a bug. On the second, I’m not sure what is going on. Have you tried closing and restarting your browser? Are you using firefox?

We have an opportunity to use a more advanced version of the wordpress platform, though still experimental. It is a bit less buggy than this one. Send me a mail if you want to use it.

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

My blogs are plagued with errors !!!!

Topics:

Looks like my blogs are plagued with errors.

First, it won’t let me publish my blogs and give me errors regarding the headers. Aga also complained having the same problem a few days back. Surprisingly, the blog still posts in spite of the error.

Now, as I am trying to create links— instead of making my text a hyperlink, it just inserts the actual link (for eg. www.cnn.com) in place of my text.

Anyone having the same problem? Know how to deal with it?

In supriya, 10/03/2005 | Original | Archive | Post to del.icio.us | Technorati

September 28, 2005

Beta Beta Bet on Yourself

Topics:

I thought I would try and connect two threads of thought here.

Recently, Pink Footsie was wondering out loud about what Beta Version means. Matt provided a great answer and other avenues for more information. However Matt went onto complain about in another post about how Word Press hates him and thwarted him in his login. And I have to say, it probably hates all of us. No offense.

Because this blog is a test version. I’m not clear on what version it is, beta, alpha….so on. But it still has bugs and problems. Which I think are compounded because we aren’t sure what everything is.

Just the other day I finally figured out what “Write Page” was and then went editing crazy. Not only that, when curiousity gets the better of you and you click on things you aren’t suppose to, since it is a test version its not quiet clear on how to get back to were you started. I clicked on a presentation theme option and next thing I knew, my blog didn’t make sense anymore.

But even though there are theme, login, adding categories, not quite sure what that is problems, its still kind of phun to test beta…or whatever versions before everyone else. Right…..riiiiiiiight? ;)

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

September 25, 2005

Block your Way, Block your Quotes

Topics:

So Supriya was asking about blockquotes features, like this:

I am not able to block quote when I respond to others’ questions. I tried using the single as well as the double quotes but that does not work. It just shows up with the quotes rather than in the format which shows that I am responding to someone (with the line on the side).

It’s really easy ;)you have to do is click on “HTML” in your tools when you are writing. And when it pops up another screen, put infront of the quote “blockquote” enclosed in carrot things <>.At the end of the quote you then put “/blockquote” in carrot thingys <>. Sorry I can’t acutally can’t show you cause the writing editor is just too smart for me and thinks that I want to quote myself ;)

Actually, I just figured out that if you just type it into your write post viewer, it does it automotically for you. It’s just that smart.

That’s all you really have to do. There might be an easier way, but I don’t know. Life’s hard.

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

September 24, 2005

Question on Block Quotes

Topics:

I am not able to block quote when I respond to others’ questions. I tried using the single as well as the double quotes but that does not work. It just shows up with the quotes rather than in the format which shows that I am responding to someone (with the line on the side). Can someone help me out with that? I think its something silly that I am missing out.

In supriya, 09/24/2005 | Original | Archive | Post to del.icio.us | Technorati

September 14, 2005

Whole lotta posting going on

Topics:

A lot of different themes in the class. Let me hit one of the major ones. Head on, Zee124 notes:

For some reason, I was fascinated by the topic of databases. It may have been the overlapping themes in marketing and bit which got me interested in them. I just hope that I am able to keep up with what I learn this semester and am able to apply it once I graduate.

I think PinkFootsie has a similar concern, and jb mentioned it in her first blog post. It’s a combination of “Gee, there’s a lot of topics here,” and “Am I actually going to be able to use this stuff?”

Well, I can sympathize. We’re doing a lot of new things right now. However, let me offer the following reassurance. On Thursday, tomorrow, as we dig into Normalization, you should start to see the applications. We’ll look more in detail at 1NF; it’s one of the more valuable steps. It’s where you clean the data and understand what it is all about.

Next, remember that in two weeks, the Senior VP of Marketing for Denali Flavors will be coming. He is coming because this is an applied class, and he is interested in what we are doing.

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

What are Repeating Groups?

Topics:

Repeating groups occur when you have mutiple columns of the same attributes. For example if you’re looking at data regarding a parent and their children it should be a ROW for each child as opposed to putting the parent in the first column, the 1st child in the second, the 2nd child in the third column etc. This would be an example of a RG  similiar to the one given in the coursepack. Hopefully this helps.

 Emp ID   Ch1    Ch2     Ch3      Ch4       

   002      Nan         Pat        Lee         Todd      

In The Blogstar, 09/14/2005 | Original | Archive | Post to del.icio.us | Technorati

What are Repeating Groups?

Topics:

In our last session, we talked about normalization and removing repeating groups to achieve 1NF. I am still not sure what repeating groups are, and how to remove them. Could someone please explain repeating groups of fields as well as repeating groups within a field.

For reference, here are the class slides.

In supriya, 09/14/2005 | Original | Archive | Post to del.icio.us | Technorati