<% IF REQUEST("createticket")="go" THEN StrCTErr="None" str_subject=sanitizeRequest("subject","form") IF str_subject <> "" AND len(str_subject) < 200 THEN 'ok ELSE StrCTErr="Subject is required" END IF str_content= sanitizeRequest("content","form") IF str_content <> "" AND len(str_content) < 200 THEN 'ok ELSE StrCTErr="Description is required" END IF 'ticketDate=year(now())&"-"&month(now())&"-"&day(now())&":"&hour(now())&":"&minute(now())&":00" IF StrCTErr <> "None" THEN 'print the errors response.write("") ELSE dbCBK.Execute("INSERT into cbk_support_tickets (`schoolID`,`parentID`,`status`,`dateCREATED`,`whoCREATED`,`subject`,`content`) VALUES('"&str_u_id&"','"&str_parent_id&"','new',NOW(),'parent','"&str_subject&"','You said: "&str_content&"')") response.write("") END IF END IF %>