<!---			NAVIGATION BUTTONS (view page)			--->

<CFIF 
	ParameterExists(Form.btnView_Previous) or 
	ParameterExists(Form.btnView_Next) or
	ParameterExists(Form.btnView_First) or
	ParameterExists(Form.btnView_Last)>

	<CFQUERY name="GetRecord" dataSource="jepi1" maxRows=1>

		SELECT StoreCategories.CategoryID AS ID_Field
		FROM StoreCategories

		<CFIF ParameterExists(Form.btnView_Previous)>
			WHERE StoreCategories.CategoryID < #Form.RecordID#
			ORDER BY StoreCategories.CategoryID DESC

		<CFELSEIF ParameterExists(Form.btnView_Next)>
			WHERE StoreCategories.CategoryID > #Form.RecordID#
			ORDER BY StoreCategories.CategoryID

		<CFELSEIF ParameterExists(Form.btnView_First)>
			ORDER BY StoreCategories.CategoryID

		<CFELSEIF ParameterExists(Form.btnView_Last)>
			WHERE StoreCategories.CategoryID > #Form.RecordID#
			ORDER BY StoreCategories.CategoryID DESC

		</CFIF>

	</CFQUERY>

	<CFIF GetRecord.RecordCount is 1>
		<CFLOCATION url="Control_RecordView.cfm?RecordID=#GetRecord.ID_Field#">
	<CFELSE>
		<CFLOCATION url="Control_RecordView.cfm?RecordID=#Form.RecordID#">
	</CFIF>


<!---			EDIT BUTTON (view page)			--->

<CFELSEIF ParameterExists(Form.btnView_Edit)>

	<CFLOCATION url="Control_RecordEdit.cfm?RecordID=#Form.RecordID#">


<!---			ADD BUTTON (view page)			--->

<CFELSEIF ParameterExists(Form.btnView_Add)>

	<CFLOCATION url="Control_RecordEdit.cfm">


<!---			DELETE BUTTON (view page)			--->

<CFELSEIF ParameterExists(Form.btnView_Delete)>

	<CFQUERY name="DeleteRecord" dataSource="jepi1" maxRows=1>
		DELETE
		FROM StoreCategories
		WHERE StoreCategories.CategoryID = #Form.RecordID#
	</CFQUERY>
	<CFLOCATION url="Control_RecordView.cfm">


<!---			OK BUTTON (edit page)				--->

<CFELSEIF ParameterExists(Form.btnEdit_OK)>

	<CFIF ParameterExists(Form.RecordID)>
		<CFUPDATE dataSource="jepi1" tableName="StoreCategories" formFields="#Form.FieldList#">
		<CFLOCATION url="Control_RecordView.cfm?RecordID=#Form.RecordID#">

	<CFELSE>
		<CFINSERT dataSource="jepi1" tableName="StoreCategories" formFields="#Form.FieldList#">
		<CFQUERY name="GetNewRecord" dataSource="jepi11" maxRows=1>
			SELECT StoreCategories.CategoryID AS ID_Field
			FROM StoreCategories
			ORDER BY StoreCategories.CategoryID DESC
		</CFQUERY>
		<CFLOCATION url="Control_RecordView.cfm?RecordID=#GetNewRecord.ID_Field#">

	</CFIF>


<!---			CANCEL BUTTON (edit page)			--->

<CFELSEIF ParameterExists(Form.btnEdit_Cancel)>

	<CFIF ParameterExists(Form.RecordID)>
		<CFLOCATION url="Control_RecordView.cfm?RecordID=#Form.RecordID#">
	<CFELSE>
		<CFLOCATION url="Control_RecordView.cfm">
	</CFIF>

</CFIF>