SELECT agency_id FROM Agency WHERE agency_id = #URL.prefix_db_agency_id# or agency_login = #URL.prefix_db_agency_id# limit 1
SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'agency_#get_Agency.agency_id#'
SELECT *,'' AS coding_wizard FROM #Request.prefix_db_lookup#.Agency WHERE Agency_Id = '#session.AgencyId#'
SELECT Agency.* FROM #Request.prefix_db_lookup#.pEmployee
JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_ID = pEmployee.Loc_ID
WHERE pEmployee.Username = '#session.username#'
AND pEmployee.status = 0 AND Agency.status = 'active'
Form Variables: URL Variables: Request Variables: Session Variables: