******************************************************************************** there are four different files on this page. they will each be seperated by a large block of text like this one... ******************************************************************************** SELECT payee_id, payee_first_name, payee_last_name FROM payee WHERE payee_id > 1 ORDER BY payee_last_name, payee_first_name SELECT elements_of_time.corp_id, elements_of_time.created_by_id, elements_of_time.element_start_date, elements_of_time.general_title, elements_of_time.time_id, CONCAT(payee.payee_first_name, " ", payee.payee_last_name) AS user, corporations.corp_name FROM elements_of_time, payee, corporations WHERE payee.payee_id = elements_of_time.created_by_id AND corporations.corp_id = elements_of_time.corp_id AND elements_of_time.corp_id > 1 ORDER BY payee.payee_first_name, payee.payee_last_name, elements_of_time.time_id DESC Elements of Time Homepage

Elements of Time Homepage

add a new element of time

Corporation
Time Id
Date Title Created By Links
#qryGetAllTimeData.corp_name#
#qryGetAllTimeData.time_id#
#DateFormat(qryGetAllTimeData.element_start_date, "m/d/yy")# #qryGetAllTimeData.general_title# #qryGetAllTimeData.user# edit view
*************************************************************************************** below this is page 2... ***************************************************************************************

Missing a numeric corp id number. Unable to proceed.

Missing a numeric time id number. Unable to proceed.

 SELECT elements_of_time.corp_id, elements_of_time.created_by_id, elements_of_time.element_start_date, elements_of_time.general_title, elements_of_time.time_id, corporations.corp_name FROM elements_of_time, corporations WHERE corporations.corp_id = elements_of_time.corp_id AND elements_of_time.corp_id = #Trim(URL.corp)# AND elements_of_time.time_id = #Trim(URL.id)#

Unable to find a matching record. Please check your values and try again.

 SELECT payee_id, payee_first_name, payee_last_name FROM payee WHERE payee_id > 1 ORDER BY payee_last_name, payee_first_name SELECT corp_id, corp_name FROM corporations WHERE corp_id > 1 ORDER BY corp_name Add/Edit Main Element of Time

Add/Edit Main Element of Time

Id:
#variables.time_id#
Date:
* (use m/d/yy format)
Title:
*
Created By:
*
Corporation:
* #variables.useCorpName#
 
*************************************************************************************** below this is page 3... ***************************************************************************************

Missing a valid date value. Unable to proceed.

Missing a valid title. The value needs at least two characters in order to proceed.

Choose a user from the list provided. Unable to proceed.

Choose a corporation from the list provided. Unable to proceed.

 SELECT MAX(time_id) AS max_time_id FROM elements_of_time WHERE corp_id = #Trim(FORM.corp_id)# INSERT INTO elements_of_time (corp_id, created_by_id, element_start_date, general_title, time_id) VALUES (#Trim(FORM.corp_id)#, #Trim(FORM.created_by_id)#, #CreateODBCDate(FORM.element_start_date)#, '#Trim(FORM.general_title)#', #variables.newTimeId#)

Missing a valid time id number. Unable to proceed.

 UPDATE elements_of_time SET created_by_id = #Trim(FORM.created_by_id)#, element_start_date = #CreateODBCDate(FORM.element_start_date)#, general_title = '#Trim(FORM.general_title)#' WHERE corp_id = #Trim(FORM.corp_id)# AND time_id = #Trim(FORM.time_id)# *************************************************************************************** below this is page 4... ***************************************************************************************

Missing a numeric corp id number. Unable to proceed.

Missing a numeric time id number. Unable to proceed.

 SELECT elements_of_time.corp_id, elements_of_time.created_by_id, elements_of_time.element_start_date, elements_of_time.general_title, elements_of_time.time_id, CONCAT(payee.payee_first_name, " ", payee.payee_last_name) AS user, corporations.corp_name FROM elements_of_time, payee, corporations WHERE payee.payee_id = elements_of_time.created_by_id AND corporations.corp_id = elements_of_time.corp_id AND elements_of_time.corp_id = #Trim(URL.corp)# AND elements_of_time.time_id = #Trim(URL.id)#

Unable to find a matching record. Please check your values and try again.

 Working With Time

Working With Time

time homepage . add a new element of time . edit or update current

Id:
#qryGetElementData.time_id#
Date:
#DateFormat(qryGetElementData.element_start_date, "m/d/yy")#
Title:
#qryGetElementData.general_title#
Created By:
#qryGetElementData.created_by_id# AKA #qryGetElementData.user#
Corporation:
#qryGetElementData.corp_id# AKA #qryGetElementData.corp_name#