> -----Original Message----- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 07, 2005 12:13 PM > To: CF-Talk > Subject: Should we support Access? > > As many of you know from my previous posts we have had a forums > application > in beta testing for a while. It was developed primarily using SQL Server > and > MySQL, but wanted to offer support for Access & PostgreSQL, but have found > Access a pain to support. The problem is with cfqueryparam throws errors > with Access because the cfsqltype in many cases is not the same for Access > as it is for the other databases. For example:
For me it would depend on how easy it is to change DBs. I prefer to put all my DB logic in distinct "broker" components - a separate "library" for each persistence layer. In this case, considering the problems you've described, I could just not use CFQUERY param for the Access brokers (or figure out the types) and it wouldn't affect anything else. By the same token you create a broker layer to access LDAP or XML files rather than a database if you wanted to - none of the other code changes. If possible I would try to support Access for a "commercial" project. For several reasons: 1) Before buying or implementing a lot of people like to set up a "playground" first - for a lot of Windows CF developers they use Access for this evaluation. 2) By the same token Access is often used as a cheap development environment. 3) There are still people building tiny intranet applications who use nothing but Access. To be honest there are still people building big Internet applications using Access. ;^) But if it's hard to add support then don't - wait for a request or three. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208854 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
