|
|
| Date | Title | Time | Location | select id as recid,
start_date, DATE_FORMAT(start_date,'%m/%d/%y') as Start_Date,
DATE_FORMAT(end_date,'%m/%d/%y') as End_Date,
date_tba as Date_TBA, time_tba as Time_TBA,
TIME_FORMAT(start_time,'%l:%i %p') as Start_Time,
TIME_FORMAT(end_time,'%l:%i %p') as End_Time,
headline as Headline, event_type, place, event_desc
from events where (dept_code = "67") and (event_cat="Any") and (tentative=0) and (end_date >= '2009-11-21')
UNION
select id as recid, start_date, DATE_FORMAT(start_date,'%m/%d/%y') as Start_Date,
DATE_FORMAT(end_date,'%m/%d/%y') as End_Date,
date_tba as Date_TBA, time_tba as Time_TBA,
TIME_FORMAT(start_time,'%l:%i %p') as Start_Time,
TIME_FORMAT(end_time,'%l:%i %p') as End_Time,
headline as Headline, event_type, place, event_desc
from events_arch where (dept_code = "67") and (event_cat="Any") and (tentative=0) and (end_date >= '2009-11-21') order by start_date asc
Error:
Cannot Create Events SP...
SOH Home
|
