<cfoutput>#sFormText#</cfoutput>
#sHereText#  #sHomeText#     #sFormText#  
insert into emailsupport(caseid, fname, lname, email, phone, product, subject, country, language, description, date_submitted, category) values (#caseid#, '#fname#', '#lname#', '#email#', '#phone#', '#product#', '#subject#', '#country#', '#language#', '#description#', '#date_submitted#', #category#)
#sRegText#
SELECT catid, description FROM emailcat ORDER BY catid;
#sFormText#
#sReqText#

#sFNameText#*
 #sLNameText#*
     
#sEMailText#*
#sTelText#*
       
#sSubText#*
#sWhereText#
#sProdText#
#sCountryText#*
#sLangText#
     
#sDescText#

#SMaxText#
     
SELECT MAX(caseid) AS max_number FROM CHANGE_MGT.EMAILSUPPORT;