Blogonaut

wizdumb: Dynamic Queries

Link: wizdumb: Dynamic Queries.

This is a question that anybody can answer, but I think you, Bud, are going to be the one who can guide us. We want to be able to run dynamic queries to retrieve information from the database via a search with input fields. This may be beyond the scope of our class but if you believe it is something we could tackle, Tom, Marissa, Elizabeth, and I would appreciate any resources that you believe may help us tackle this challenge.

Someone else could have probably come up with what I am about to say.  The main issue here is in defining the requirements.  I will address what I think is the simplest version of what you are describing.  My cut is that you want a way to search field(s) in the database for the occurrence of certain words.  This is not so hard to accomplish.  Create a form with a text field for the user to input the word.  Then create a query using LIKE (see SQL book) to find all records where that word occurs in the field in question.  Start by looking in one field, then extend to other fields.

thecrew: dropdown

Link: thecrew: 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.

M Go Blue's response to this seems good.

 

Smiling_Chen: Progress of our project

Link: Smiling_Chen: Progress of our project.

I have a question about one of our tables. One of the attributes of a table is deadline. When we inserted the data in the first project, it automatically came up with a date format, like dec-12-2004. When we display the table, it has 0:0:0 after the date which represent hour, minute and second. Any ideads how can we get rid of this 0:0:0?

Have a peek at this response to a similar question by Maulin.

maulin: wierd characters in my query result

Link: maulin: wierd characters in my query result.

We got all our queries to display on the web but for some reason one of the query results has some additional 0:0:0 under each row displayed. If the result is viewed in SQL it comes out perfectly fine without any junk.

This is a fun feature of XSQL pages!  Here is some XSLT code that will get rid of it:

<xsl:value-of select="substring-before(Date,' 0:')"/>

What this code does is select an element called Date and then only presents everything before ' 0:', i.e., only the month, date and year, all of which occur before that string.

jrtrana: Drop Down Problems

Link: jrtrana: Drop Down Problems.

Any general advice on getting drop downs to work?  Has anyone else had the same problem?

This fine post from M Go Blue may provide the hints you need.

Hail to the Victors: Oracle Question

Link: Hail to the Victors: Oracle Question.

Does anyone know if there is a master reset for our Oracle spaces to completely claer out EVERYTHING that we added in?  The drop tables command doesn't seem to be cutting it and our database hates us.

This is actually kind of a Project Issue even though you posted it under class issues.  I think Tom's comment below is good.  He should have done it as a trackback.  But at any rate, you need to drop the tables in sequence so that you are not bedeviled by the foreign key constraints.  The algorithm is: 

1. Drop tables that have foreign keys embedded in them but do not themselves embed foreign keys in other tables first.
2. As you eliminate tables, move up to the next level of tables.  These will now no longer embed foreign keys in other tables.
3. Repeat until no tables remain.

Big Blog in the Sky: Making that dolla

Link: Big Blog in the Sky: Making that dolla.

His commentary about industry behemoths and innovation is interesting and in accordance with other literature I've read, too.

Nice article.

55699: adding a picture etc?...

Link: 55699: adding a picture etc?....

I was trying to add a picture as well into the html, but I'm not to sure where to upload it. Any suggestions?

You can use sftp to put it directly on elab-linux4.  After opening an ssh window to elab-linux4, just click on the little icon in the toolbar that looks like a file folder.  That will open an ssh connection.

55699: Problems with formatting

Link: 55699: Problems with formatting.

but when I format the background color or text color, nothing seems to work. Is there some kind of a template that is in place that is not letting me change the formatting?

The CSS file that is referenced in the head element of root.xsl is overriding your efforts.  Either make changes to the CSS file or remove the tag referencing it.

frankcc: check this link out

Link: frankcc: check this link out.

bud, i was thinking about doing the extra work for adding the RSS and HTML. do you think you could provide me with a website with some basic RSS tutorial if possible? Thanks

Check out Maulin's site.  He found a pretty good resource for this.