Yeah, guess I am gonna have to use the CFIF option. SP's are not allowed on the DB2 server for the city. We are getting our own SQL Server and CF Server soon though, so I get to re-write the app using SP's.
Bruce On 1/24/07, Richard Kroll <[EMAIL PROTECTED]> wrote: > > > That is what I want, nulls. If no date is selected, then I do not want > > anything there. > > I would suggest using the CFQUERYPARAM tag and using its NULL attribute. > If not that then you will be forced to do a <CFIF myDate eq > ''>NULL<cfelse>#myDate#</cfif> > > Rich Kroll > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267499 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
