Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Message-ID: <396B3BCA.1DAE6DBF@vei.net>
Date: Tue, 11 Jul 2000 11:22:50 -0400
Organization: Novient
MIME-Version: 1.0
Subject: Re: I am really stumped at this one any1?
References: <20000711020758.98817.qmail@hotmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
To: tomcat-user@jakarta.apache.org
From: "Edward W. Rouse" <erouse@vei.net>

have you run the inner select by itself to see if it gives you the response you
expect? Have you placed that info inside the ALL() to see if you get the response
you expect? Have you tried it without the where clause at all, to see if you get
what you expect?

bottom line, with a complex SQL statement, break it up and try individual
sections. This will speed up your problem resolution.

Ed.

Darren Lee Deliang wrote:

> hi,
>
>     yeah it works without the single quotes. thanks every1. I got another
> bug that sprang out. I suspect it is my sql statement's logic. check this
> out:
>
> String SQLstatement = "SELECT courseNo FROM Course WHERE  courseNo !=
> ALL(SELECT courseNo FROM ApplicationRecord WHERE userNRIC = '" + userNRIC +
> "' ) GROUP BY courseNo HAVING courseDeadline > ? AND courseCapacity > 0 ";
>
> The ? is later set in with an Timestamp object i created later on and works
> fine. The problem I have is that my program does not do wat i want it to do.
> I want it to display courses which the current user HAS NOT booked for
> before. Records of bookings are kept in ApplicationRecord and all the
> courses are kept in Courses. Can anyone tell me what is wrong with my
> statement?
>

<SNIP>