CFSET / UPDATE SQL

[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:

 <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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists