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:
>
> <CFQUERY name="getWaitingStudent" datasource="SMC">
> SELECT ClassSchedID, InputDate, WaitList, RegistrationID
> FROM ClassRegistration
> WHERE InputDate (SELECT MIN(InputDate)
> FROM ClassRegistration
> WHERE ClassSchedID=99999)
> </CFQUERY>
<!--- What do you get if you put this in right here? --->
<cfoutput>getWaitingStudent.WaitList='#getWaitingStudent.WaitList#'</cfoutput>
<cfabort>
> <CFSET ClassID=#getWaitingStudent.WaitList#>
> <CFSET RegID='#getWaitingStudent.RegistrationID#'>
>
> <CFQUERY name="InsertWaitingStudent" datasource="SMC">
> UPDATE ClassRegistration
> SET
> ClassSchedID=#ClassID#,
> WaitList=NULL,
> ModifiedDate=#Now()#
> WHERE RegistrationID='#RegID#'
> </CFQUERY>
>
>Dave Clay
>Internet Facilitator
>Trus Joist, A Weyerhaeuser Business
>5995 Greenwood Plaza Blvd, Suite 100
>Greenwood Village, CO 80111
>303.770.8506
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
