Nawar Gailani

Hi Virag,
Sorry for the delay, I was on vacations.
I tried your query, but I had some errors, first Candidates table doesn't have study_id.
Anyway, I'm still looking for an explination!
What I found that 'AND' and 'OR' in my query don't actually function like I thought! for example:
SELECT DISTINCT Candidates.* FROM Studies INNER JOIN (Candidates INNER JOIN CandStudy ON Candidates.cand_num = CandStudy.cand_num) ON Studies.study_id = CandStudy.study_id WHERE Studies.name LIKE '%Study%' AND Studies.name LIKE '%One%'
Here 'AND' is concating the two strings to be like this condition:
WHERE Studies.name LIKE '%StudyOne%', which is not what I'm looking for!

Hi Carol,
I don't have a problem in retrieving when I don't use 'and'. The only problem is when i write 'Where <condition1> AND <condition2>'.
Where condition1, condition2 related to table b.
I will examine the database design and the relations carefully. Maybe I missed something in the design stage. I'll post if I reach something (for a reference).
Thanks all.

Thanks Arulanand for your help.
Unfortunately, it gave me the same results. What puzzles me is that both queries work with the OR, but don't work with AND!
so when i write:
select
a.*
from
Candidates a,
(select
c.cand_num , b.study_id
from
Studies b
left outer join
CandStudy c on b.study_id = c.study_id
where
b.name LIKE '%StudyOne%' AND b.name LIKE '%StudyTwo%'
)
as
d where a.cand_num = d.cand_num

it returns empty table while there is one record that meet the criteria.
It's strange!
I'll try with MySQL and post the result.

Ok I edited my post to make it clearer.
Also I exported the database to SQL server express and tested there, it was the same problem. I searched everywhere but couldn't find an answer.
I think many of you guys came to such a query, so I hope one of you can answer me as I think it will pop up a lot in front of me.
How can I select from table A according to conditions from table B while A and B are linked by table AB? I mean is there something wrong with my sql statement?
Is there something I should know about using AND in sql statement?
Thanks for any help or hint.

Hi there,
I don't know if this is the right place, but I hope so.
I am using Access as a database and trying to execute a sql statement but without success.
The tables I have are:

Candidates
----------
cand_num (PK)
firstName
lastName
profession
phone
mobile
email
fileName

Studies
-------------
study_id (PK)
name

CandStudy
------------
cand_num (PK)
study_id (PK)

so they are two tables + one linking table. When I run this statement:
[B]SELECT DISTINCT Candidates.* FROM Studies INNER JOIN (Candidates INNER JOIN CandStudy ON Candidates.cand_num = CandStudy.cand_num) ON Studies.study_id = CandStudy.study_id WHERE Studies.name LIKE '%StudyOne%' AND Studies.name LIKE '%StudyTwo%'[/B]
I get nothing, but there is one record who should appear. It gives me not correct results in whatever conditions using AND, when I replace AND with OR, it gives me right results!
Is this a bug in MS Access? or I should write my sql statement differently?
Thanks for any help

[ January 18, 2007: Message edited by: Nawar Gailani ]
[ January 23, 2007: Message edited by: Nawar Gailani ]

Hi Satou,
The web.xml in:
C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\listenerTest\WEB_INF\
And the three classes in:
C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\listenerTest\WEB_INF\classes\com\example

The URL is:
http://localhost:8080/listenerTest/ListenTest.do

Hmmm! I think I found the 'silly' mistake! it is WEB-INF Nawar!!
Ok it is working now and I learned something: "Always prepare a strong coffee before you start coding!"

Thanks for your post Satou, and for this cup of coffee I'm drinking now!

Hi there,
I have an error in Tomcat while trying out this tutorial:
HTTP Status 404 - /listenerTest/ListenTest.do type Status report message /listenerTest/ListenTest.do description The requested resource (/listenerTest/ListenTest.do) is not available. Apache Tomcat/5.5.17

I rechecked everything, and all seem fine! So I started NetBeans (the holy gift) and copy'n'paste all the java sources. Everything just worked fine! I overwrote the classes in my Tomcat directory with the ones compiled from NetBeans, but still the error there! Can anyone help?
Here are the source files (although I don't think this is the problem!):
package com.example; public class Dog { private String breed; public Dog(String breed) { this.breed = breed; } public String getBreed() { return breed; } }

package com.example; import javax.servlet.*; public class MyServletContextListener implements ServletContextListener { public void contextInitialized(ServletContextEvent event) { ServletContext sc = event.getServletContext(); String dogBreed = sc.getInitParameter("breed"); Dog d = new Dog(dogBreed); sc.setAttribute("dog", d); } public void contextDestroyed(ServletContextEvent event) { //nothing to do here } }

package com.example; import javax.servlet.*; import javax.servlet.http.*; import java.io.*; public class ListenerTester extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println("test context attributes set by listener<br>"); out.println("<br>"); Dog dog = (Dog) getServletContext().getAttribute("dog"); out.println("Dog's breed is: " + dog.getBreed()); } }

<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4"> <servlet> <servlet-name>ListenerTester</servlet-name> <servlet-class>com.example.ListenerTester</servlet-class> </servlet> <servlet-mapping> <servlet-name>ListenerTester</servlet-name> <url-pattern>/ListenTest.do</url-pattern> </servlet-mapping> <context-param> <param-name>breed</param-name> <param-value>Great Dane</param-value> </context-param> <listener> <listener-class> com.example.MyServletContextListener </listener-class> </listener> </web-app>

is there something wrong with my code?
Can I use NetBeans for this exam and skip all that headeache?!
Thanks in advance
[ October 25, 2006: Message edited by: Nawar Gailani ]

As Chandra said, use setIcon() method.
Example:
redoButton.setIcon(new javax.swing.ImageIcon(getClass().getResource("/images/redo.png")));

The redo.png image is in images directory which is relative path.
Hope this helps.

Thanks a lot Satou

Hi there,
Do I need to buy books about design patterns and UML for this exam?
Is it better to read these first?

Thanks

Hi there,
I have some problems to understand and achieve the results I want. Let's say I have two tables, one for students and the other for courses.
I want to display the student details and the courses he/she did listed beside his/her details in the report. This will lead to two SQL statements:
select * from students
select * from courses where courses.studentID = students.studentID (which will be retrieved from the first statement)
Now, what I use for the second statement? A subreprot?
1.I want to use this report within my application, so the report will depend on the search result (same design) What to read about this?

I really appreciate any links or answers,
Thanks

Thanks Gregg
Without your help I would stay with that 'ugly' code and keep complaining how 'cmd' is a stupid command from the old dos days!
I also will not forget your info about getting the String from a Java class.
Cheers!

Oh! I think I have to drink a strong coffee to wake up!
You already told me the answer! but I thought it is to execute specific program not a file!
My mistake, sorry
The thing is there is another button that browse for a file, then the file path will be stored in the database, when recall the record the path appears on this label and by pressing the first button, the file will open inside the associated program.
Thanks a lot Gregg, I didn't thought to use backslash before the backslash in the string!
Now I only need to check for a backlash in the String and then apend another one before execute it, right?
YES!
String archivo = cvArchivoLink.getText(); archivo = archivo.replace("\\", "\\\\"); if(archivo.length() > 5) { try { Runtime.getRuntime().exec("cmd.exe /c start \"\" \"" + archivo); }catch (IOException ex) { ex.printStackTrace(); } }
[ March 31, 2006: Message edited by: Nawar Gailani ]

Originally posted by Gregg Bolinger:
Well, after reading that link you posted, I tried this...

Runtime.getRuntime().exec("cmd.exe /c start \"\" \"C:\\Program Files\\Microsoft Office\\Office10\\EXCEL.EXE");

And it worked great.

Yes Gregg, it works great
I prefered that the file be executed like in the first way whether it has spaces or not, because it is just like double clicking a file (in windows explorer for example) and Windows knows which program associated with this extension because I don't know exactly what format this file will be.
Well, after asking my client (my wife actually) what formats mostly she thinks she will use, she said doc 90% and the remain mostly pdf, so I wrote this code:
private void cvArchivoExecButtonActionPerformed(java.awt.event.ActionEvent evt) { String archivo = cvArchivoLink.getText(); String extension = archivo; if(archivo.length() > 5) { int index = archivo.lastIndexOf("."); if(index != -1) { extension = archivo.substring(index); } if(extension.equals(".doc") ) { try { Runtime.getRuntime().exec("cmd.exe /c start winword.exe \"" + archivo + "\""); }catch (IOException ex) { ex.printStackTrace(); } } else if(extension.equals(".pdf")) { try { Runtime.getRuntime().exec("cmd.exe /c start AcroRd32.exe \"" + archivo + "\""); }catch (IOException ex) { ex.printStackTrace(); } } else { try { Runtime.getRuntime().exec( "Explorer.exe \"" + archivo + "\"" ); } catch (IOException ex) { ex.printStackTrace(); } } } }

And the result is ok.

Thanks again for your time and suggestions

Hi Gregg,
yes I tried it, it just shows the command prompt with the title of archivo value.
I have searched and found
this.
So it seems a problem with cmd in windows as it behaves like the old dos!
Anyway I'm trying now to check the extension of the file, so if it is doc or pdf i open it with word or acrobat repecively, if not i open it with explorer.
If I find a better solution for the spaces in the file name I will post it as a reference.
Thanks for your time