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:
Using a data type: "number" field size: "Long Integer" throws an error "Database reported: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented" if the cfsqltype is "CF_SQL_INTEGER". If I change the cfsqltype to "CF_SQL_NUMERIC" it works fine. Another example: A SQL Server, MySQL, ect. field data type varchar(500) with cfqueryparam set as follows: <cfqueryparam value="#Comments#" cfsqltype="CF_SQL_VARCHAR" maxlength="500"> works fine in SQL Server, MySQL, ect., but breaks in Access. If I remove the maxlength="500" it works. I know most will agree Access is from the database of choice, so my question is should we support Access considering the challenge, or drop support? To be honest, I cannot imagine a forum actually being used in a production environment using Access. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:208817 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
