strDSN = request.site.datasource;
// Check the action for the form
if ( NOT StructKeyExists(request.params, "action") )
request.params.action = "form";
Custom Properties Batch Insert
SELECT ID, Name, Title, PageType
FROM SitePages
WHERE PageType = 1
ORDER BY Title
SELECT FormControl.FormName, SUBSTRING(FormInputControl.FieldName, 5, LENGTH(FormInputControl.FieldName)) AS FieldName, fm.FormID,
FormInputControl.ID AS FieldID
FROM FormControlMap AS fm
INNER JOIN FormControl ON fm.FormID = FormControl.ID
INNER JOIN FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID
INNER JOIN FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
WHERE fm.ClassConstant = 1