Clean SQL
By: a guest | Aug 13th, 2009 | Syntax:
SQL | Size: 2.65 KB | Hits: 87 | Expires: Never
INSERT
INTO tblEvalPart
(
EvaluateeID,
EmpID,
RankID,
StatusID,
DateStamp,
Encourage,
txtEncourage,
Respect,
txtRespect,
Communicates,
txtCommunicates,
InfFeedback,
txtInfFeedback,
FormFeedback,
txtFormFeedback,
Direction,
txtDirection,
Decisions,
txtDecisions,
Approach,
txtApproach,
Structure,
txtStructure,
Temperament,
txtTemperament,
Responsive,
txtResponsive,
Training,
txtTraining,
TIME,
txtTime,
RoleModel,
txtRoleModel,
Improve,
Well
)
VALUES
(
#form.EvalID#,
#session.EmpID#,
#form.RankID#,
#StatusID#,
#Stamp#,
#form.Encourage#,
'#HTMLEditFORMAT(form.txtEncourage)#',
#form.Respect#,
'#HTMLEditFORMAT(form.txtRespect)#',
#form.Communicates#,
'#HTMLEditFORMAT(form.txtCommunicates)#',
#form.InfFeedback#,
'#HTMLEditFORMAT(form.txtInfFeedback)#',
#form.FormFeedback#,
'#HTMLEditFORMAT(form.txtFormFeedback)#',
#form.Direction#,
'#HTMLEditFORMAT(form.txtDirection)#',
#form.Decisions#,
'#HTMLEditFORMAT(form.txtDecisions)#',
#form.Approach#,
'#HTMLEditFORMAT(form.txtApproach)#',
#form.Structure#,
'#HTMLEditFORMAT(form.txtStructure)#',
#form.Temperament#,
'#HTMLEditFORMAT(form.txtTemperament)#',
#form.Responsive#,
'#HTMLEditFORMAT(form.txtResponsive)#',
#form.Training#,
'#HTMLEditFORMAT(form.txtTraining)#',
#form.Time#,
'#HTMLEditFORMAT(form.txtTime)#',
#form.RoleModel#,
'#HTMLEditFORMAT(form.txtRoleModel)#',
'#HTMLEditFORMAT(form.Improve)#',
'#HTMLEditFORMAT(form.Well)#'
)