CFMX uses different database drivers to CF5 and different drivers allow / disallow different SQL syntax...
On Monday, Mar 24, 2003, at 11:24 US/Pacific, Dave Sueltenfuss wrote: > 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
