Thanks for the info guys. That wasn't how I expected the attribute to work based on reading the documentation. Anyway, here is my cfqueryparam now for those who might still be confused:
<CFQUERYPARAM value="#theQuery.numberColumn#" cfsqltype="CF_SQL_NUMERIC" null="#NOT IsNumeric(theQuery.numberColumn)#">) Works like a champ, although it looks really weird though, doesn't it? Thanks again, Phil >> So Dave....what you've said looks like it will pass a NULL if >> the expression evaluates to YES and will pass the correct >> value if the expression evaluates to NO?? > >Yes. Dave Carabetta's example is pretty typical of what this usually looks >like. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200828 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
