|
sorry, this is the original query...
<cfquery datasource="#dsn#"
name="getdiary">
SELECT diary.id AS diaryid, diary.directoryid, diary.artform AS diaryartform, diary.*, directory.id AS directoryid, directory.fullname, directory.town, towns.id AS townid, towns.town AS town FROM diary, directory, towns WHERE diary.directoryid = directory.id AND directory.town = towns.id <cfif IsDefined("session.town")> AND directory.town = #session.town# </cfif> <cfif IsDefined("session.artform")> AND diary.artform = #session.artform# </cfif> AND (( diary.startdate >= #session.searchdatestart#) OR ( diary.enddate >= #session.searchdatestart#)) AND diary.publish = 'yes' ORDER BY diary.startdate, diary.enddate, diary.title </cfquery> |
