Recent content by sagn

I will try those methods as well. The query first listed is very slow as my table is quite large... Nonetheless, it did produce the required results and since this is a once and done need I did use it. However, I am curious about the other methods so will check them out as well! thanks

Thanks a lot! As I said I knew I had seen it before but being 3 pm on a friday my brain is fried!

I would like to have returned the top N entries of a table for each distinct Colvalue s. For example: Table id s 1 w 2 w 3 e 4 w 5 w 6 e 7 e What I want returned is (N above = 2) id s 1 w 2 w 3 e 6 e Any ideas on a query that will do this? thanks. (I'm sure I have...

Hi I am VERY new to JAVA... but I have been working on something similar. I have a table that alternates row color depending on some value. This was done to improve readability of the table. Anyway, I wound up making each cell Object a JTextField. In the editor I created I used the...

thanks a ton I seem to be all set now.

HI I have a form with about 20 textfields on it. I;d like to highlight the jlabel associated with the jtextfield that is in focus. That is easy enough to do, what I am wondering is if there is a way to do this for each JTEXTFIELD/JLABEL without writing 20 different focusevent actions. I...

I think I found the trouble. The Table whose data populate the recordset must have a primary key. Now on to see if I can now multiple concurrent statements and record sets with this driver. I am sure I'll be back. :) thanks

Oh sorry but the exact exception message is Cursor is Read Only. thanks

OK.. I have downloaded a jdbc driver from MS. version 1.4. I create a statement as con.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); when I try to execute updateRow(), I get an exception saying the cursor is not updatable. IF I use...

MSSQL Server. There are drivers for this which I clearly have to look into. Once I download the driver, I suppose I use the Class.forName(driver) command. True? Is that all I have to do to load the driver? thanks

Yes, they do say the JDBC:ODBC bridge should only be used for experimental use. Well, my experiment failed! Anyway, thanks for confirming my suspicions. I am VERY green as far as JAVA is concerned so I am not yet fully aware of all the nuances! thanks again

Hi I have written (or am writing) a program to do the following. Using a JDBC:ODBC bridge 1) Bring down data from three tables (t1,t2,t3) from two different databases (db1,db2). the tables should contain the same data ie db1.t1=db2.t1 but t1 != t2 in data or format. 2) The data between db1...

thanks again!

Thank You so much! In fact, I was able to open a javax.swing.JDialog object but did not know why! Thanks again.

I am *VERY* green at this, so this is a very basic question. I apologize. I have my main form up and running. I have successfully built classes to perform actions upon certain events. I now would like to be able to bring up another window (form) upon some action. But have been unsuccessful...