Good afternoon, I just upgraded my production web server to CFMX Pro this past weekend, and encountered an interesting error I wished to share with the group
On of the functions that we use CF for is web based reporting from the Lawson Financial Package, including a PO Printout form. Before the upgrade, the PO Print worked without any issues. After the upgrade, certain PO's would not printout for us, and instead returned the following error. Error Executing Database Query.[MERANT][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC]Restricted data type attribute violation. The specific sequence of files included or processed is: C:\Inetpub\wwwroot\Dev\Lawson\poscreen.cfm As you can see, the error message does not make much sense. We went so far as to restore the Test server to CF 5 and make sure that the page worked properly on the previous version. After much research, we found that the error was linked to the case statement below. CASE when lawson.poline.taxable_flag = 'Y' Then (((lawson.poline.tax_code/100)*lawson.poline.taxbl_unt_cst)* lawson.poline.quantity) End as taxamt The statement above does not include an else statement. For some reason, CF 5 Pro did not care about this, but CF MX was returning an error, even though the page compiled fine. Once the else statement was added, the problem went away. I just wanted to share this issue and solution with the group, in case anyone else comes across a similar issue Any questions, please let me know Thanks Dave Sueltenfuss Application Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
