JDBC ResultSet exception

2004-04-29 Thread Bjoern Wuest
Dear All I work on a small application with database support. For development I use the MySQL database which is just doing fine. During testing I experienced a, in my opinion, strange bug. I have the following source code: >> Connection conn = p_GetConnectionFromPool(); try {

Re: Help on Select/Join

2003-12-30 Thread Bjoern Wuest
Dear all, thank you very much for the fast and numerous responses. The idea of Roger Baklund does exactly what I want. Thank you very much Roger. I oversee the possibility to use IF conditions on MySQL server, this is what I wanted to do programmatically but to do in the DB server is ok. Let's s

Help on Select/Join

2003-12-29 Thread Bjoern Wuest
Hello I work on this problem for three days now and could not find any tip in any manual, book, tutorial or search engine. I have the following problem: Table1 'pl': +---+---+ | p | o | +---+---+ | 1 | 1 | | 2 | 1 | | 3 | 2 | +---+---+ Table2 'ln': +---+--+---+ | p | l | v | +---+--+