";
			$pstmt1 = $this->conn->prepare($sql1);
			$rs1 = $this->conn->Execute($pstmt1, array($artistId));
			if ($rs1->EOF) {
				return null;
			}
			$list1 = $rs1->getArray();

			// new
			$sql2 = <<conn->prepare($sql2);
			$rs2 = $this->conn->Execute($pstmt2, array($artistId));
			if ($rs2->EOF) {
				return null;
			}
			$list2 = $rs2->getArray();
			$result = array_merge($list1, $list2);

			return $result;
		}		
		
		function findByEventId($eventId) {
			$sql = <<conn->prepare($sql);
			$rs = $this->conn->Execute($pstmt, array($eventId));
			if ($rs->EOF) {
				return null;
			}
			return $rs->getArray();
		}

		function isExsist ($eventId, $artistId)
		{
			$sql = <<conn->prepare($sql);
			$rs = $this->conn->Execute($pstmt, array($eventId, $artistId));
			$row = $rs->FetchRow();
			return $row['count'] ? true : false;
		}

		function insert($eventId, $artistId, $displayOrder = null,
										$isValid, $creator, $updater) {
			$sql = <<conn->prepare($sql);
			if ($this->conn->Execute($pstmt, array($data))) {
				return true;
			}
			return;
		}

		function update($eventId, $artistId, $displayOrder = null,
							$isValid, $updater) {
			$sql = <<conn->debug = true;
			$pstmt = $this->conn->prepare($sql);
			$this->conn->Execute($pstmt, $data);
		}
		
		function delete ($eventId, $artistId, $isValid) {
			$sql = <<conn->debug = true;
			$pstmt = $this->conn->prepare($sql);
			$this->conn->Execute($pstmt, array($eventId, $artistId, $isValid));
        }
	}
?>