> After a bit (!) of research, I am still a little confused about using > CFQUERYPARAM. > It is not in my SAMs Teach Yourself Coldfusion Express in 24 Hrs.
Probably not. I'm not sure CFQUERYPARAM exists in CF Express. CFQUERYPARAM was introduced around the same time that CF Express came out, but CF Express was not really very useful when it came out, and things have changed quite a bit since it came out, making it even less useful. It's not necessary for the completion of your exercises to use CFQUERYPARAM, but you would definitely want to use that in a "real" application. To learn more about CFQUERYPARAM, read the online CF 8 documentation and this Adobe Devnet article: http://www.adobe.com/support/documentation/en/coldfusion/ http://www.adobe.com/devnet/coldfusion/articles/cfqueryparam.html > Understand that CS_SQL_BIT can be 1 or 0. > But also found that msAccess CheckBox data can be 1,0 or NULL. NULL is the absence of a value. Any field can be set to allow NULL, unless the field is part of a unique index or something similar (identity columns, etc). 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:317268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
