Well, you sure do. What a goofy thing. That's the whole idea of the null attribute. Ugh.
On 10/4/05, Dave Carabetta <[EMAIL PROTECTED]> wrote: > > Actually, the bug (which is in both MX 6.1 and MX 7.0.1) isn't with > the "null" attribute setting. The problem is if you pass in a blank > string to the "value" attribute when you specify list="true". If you > put in a dummy value for the "value" attribute while specifying > list="true" and null="true", then you'll get back an empty record set, > as you'd expect: > > <cfquery name="get" datasource="scott"> > SELECT * > FROM emp > WHERE empno IN (<cfqueryparam value="7369" cfsqltype="cf_sql_numeric" > list="true" null="true" />) > </cfquery> > > <cfdump var="#get#" /> > > Nice find though. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220019 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
