Re: Has anyone seen this before? - documented bug?
Perhaps you have a variable called premium elsewhere in your code that has a non-simple value? On Wednesday, Oct 2, 2002, at 04:53 US/Pacific, Dave Wilson wrote: > Hi all, > > I've just been checking through our applications after upgrading from > CF4.5 > to CFMX and came across the following strange error. > > Basically I have a template which carries out various calculations to > determine insurance premiums for a vehicle. So my final output > variable is > simply called "premium" - Straightforward enough. > > When I run the template using CFMX, I get the following error message: > Complex object types cannot be converted to simple values. > The expression has requested a variable or an intermediate expression > result > as a simple value, however, the result cannot be converted to a simple > value. Simple values are strings, numbers, boolean values, and > date/time > values. Queries, arrays, and COM objects are examples of complex > values. > The most likely cause of the error is that you are trying to use a > complex > value as a simple one. For example, you might be trying to use a query > variable in a tag. This was possible in ColdFusion 2.0 but > creates an > error in later versions. > > > Now, when I went through my calculation steps, I found that by > changing the > variable name to ins_premium, everything worked fine. So, basically my > question is: > > Is "premium" a reserved word? If so, is it in fact a complex object as > suggested by the error message? Is this documented or should I be > submitting > it as a bug report? > > TIA, > Dave > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Has anyone seen this before? - documented bug?
Make sure you identify the scope of the variable. I had a variables.url I was calling successfully as url in CF5 but in CFMX it looks like they changed the look up sequence and URL causes issues so I had to explicitly use variables.url. Adam > -Original Message- > From: Sean A Corfield [mailto:[EMAIL PROTECTED]] > Sent: 02 October 2002 16:56 > To: CF-Talk > Subject: Re: Has anyone seen this before? - documented bug? > > > Perhaps you have a variable called premium elsewhere in your code that > has a non-simple value? > > On Wednesday, Oct 2, 2002, at 04:53 US/Pacific, Dave Wilson wrote: > > > Hi all, > > > > I've just been checking through our applications after upgrading from > > CF4.5 > > to CFMX and came across the following strange error. > > > > Basically I have a template which carries out various calculations to > > determine insurance premiums for a vehicle. So my final output > > variable is > > simply called "premium" - Straightforward enough. > > > > When I run the template using CFMX, I get the following error message: > > Complex object types cannot be converted to simple values. > > The expression has requested a variable or an intermediate expression > > result > > as a simple value, however, the result cannot be converted to a simple > > value. Simple values are strings, numbers, boolean values, and > > date/time > > values. Queries, arrays, and COM objects are examples of complex > > values. > > The most likely cause of the error is that you are trying to use a > > complex > > value as a simple one. For example, you might be trying to use a query > > variable in a tag. This was possible in ColdFusion 2.0 but > > creates an > > error in later versions. > > > > > > Now, when I went through my calculation steps, I found that by > > changing the > > variable name to ins_premium, everything worked fine. So, basically my > > question is: > > > > Is "premium" a reserved word? If so, is it in fact a complex object as > > suggested by the error message? Is this documented or should I be > > submitting > > it as a bug report? > > > > TIA, > > Dave > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Has anyone seen this before? - documented bug?
Right, URL is reserved, along with server, file, form, and a few others I can't remember off the top of my head. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Adam Reynolds [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 02, 2002 12:08 PM > To: CF-Talk > Subject: RE: Has anyone seen this before? - documented bug? > > > Make sure you identify the scope of the variable. > > I had a variables.url I was calling successfully as url in > CF5 but in CFMX > it looks like they changed the look up sequence and URL > causes issues so I > had to explicitly use variables.url. > > Adam > > > -Original Message- > > From: Sean A Corfield [mailto:[EMAIL PROTECTED]] > > Sent: 02 October 2002 16:56 > > To: CF-Talk > > Subject: Re: Has anyone seen this before? - documented bug? > > > > > > Perhaps you have a variable called premium elsewhere in > your code that > > has a non-simple value? > > > > On Wednesday, Oct 2, 2002, at 04:53 US/Pacific, Dave Wilson wrote: > > > > > Hi all, > > > > > > I've just been checking through our applications after > upgrading from > > > CF4.5 > > > to CFMX and came across the following strange error. > > > > > > Basically I have a template which carries out various > calculations to > > > determine insurance premiums for a vehicle. So my final output > > > variable is > > > simply called "premium" - Straightforward enough. > > > > > > When I run the template using CFMX, I get the following > error message: > > > Complex object types cannot be converted to simple values. > > > The expression has requested a variable or an > intermediate expression > > > result > > > as a simple value, however, the result cannot be > converted to a simple > > > value. Simple values are strings, numbers, boolean values, and > > > date/time > > > values. Queries, arrays, and COM objects are examples of complex > > > values. > > > The most likely cause of the error is that you are trying to use a > > > complex > > > value as a simple one. For example, you might be trying > to use a query > > > variable in a tag. This was possible in ColdFusion 2.0 but > > > creates an > > > error in later versions. > > > > > > > > > Now, when I went through my calculation steps, I found that by > > > changing the > > > variable name to ins_premium, everything worked fine. So, > basically my > > > question is: > > > > > > Is "premium" a reserved word? If so, is it in fact a > complex object as > > > suggested by the error message? Is this documented or should I be > > > submitting > > > it as a bug report? > > > > > > TIA, > > > Dave > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Has anyone seen this before? - documented bug?
I have seen same error message by migrating from CF5 to CXFMX. But in my case CFMX was playing up with GUIDs (in SQL Server). So rather than using JDBC ODBC bridge, I chose Microsoft SQL Server when adding DSN. And it works perfect. -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: 02 October 2002 12:54 To: CF-Talk Subject: Has anyone seen this before? - documented bug? Hi all, I've just been checking through our applications after upgrading from CF4.5 to CFMX and came across the following strange error. Basically I have a template which carries out various calculations to determine insurance premiums for a vehicle. So my final output variable is simply called "premium" - Straightforward enough. When I run the template using CFMX, I get the following error message: Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a tag. This was possible in ColdFusion 2.0 but creates an error in later versions. Now, when I went through my calculation steps, I found that by changing the variable name to ins_premium, everything worked fine. So, basically my question is: Is "premium" a reserved word? If so, is it in fact a complex object as suggested by the error message? Is this documented or should I be submitting it as a bug report? TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Has anyone seen this before? - documented bug?
We received this error as well while moving from CF5 to MX. We have not found a fix yet (or even found the problem) we do not use JDBC, we go straight to SQL server as Shahzad is doing; however this error still happens. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:17 AM To: CF-Talk Subject: RE: Has anyone seen this before? - documented bug? I have seen same error message by migrating from CF5 to CXFMX. But in my case CFMX was playing up with GUIDs (in SQL Server). So rather than using JDBC ODBC bridge, I chose Microsoft SQL Server when adding DSN. And it works perfect. -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: 02 October 2002 12:54 To: CF-Talk Subject: Has anyone seen this before? - documented bug? Hi all, I've just been checking through our applications after upgrading from CF4.5 to CFMX and came across the following strange error. Basically I have a template which carries out various calculations to determine insurance premiums for a vehicle. So my final output variable is simply called "premium" - Straightforward enough. When I run the template using CFMX, I get the following error message: Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a tag. This was possible in ColdFusion 2.0 but creates an error in later versions. Now, when I went through my calculation steps, I found that by changing the variable name to ins_premium, everything worked fine. So, basically my question is: Is "premium" a reserved word? If so, is it in fact a complex object as suggested by the error message? Is this documented or should I be submitting it as a bug report? TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm