Re: CFMX Upgrade Issue and Solution

[Sean A Corfield]

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] 

~|
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

CFMX Upgrade Issue and Solution

[Dave Sueltenfuss]

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]  


~|
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