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=subscribeforumid=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