Recent content by blackbirdMIT

I tried another computer and it worked for me too. My new problem is ... I tried Microsoft Frontpage to start a nice html then inserted my applet in it. When I view my html, I only see my html and an empty gray box that's suppose to be my applet. I don't have any problem now viewing my...

I have these files: AnotherHello.class AnotherHello.html AnotherHello.java Applet Code: import java.applet.Applet; import java.awt.*; public class AnotherHello extends Applet { public void paint ( Graphics gr ) { setBackground( Color.lightGray ); gr.drawString("Hello&quot...

That makes a lot more sense for a beginner like me. Thanks for the tips!

I need help! Below is my code: import java.util.*; class RandomInts { public static void main (String args[]) { System.out.println ("You have generated quick pick Lottery numbers.\n" + "Goodluck! Here they are:\n"); int number = 0; int limit = 6; Random generator...

I need help in generating random numbers using JAVA. I need to generate at least three sets of numbers (not duplicated). The set range should be between integers 1 to 55. I need some code to start with as I'm new in this Java programming arena. The output is simply using System.out.print...

Table Properties - Odors OdorID Int OdorNum Int Odor nvarchar(50) Here's my Cursor: DECLARE OdorCursor Cursor FOR SELECT * FROM Odors; DECLARE @TheCursor Cursor; SET @TheCursor=OdorCursor; OPEN @TheCursor; DECLARE @OdorID Int; DECLARE @OdorNum Int; DECLARE @Odor nvarchar(50); FETCH...

Below is my query: (This lets me view the Oil Name and Caution. I would like to be able to update or delete oilname and/or caution items.) SELECT dbo.Oils.OilName AS [Oil Name], dbo.Cautions.Description AS Caution FROM dbo.Cautions INNER JOIN dbo.OilCautions...

I need help in developing an updatable cursor that updates and deletes rows from a table/s. I only like to deal with Oil.OilName and Cautions.Description. I have the tables below: OIL table: OilID int OilName nvarchar(50) LatinName nvarchar(50) PlantTypeID int PlantPartID int CAUTIONS table...

Can we do a Join for this requirement? Any advantage on using the correlated subquery instead of using Join as far as performance issues?

How can I expand the scope of the trigger to handle delete and update for the insert trigger you've shown above?

The MyOils table is empty; no records yet.

It is still not updating the MyOils table after adding the where OilID = (select OilID from inserted) OilID = int(4) in MyOils table

Do you know of another to accomplish the same results using a different method (not correlated subquery)?

I would like to display each oil (the oilID and oilName) and the property (propertyID and propertyName) with the highest propertyID associated with it. I want the results by the oilID. The highest propertyID or number means it's more associated with an oil compared to a property with a lower...

The MyOils table did not update after I added a test oil into the Oils table using INSERT statement. INSERT INTO Oils VALUES ('50', 'OilNameTest1', 'LatinNameTest1', '1', '1') GO What am I missing?