62 : <cfquery datasource=#application.datasource# name="mercantile">
63 : select cruise.cruiseid, cruise.startdate, cruise.cost, cruiseduration.cruiseduration, cruiseduration.daystext, cruise.full from cruise left join cruiseduration on cruise.cruisedurationid=cruiseduration.cruisedurationid
64 : where cruise.startdate < #createODBCDate(yearend)# and cruise.startdate > #createODBCDate(weekend)# and vesselid = 1 and cruise.active = 1 <cfif len(falllist)>and cruise.cruiseid not in (#falllist#)</cfif>
65 : order by cruiseduration.sortorder, cruise.startdate
66 : </cfquery>
|