> I have been searching for some explanation of > the different Types used in CFQueryParam. > > understand that SCALE= is used to validate the position of decimal, > but still confused by ... FLOAT, DECIMAL, MONEY, MONEY4.
These correspond with specific database field types. You'd need to know what your database is looking for to choose the most appropriate data type in CF. That said, you can usually use FLOAT with any floating point database field, but it won't give you the same level of precision that the more specific types provide. > I am using <CFquery > INSERT > do I need to use <CFQueryParam > for all values ? Any time you use user-supplied values in a query, you should use CFQUERYPARAM. It doesn't matter whether it's an INSERT, UPDATE, DELETE or SELECT. 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 inf ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
