thecrew

Blogging for BIT 320

After I started blogging in class, I have noticed many other forms of blogging tools that exist online. As some of my previous blogs noted, even Forbes magazine has a ranking out for the best blogs. I also noticed my roommate, friends, NBA players, and Scott Moore use blogs. In a way, I am really glad that I have gained exposure to this next hot thing.

I have to admit, it was hard to find a blog topic at times. However, as we moved along in class, I have encountered more and more questions regarding the lecture or the project. I have found everyone in our little blogsphere really helpful in terms of helping one another on the project. I personally had many of my questions solved by reading others' blogs or they even respond to me at times.

So I am not sure if there's anything that needs to be changed. If you asked me this question at the beginning of the term, I probably would have said eliminating blogging altogether. Now after seeing the benefits, I strongly recommend this, not only for BIT classes, but maybe even for other classes.

Overall, it has been a pleasant experience and i hope everyone else enjoyed about blogging as much as I have in the past few weeks.

question on project again

Nick and I have been working on the project again. We have got the dropdown to work, so now the forms look fabulous. However, we are not able to input the data correctly into our database by using our online forms. This is the error msg we receive:

<xsql-error code="1400" action="xsql:dml">

<statement>BEGIN INSERT INTO Contact VALUES(?,?,?,?,?); COMMIT; END;</statement>

<message>ORA-01400: cannot insert NULL into ("NLAPOULA"."CONTACT"."CONTACT_ID") ORA-06512: at line 2</message>

</xsql-error>

Does anyone have the same problem? and able to solve it?

dropdown

We have successfully created the drop down and linked it to the rowset-element. However, on the web, the donor id is not showing up as we expected it to. The select statement is as follows:   select donor_id from grant_program.

You can view the form at http://elab-linux4.bus.umich.edu:8080/%7Enlapoula/project2/createContactInsertForm.xsql

does anyone know the problem associated with this?

another blog

this blog has nothing to do with the technical aspect of the project. I am just excited to find out that this project would actually help out the women's center. I have to admit my stupidity of not recognizing about this before. I think the forms online would simply their work a ton. I previously thought they had to use SQL to input all data...

There are still many technical stuff we have to solve in order for this to work. But at least i know that i am doing something that will be useful.

project question

We were trying to workon the forms that will allow us to input data online. However, we constantly run into this error message that reads "cannot insert NULL into ("NLAPOULA"."CONTACT"."CONTACT_ID") ORA-06512: at line 2" Contact_id and donor_id are supposed to be automatically generated. Contact_id is the primary key where the donor_id is the foreign key. I feel like the problem resides in the donor_id. What do we need to do to avoid this error and at the same time allow donor_id to be automated? We are currently using <td><xsl:value-of select="donor_id"/></td to automate this.

the views

a quick question: I know the first step we did for the 2nd project is to convert our 5 views from the previous assignment into xsql. However, my concern is that my group only received partial credits on the five views for project 1. So I am not sure by implementing these five not so perfect views will have an adverse impact on project 2. If it does, please let us know what we did wrong so we can correct them before working on project 2.

the views for project 2

a quick question: I know the first step we did for the 2nd project is to convert our 5 views from the previous assignment into xsql. However, my concern is that my group only received partial credits on the five views for project 1. So I am not sure by implementing these five not so perfect views will have an adverse impact on project 2. If it does, please let us know what we did wrong so we can correct them before working on project 2.

the views

a quick question: I know the first step we did for the 2nd project is to convert our 5 views from the previous assignment into xsql. However, my concern is that my group only received partial credits on the five views for project 1. So I am not sure by implementing these five not so perfect views will have an adverse impact on project 2. If it does, please let us know what we did wrong so we can correct them before working on project 2.

thecrew: more questions for project 2 | MySmartChannels

Link: thecrew: more questions for project 2 | MySmartChannels.

Thank you for your response to my question. I guess we won't touch on anything that technical in this class, but at least i have a basic understanding of the procedure now. And after reading the article about using XML on the web with XSLT, i am guessing that JavaScript/ECMA is what you would use to implement these functions. It also seems like we are on the very front of technical advancement. In the article, it described our strategy of using both XML and XSLT are "the next generation," where the current standard is "HTML/XHTML."

more questions for project 2

ok, another question for the project. We have successfully converted all five views into xsql. I assume the next step is to convert these xsql to html through xslt. So in order to view these results, we have to first come up with sql. These steps seem to be really long and hard for the organization to use in the future. Is there a simpler way of creating sql and displaying it on the web? Like some sort of command that would automatically place sql script into the right xsql file and the corresponding xslt file.