Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a
blank space, thus producing an error.
Code below:
SELECT ClassSchedID, InputDate, WaitList, RegistrationID
FROM ClassRegistration
WHERE InputDate (SELECT MIN(InputDate)
FROM ClassRegistration
WHERE Class
See below:
On Thu, 31 May 2001 16:12:03 -0600, "David Clay" <[EMAIL PROTECTED]>
wrote:
>Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a
>blank space, thus producing an error.
>
>Code below:
>
>
> SELECT ClassSchedID, InputDate, WaitList, RegistrationID
> FROM
See below:
On Thu, 31 May 2001 16:12:03 -0600, "David Clay" <[EMAIL PROTECTED]>
wrote:
>Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a
>blank space, thus producing an error.
>
>Code below:
>
>
> SELECT ClassSchedID, InputDate, WaitList, RegistrationID
> FROM
ie
-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 4:28 PM
To: Jamie Jackson
Subject: Re: CFSET / UPDATE SQL
I get he correct answer. It, for some reason, is not putting the value in
the UPDATE query.
Dave Clay
Internet Facilitator
Trus Joist,
4 matches
Mail list logo