Exclusive Criteria OR Conditions

2004-07-19 Thread Michael . Kashambuzi
I've already checked in the mailing list and have not found an answer. Does anyone know how to perform an OR in the following situation. SELECT A, B, C FROM TABLE1 WHERE A IN (1,2,3) OR B IN (4,5,6) OR D in (7,8,9) For each criterion, I want to add it as a criterion to th

Re: using secured database connection

2004-07-19 Thread T E Schmitz
Hello Guy Guy Galil wrote: I tried appending 'useSSL=true' to the database url in Torque.properties - torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/TURBINE?useSSL=true but it was ignored. I don't think that this is a Torque problem. Coincidentally, I have just set up a sec

using secured database connection

2004-07-19 Thread Guy Galil
We are using Torque with MySql. >From MySql documentation on connecting to database using ssl: "You will also need to set 'useSSL' to 'true' in your connection parameters for MySQL Connector/J, either by adding 'useSSL=true' to your URL, or by setting the property 'useSSL' to 'true' in the java.uti

Re: SortedMap in reverse order

2004-07-19 Thread Raphael . X . Mankin%GSK%SB
Hvae you looked at java.util.Collections? See the methods reverse(), which reverses (moodifes) the collection, and reverseOrder(), which just provides a convenient comparator. Try something like // Create a TreeMap that sorts in the reverse order SortedMap sortedMap = ne

RE: SortedMap in reverse order

2004-07-19 Thread Thomas Fischer
Hi Veronique, you have to use the constructor TreeMap(Comparator c) contructor and provide a comparator implementation which sorts the key in the right order. Thomas P.S. :A small hint: as this is not a torque-related question, you are lucky to get this question answered here. Veronique