Check to make sure that the GetWaitingStudent query is actually returning a row. DC ----- Original Message ----- From: "David Clay" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 09:58 Subject: CFSET > 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> > > <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
