CFSET / UPDATE SQL

2001-05-31 Thread David Clay
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

Re: CFSET / UPDATE SQL

2001-06-01 Thread Jamie Jackson
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

Re: CFSET / UPDATE SQL

2001-06-01 Thread Jamie Jackson
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

RE: CFSET / UPDATE SQL

2001-06-01 Thread Jamie Jackson
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,