The DHS Program

	    Element PUBTYPEIDS is undefined in a CFML structure referenced as part of an expression.
	    

	    Element PUBTYPEIDS is undefined in a CFML structure referenced as part of an expression.
	    

		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
	

			SELECT *
			  FROM Param_Page
			 WHERE (PageID=8703 OR (PageID IN (2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		

					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	

		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID
	

		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 32868 ORDER BY d1.id, d2.id 

   SELECT PageID,VersionState,AuthorID
     FROM Param_WDDX
    WHERE ControlID=?
		AND (PageID=8703 OR (PageID IN (2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=8703 AND (VersionState = 2)) OR ((PageID IN (2,1)) AND (VersionState=2))) 
 ORDER BY PageID Desc, VersionID Desc 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT DISTINCT ViewerPageID
		  FROM qry
		 WHERE ViewerPageID <> 0
	

			SELECT ID, FileName, uploaded, pageType, subsiteID
			  FROM SitePages
			 WHERE (ID IN (20698,20454,20695,23729,20451,20692,20219,23721,21548,174808,11742,27084,69739,21558,29277,27099,11998,11517,29274,11990,11992,28181,27093,11996,17266,69742,20433,18357,17269,20430,23707,69745,18353,17260,69748,20439,18592,18350,20436,16170,11724,11968,224187,11960,19207,118098,69754,20445,20686,21532,19458,69751,20442,20683,69757,23718,115802,20448,20689,11976,11970,19219,21500,18576,21503,11701,11703,18579,15075,11709,20427,20424,11713,11958,112106,18555,182612,11918,27027,27263,149826,28593,28356,149823,27024,22808,18315,149829,20643,15053,17471,22827,20405,20402,27033,27030,25099,149832,27037,25093,184699,62011,62014,62017,23564,23568,23561,14611,11341,135299,11343,11347,11589,62020,20068,11591,20065,11593,23332,25998,23337,15719,14627,35302,11353,15952,232840,14624,222837,264671,264676,23783,25962,26814,222832,25966,232638,11329,23780,11323,264664,23554,23558,205038,205033,25970,11331,21370,15933,21100,20010,25701,23767,205041,25959,21596,25951,23774,252280,241394,19004,19007,18397,79990,79993,79996,79999,29283,23758,21577,20243,20240,23755,20006,11778,21570,11774,129563,13240,27887,25225,25228,61569,28978,129560,50671,28972,25222,212608,13246,50674,50677,16996,50437,16758,13248,13250,244699,13254,13252,28988,25234,25238,50440,25231,28984,60487,28981,17615,60484,50443,13258,17618,13256,60481,18700,154782,241397,13220,21087,154789,126278,197227,61103,18913,13224,61100,17825,13222,18916,18910,60490,17822,13226,197224,154771,154776,13230,154779,25219,50462,17839,28962,77921,17836,13236,17833,13238,244247,23486,23489,13208,213739,26990,23483,13202,15864,13200,13206,15867,13204,13210,15870,18906,23493,231396,18902,17813,13214,17816,13212,197215,13218,197212,13216,28910,227926,25885,23224,23227,28913,16937,16931,23475,26984,62008,23478,257790,26987,23472,23230,16943,15853,15611,16940,15614,20852,13084,16351,13088,18770,13086,80002,62805,28331,62808,28335,283401,27002,182841,135855,19874,22804,205928,13098,135858,205921,28341,19877,18752,17421,18512,205933,105173,105170,18755,17424,18515,50614,18758,17427,18520,177495,14163,14160,18523,28327,62841,62838,25299,15257,18526,18971,16796,16793,26115,26119,26111,18975,15472,154794,13292,13298,100792,26127,26123,18749,18509,50648,18746,35290,17860,13260,17621,239754,270598,13262,35298,26578,35294,50651,28992,17869,18959,17866,51747,17625,15692,17872,13030,13034,15694,13274,13032,26107,26582,179869,26585,18968,190886,16788,179866,50665,13278,50668,17875,18965,24935,18014,22999,21665,20332,24938,18011,22993,20338,23843,21668,11866,275865,275862,24948,21675,21671,182327,23850,24941,24944,23854,11635,204201,275854,29159,11631,275859,21642,18473,22970,20319,261204,29128,21649,22973,21645,20314,26095,12936,12934,12938,26092,20564,23837,90455,18001,24929,21658,22986,11613,18697,22956,22959,18694,17360,22950,22953,27165,27168,27161,17134,18466,184704,17131,21639,22932,18675,16250,22936,18672,17341,20518,248033,49177,190353,51901,241400,18688,241403,62802,248043,21263,115797,23685,15828,61047,11469,42199,25875,23698,28904,28901,25879,23217,23690,25871,61056,61053,61050,244702,261286,20399,184555,21243,20396,11681,23663,23421,152517,20393,11689,287248,21254,21011,11691,232507,21250,11693,152520,11695,261281,11697,287253,11699,184536,23649,26916,21461,19145,25820,26913,22799,11669,11661,20370,11663,11423,108813,21236,184545,21231,20384,184548,11673,11675,11677,23867,24956,21687,21202,25805,25808,21683,23860,24953,23864,21206,25801,20358,29167,11647,11880,11641,11643,29162,25814,20367,25817,20364,21210,23870,24961,23873,25811,23876,22788,11659,29179,21690,108807,17962,25104,25107,18814,15546,17968,290229,51889,17965,13128,18820,13132,13130,26202,26689,185159,185162,51892,50563,51895,18826,177500,51898,12048,50566,18823,15761,13100,61464,162291,50571,50574,15764,50577,13102,61472,15531,13110,15771,61475,275040,27515,17956,15777,13114,15534,13112,17959,15774,17953,18802,61482,61485,21186,28813,17928,13324,287260,17925,13322,287263,17922,13326,287266,13330,12000,21197,132825,28826,13334,12002,15511,12004,21193,21190,15756,20077,23343,23346,13308,23340,20074,14633,13302,14630,20071,13300,14637,13306,11367,287286,11369,28808,11371,11373,23596,28804,200334,23593,17919,14641,20080,17910,19986,18896,16234,19981,16232,20738,143350,28693,143344,143347,16238,182715,18899,16242,18665,17335,15399,16246,16244,16248,18669,17338,267042,19961,17784,18631,17781,16210,27107,27104,28675,18638,16214,17787,18634,19965,19968,16218,18641,17310,16220,16224,13198,17791,19971,16222,28689,13190,28681,26262,27111,28685,16228,19977,13162,13160,15586,16431,15583,13164,26236,28898,28891,122441,28894,17769,15589,16435,17772,13172,15592,17775,13176,16200,13174,162295,50760,50763,16206,16204,13178,122438,50766,50769,17778,16208,18626,13140,19920,13144,237696,13142,185165,28639,185168,27549,50772,12056,50775,12058,13146,12060,50539,19930,28888,185175,20922,267060,20919,28885,28882,27793,50542,19936,50545,13156,19933,18602,50548)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT Name AS NameValue
	
			, SubsiteID
	
		  FROM SitePages
		 WHERE
	ID = ? 

		SELECT *
		  FROM Search_AnalyticsData
		 WHERE Keyword = ?
			AND ResultsPageID = ?
			AND SessionID = ?
			AND ServerID = ? 

SELECT *, (url + '?cssearch=693196_1') AS FileURL , url AS FILEURL_NOTRACKING FROM resultQry WHERE lower(dhspubcode) NOT IN ('od76')

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

SELECT TOP 300  sp.ID AS PageID, sp.Title, sp.Description, sp.Filename, sp.PageType, sp.Uploaded, sp.SubSiteID, sp.DateContentLastModified, sp.OwnerID
		  FROM Search_FeaturedPages fp
		  JOIN SitePages sp ON sp.ID = fp.FeaturedPageID
		 WHERE fp.Keyword = ?
			AND fp.ResultsPageID = ?
			AND fp.FeaturedPageID > 0
	 ORDER BY SortPosition
	 

		SELECT *
		  FROM Formats
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT Name AS NameValue
	
			, SubsiteID
	
		  FROM SitePages
		 WHERE
	ID = ? 

		SELECT *
		  FROM Search_AnalyticsData
		 WHERE Keyword = ?
			AND ResultsPageID = ?
			AND SessionID = ?
			AND ServerID = ? 

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

			select	fieldID
			from	elementFields
			where	UPPER(fieldname) = ? 

		SELECT DISTINCT PageID
		FROM Data_FieldValue
		WHERE	FormID = ? 
				AND	fieldValue = ?
				AND	FieldID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

		SELECT PageID, FormID, FieldID, fieldValue, memoValue
		FROM Data_FieldValue
		
			WHERE (PageID IN (?,?,?,?,?,?,?,?,?,?,?,?)) 
			AND FormID = ? 
		AND VersionState = 2
		AND PageID <> 0
	

		SELECT *
		FROM 	getDataPageValueQry
		ORDER BY PageID 
	

		SELECT 	FormName
		FROM 	FormControl
		WHERE 	ID = ?
		AND 	(action = '' OR action is null OR action = 'custom_form_element')
	

		SELECT 	ID
		FROM 	FormControl
		WHERE 	(FormName = ? OR FormName = ?)
		AND 	(FormControl.action = '' OR FormControl.action = 'custom_form_element' OR FormControl.action is null)
	

		SELECT     FormInputControl.FieldName,
				   FormInputControlMap.FieldID,
				   FormInputControl.Params,
				   FormInputControl.Type
		FROM       FormControl INNER JOIN
                      FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN
                      FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID
		WHERE      (FormInputControlMap.FormID = ?)
		
			ORDER BY FormInputControl.FieldName
		

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-23 01:30:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\search\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=CSRFTOKEN=4D3DF040C1AB0CB9C0D15C95A5F80CA84231686F; JSESSIONID=6ACC9554091ADBEA27F70FFF4C865076.cfusion
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/search/index.cfm?bycountry=4000%2C76%2C52%2C3%2C50%2C51%2C4%2C100%2C5%2C59%2C53%2C60%2C243%2C7%2C118%2C12%2C220%2C65%2C66%2C129%2C14%2C67%2C20%2C160%2C22%2C23%2C24%2C25%2C68%2C61%2C28%2C29%2C30%2C62%2C35%2C205%2C36%2C208%2C55%2C38%2C39%2C41%2C44%2C47%2C48&bydoctype=publication
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\search\index.cfm
QUERY_STRING=bycountry=4000%2C76%2C52%2C3%2C50%2C51%2C4%2C100%2C5%2C59%2C53%2C60%2C243%2C7%2C118%2C12%2C220%2C65%2C66%2C129%2C14%2C67%2C20%2C160%2C22%2C23%2C24%2C25%2C68%2C61%2C28%2C29%2C30%2C62%2C35%2C205%2C36%2C208%2C55%2C38%2C39%2C41%2C44%2C47%2C48&bydoctype=publication
REMOTE_ADDR=10.0.2.138
REMOTE_HOST=10.0.2.138
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search/index.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CSRFTOKEN=4D3DF040C1AB0CB9C0D15C95A5F80CA84231686F
JSESSIONID=6ACC9554091ADBEA27F70FFF4C865076.cfusion

Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=21
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
cmdcollectioncallcount=0
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (123)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_request_start_memory=1329751408
cs_runningdashboardcmdcode=0
csrftoken=4D3DF040C1AB0CB9C0D15C95A5F80CA84231686F
ctrl_data=Struct (55)
customcfupfront=
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (1)
elementsrun=1
enableadftimerinfo=false
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-07-22 09:02:00
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1721638920563
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (12)
params_formfields=
params_urlfields=bycountry,bydoctype
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-22 09:02:00.563
req_sequenceid=278890
req_startticks=1721638920563
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_6ACC9554091ADBEA27F70FFF4C865076.cfusion
sessionstring=1_6ACC9554091ADBEA27F70FFF4C865076.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=35
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (0)
templaterootdir=/
timestamp={ts '2024-07-22 09:02:00'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)

Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
SURVEYINFO_ACTIVE_DATE=2024-7-24
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
_csrf_token=4D3DF040C1AB0CB9C0D15C95A5F80CA84231686F
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=8703
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
groupbyregion=
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1721638878879
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=6ACC9554091ADBEA27F70FFF4C865076.cfusion
sessionstring=1_6ACC9554091ADBEA27F70FFF4C865076.cfusion
urltoken=CFID=3374008&CFTOKEN=e2570b2f446d7ad5-80C2099D-BD65-F6AF-B2206AEF86A696BA&jsessionid=6ACC9554091ADBEA27F70FFF4C865076.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)

URL Parameters:
bycountry=4000,76,52,3,50,51,4,100,5,59,53,60,243,7,118,12,220,65,66,129,14,67,20,160,22,23,24,25,68,61,28,29,30,62,35,205,36,208,55,38,39,41,44,47,48
bydoctype=publication