Whenever I run this code, I get VARIABLE LNAME IS UNDEFINED
PHP Code:
<cfquery name="TeacherFN" datasource="AITE_Test_System">
SELECT Lname, Fname
FROM dbo.[Teachers]
WHERE AD_Username = '#FORM.TeacherAD_Username#'
</cfquery>
<cfquery name="ClassEdit" datasource="AITE_Test_System">
<cfif #FORM.EditMode# IS "AddClass">
INSERT INTO dbo.[Classes] (Class_Name, Teacher_lname, Teacher_fname, Teacher_AD_Username, Period) VALUES ('#FORM.ClassName#', '#Lname#', '#Fname#', '#FORM.TeacherAD_Username#', '#FORM.Period#')
<cfelseif #FORM.EditMode# IS "EditClass">
UPDATE
<cfelseif #FORM.EditMode# IS "DeleteClass">
DELETE FROM dbo.[Classes] WHERE Fname='#Fname#' AND Lname='#Lname#' AND Teacher_AD_Username='#FORM.TeacherAD_Username#'
</cfif>
</cfquery>
Any idea why? THANKS!