I see two problems.
1. You seem to be missing a left parentheses (, or you could just get rid of
the right paren.
2. You need to change "CurrentlyEmployed= AND". The lack of a value will
cause problems.
Duncan
---
Duncan Salada
Titan Systems Corpora
See Notes
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 14:01
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Error in SELECT
Hi,
I have the following statement that is causing a syntax error:
sLearnerSQL = "
SELECT *
>From LearnerDetai
It would seem that you are getting the character corresponding to the ASCII
code 53 as the result of the first query. Try inserting the value for logo
in your table without the quotes round the 53 and see if the results of the
queries become consistent. IMHO this is a bug because the two queries a
