- see footer for list info -<
How can I put <cfif> in a stored procedure?
WHERE EventTypeIDFK = EventTypeIDPK
AND (StartDateTime BETWEEN #StartDate# AND #EndDateTime#
OR EndDateTime BETWEEN #StartDate# AND #EndDateTime#
OR #StartDate# BETWEEN StartDateTime AND EndDateTime)
<cfif IsDefined("URL.EventTypeID") AND IsNumeric(URL.EventTypeID)>
AND EventTypeIDFK = #URL.EventTypeID#
</cfif>
ORDER BY StartDateTime
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
