I'm having weird intermittend division by 0 errors that I think might be
related to multiple instances. The crash supposedly happens on
application.cfm line 7, which is just your basic cfapplication tag.
/ by zero
The error occurred in W:\rise\cf\www
: division by 0 error
I'm having weird intermittend division by 0 errors that I think might be
related to multiple instances. The crash supposedly happens on
application.cfm line 7, which is just your basic cfapplication tag.
/ by zero
The error occurred in W
(
return code;
code = (code + 1) % keys.length;
}
throw new IllegalStateException();
}
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 11:04 AM
To: CF-Talk
Subject: RE: division by 0 error
Sorry. I'm lost in stack traces. Wish I could help more.
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 11:44 AM
To: CF-Talk
Subject: RE: division by 0 error
Nope
.
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 11:44 AM
To: CF-Talk
Subject: RE: division by 0 error
Nope... no includes.
From the strack trace it looks like it has
suggest a workaround until a fix is implemented?
Russ
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 12:26 PM
To: CF-Talk
Subject: Re: division by 0 error
We've been seeing a bit of these too. On login to apps and apps where
no math
Did you set up your instances through the cf admin as well?
I've been hearing that that's not the best way to do it and
it's better to do it through jrun admin... I'll try that and
see if it fixes it...
There's nothing wrong with setting up instances through the CF
Administrator. However,
From the strack trace it looks like it has something to do
with J2EE sessions. The error also seems to only happen when
more then 1 instance is running, so perhaps something with
session replication? I set up the cluster using cf admin,
could that be a problem? Should I be using J2EE
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 12:54 PM
To: CF-Talk
Subject: RE: division by 0 error
From the strack trace it looks like it has something to do
with J2EE sessions. The error also seems to only happen when
more
If I only use 1 instance, everything is fine. Once I have
more then 1 instance in the cluster, the error happens randomly.
I'm not sure the exact reason we're using client variables.
It's a big system and I haven't played with that part of the
code yet.
In my test example the
But the error doesn't happen right away, right? Can you trap what's in
the
Session scope prior to the error?
The session scope wouldn't exist before the cfapplication tag, would
it??
~Brad
~|
Introducing the Fusion Authority
: Friday, December 01, 2006 1:31 PM
To: CF-Talk
Subject: RE: division by 0 error
If I only use 1 instance, everything is fine. Once I have
more then 1 instance in the cluster, the error happens randomly.
I'm not sure the exact reason we're using client variables.
It's a big system
I'm not sure how... The error doesn't always happen on the
same action.
Use onRequestEnd/onRequestEnd.cfm to log your session data?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers
-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 1:51 PM
To: CF-Talk
Subject: RE: division by 0 error
I'm not sure how... The error doesn't always happen on the
same action.
Use onRequestEnd/onRequestEnd.cfm to log your session data?
Dave Watts, CTO, Fig
?
Russ
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 2:10 PM
To: CF-Talk
Subject: RE: division by 0 error
I found a workaround. Basically I put cfapplication in a try catch block,
and if it fails, I force the jsessionid cookie to expire
...
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_17479
So my question is what is the correct way to kill a session?
Russ
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 2:22 PM
To: CF-Talk
Subject: RE: division by 0 error
advanced coldfusion programmer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 1:42 PM
To: CF-Talk
Subject: RE: Solved: division by 0 error
I think I got it. On logout, we
#2 would be nice... I think the technote explains how to do structclear
without killing the session...
Russ
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 2:55 PM
To: CF-Talk
Subject: RE: Solved: division by 0 error
So my question
instances.
Russ
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Friday, December 01, 2006 3:13 PM
To: CF-Talk
Subject: RE: Solved: division by 0 error
If you clear SESSION itself you're asking for trouble.
Try adding one additional level to the SESSION scope
It's interesting that this issue has not come up until we
deployed multiple instances.
My guess is that it's the session replication of an empty session object
that's causing the problem.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest
do the division.
SELECT ((COALESCE(query1,0)) + (COALESCE(query2,0)) / 2)
--
Jim Wright
Wright Business Solutions
[EMAIL PROTECTED]
919-417-2257
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245180
Archives: http
Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]
Sent: Friday, 17 June 2005 12:15 p.m.
To: CF-Talk
Subject: A Test for Division by Zero a SQL Query...
Select (Indx.Inv/Indx.Net_Exp_Starts) AS Yield from Indx Blows up when
Net_Exp_Starts = 0 with a Division by Zero SQL Error
Select (Indx.Inv/Indx.Net_Exp_Starts) AS Yield from Indx Blows up when
Net_Exp_Starts = 0 with a Division by Zero SQL Error in postgreSQL
and MSSQL.
Does anyone know how can I return 0 as the yield when the divisor is 0?
Thanks s much,
Gonz
What is your DB?
On 6/16/05, Gonzo Rock [EMAIL PROTECTED] wrote:
Select (Indx.Inv/Indx.Net_Exp_Starts) AS Yield from Indx Blows up when
Net_Exp_Starts = 0 with a Division by Zero SQL Error in postgreSQL
and MSSQL.
Does anyone know how can I return 0 as the yield when the divisor is 0
for Division by Zero a SQL Query...
Select (Indx.Inv/Indx.Net_Exp_Starts) AS Yield from Indx Blows up when
Net_Exp_Starts = 0 with a Division by Zero SQL Error in postgreSQL
and MSSQL.
Does anyone know how can I return 0 as the yield when the divisor is 0?
Thanks s much,
Gonz
]
Sent: Friday, 17 June 2005 12:15 p.m.
To: CF-Talk
Subject: A Test for Division by Zero a SQL Query...
Select (Indx.Inv/Indx.Net_Exp_Starts) AS Yield from Indx Blows up when
Net_Exp_Starts = 0 with a Division by Zero SQL Error in postgreSQL
and MSSQL.
Does anyone know how can I return 0
division drops the decimal?
The division operator returns an INT according to the T-SQL reference.
It also says that the division operator drops the remainder. The data
comes from a NUMERIC field and I'm storing the value into a
VARCHAR(10)
field so that's not the problem, it just drops
The numeric field where the result is stored does make a difference, but
the 2 is in your division is making the difference below. If you want a
decimal result then you must divide by a decimal.
I tried one using: newcolumn = '' +mycolumn/2+ '.' +mycolumn%2+ ''
0 = 1/2 / 2
1/4 = 1/2 / 2.0
How do others on the list deal with this?
I have a query that takes a value from the database and divides by 2 and
inserts that value into another table, however SQL Server (T-SQL) drops
the decimal place, so 1/2 of 1 is 0 according to T-SQL.
Any idea how to overcome this? That seems really
It's the datatype of the column your holding your information in. Check the
Docs for the correct datatype.
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 11:15 AM
To: CF-Talk
Subject: T-SQL division drops the decimal?
How do others
To: CF-Talk
Subject: T-SQL division drops the decimal?
How do others on the list deal with this?
I have a query that takes a value from the database and divides by 2 and
inserts that value into another table, however SQL Server (T-SQL) drops
the decimal place, so 1/2 of 1 is 0 according to T
I think it depends on the datatypes you're using as inputs to the division
calculation, if they are integers then it does have problems, you could try
using:
(CAST(myfield AS float))/(CAST(myfield2 AS float)) if myfield1 and myfield2
are integers
Alex
-Original Message-
From: Joshua
Would it be because it's an integer? You may need to use CAST() or
CONVERT().
Ade
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]
Sent: 31 July 2003 16:15
To: CF-Talk
Subject: T-SQL division drops the decimal?
How do others on the list deal with this?
I have a query
Joshua,
MS SQL automatically returns the type you use. Looks to me like you are
dividing 2 integers.
You need to cast or convert at least one of the numbers to float to get a
float returned.
This got to be such a pain for me that I wrote a function to do the division
(MSSQL 2000).
It converts
I have a query that takes a value from the database and divides by 2 and
inserts that value into another table, however SQL Server (T-SQL) drops
the decimal place, so 1/2 of 1 is 0 according to T-SQL.
you're telling sql server to divide 2 int, it returns what you asked of it,
an int. i always
The division operator returns an INT according to the T-SQL reference.
It also says that the division operator drops the remainder. The data
comes from a NUMERIC field and I'm storing the value into a VARCHAR(10)
field so that's not the problem, it just drops the remainder by default.
I tried one
changes to INT when
doing division. Bizarre.
Thanks for the assistance!
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-0801 ext. 254
looks like a float it will return a float.
Mark
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 12:04 PM
To: CF-Talk
Subject: RE: T-SQL division drops the decimal?
Thanks all for the help, this is what ended up working:
icode=(CAST
Thought I would post a link to this news as many ColdFusion developers are
devoted WebSite customers.
http://software.oreilly.com/news.cfm?ID_News=200
They posted a message onto WS-Talk on the 6th... loads of discussion since
then...
Philip Arnold
Director
Certified ColdFusion Developer
ASP
On 3/7/01, Benjamin S. Rogers penned:
Thought I would post a link to this news as many ColdFusion developers are
devoted WebSite customers.
http://software.oreilly.com/news.cfm?ID_News=200
Bummer. They're looking for a buyer. Maybe Macrollaire will pick them up. :-D
--
Bud Schneehagen -
Thought I would post a link to this news as many ColdFusion
developers are devoted WebSite customers.
http://software.oreilly.com/news.cfm?ID_News=200
Bummer. They're looking for a buyer. Maybe Macrollaire will pick
them up. :-D
Taking this seriously (even though it's not) - they
Feel sorry for the 9 people that got laid off, kinda poor planning on
O'Reilly's part,
Just my 2cents
Michael
"Benjamin S. Rogers" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Thought I would post a link to this news as many ColdFusion developers are
On 3/8/01, Philip Arnold - ASP penned:
Taking this seriously (even though it's not) - they wouldn't as there
currently is no support in ClusterCats for WSP, so if they did buy the
product then they'd have to include it...
Sounds like I should cancel my order for WSP 3 and migrate to IIS
while I
Sounds like I should cancel my order for WSP 3 and migrate to IIS
while I still only have 100 or so sites to switch.
And then spend 3 hours a week making sure you have the latest vunerabilities
patched...
Oh, and have to re-buy all of your certificates
And have to retrain all of your
You can migrate a Verisign cert for $100.
Cary
At 02:55 PM 3/8/2001 +, you wrote:
Oh, and have to re-buy all of your certificates
Cary Gordon
The Cherry Hill Company
~~
Structure your ColdFusion code with Fusebox. Get the official book
Oh, and have to re-buy all of your certificates
You can migrate a Verisign cert for $100.
Yeah, but it's still re-buying - a Thawte Cert only costs $100 to begin
with...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the
On 3/8/01, Philip Arnold - ASP penned:
And then spend 3 hours a week making sure you have the latest vunerabilities
patched...
Oh, and have to re-buy all of your certificates
And have to retrain all of your web-admins who use the WSP interface
Yeah, I get your point. I really like Website
Sounds like I should cancel my order for WSP 3 and migrate to IIS
while I still only have 100 or so sites to switch.
And then spend 3 hours a week making sure you have the latest
vulnerabilities patched...
Now, I like WebSite, but this isn't really a fair criticism. IIS
vulnerabilities
Now, I like WebSite, but this isn't really a fair criticism. IIS
vulnerabilities typically only affect you when you haven't properly set it
up in the first place. For example, lots of them depend on ISAPI mappings
that no one is using. If they're not being used, they shouldn't be left in
On 3/8/01, Dave Watts penned:
Also, just because more IIS vulnerabilities are publicly known, doesn't mean
that IIS is inherently less secure than WebSite. There are simply fewer
people poking into WebSite looking for vulnerabilities, since there are
fewer people using WebSite.
Kind of like why
Thought I would post a link to this news as many ColdFusion developers are
devoted WebSite customers.
http://software.oreilly.com/news.cfm?ID_News=200
Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057
~~
It turned it into "1" because in CF the "backwards" slash is the integer
division operator. (very confusing imho -- why not use DIV as some other
languages do?) I've asked my programmers to ALWAYS comment their code when
using this operator to prevent future confusion fac
This was suppose to be easy...
I'm trying to divide a recordcount by 100 and then round up. Currently my
recordcount is 162 and i'm using the ceiling function to round up but it
keeps giving me 1. I've tried using number format and decimal format with no
luck. Any suggestions? Code below:
cfset
You're using the wrong division symbol!
/ returns a regular division
\ returns the integer result of a regular division, that means ... no
decimals!
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 9:02
Try using cfset temp = decimalFormat(getdealers.recordcount/100)
Sincirely
Tom Espen Pedersen
developer
www.pixelduck.com
- Original Message -
From: "Rick Lamb" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 6:02
CFSET varname = #Round(getdealers.recordcount/100)#
or
CFSET varname = #Round(Evaluate(getdealers.recordcount/100))#
should work fine.
-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 9:02 AM
To: CF-Talk
Subject: division
Rick,
The division operator in your first line of code is the wrong slash. I'm
not sure why, but CF apparently turns that whole thing into "1". Strange.
I reproduced the same problem on my end. Flipping that slash fixes it.
Matthieu
-Original Message-
From: [EMAIL
: division
This was suppose to be easy...
I'm trying to divide a recordcount by 100 and then round up. Currently my
recordcount is 162 and i'm using the ceiling function to round up but it
keeps giving me 1. I've tried using number format and decimal format with no
luck. Any suggestions? Code below
Try this:
cfset temp = getdealers.recordcount * 0.01
cfset variables.totalpages = ceiling(temp)
"/" strips the decimal part
stas
- Original Message -
From: "Rick Lamb" [EMAIL PROTECTED]
This was suppose to be easy...
I'm trying to divide a recordcount by 100 and then round up.
Honestly, I can't imagine what it might mean outside Australia, but down
here it's very bad manners to "point your slash" the wrong way (and very
messy).
(Sorry about that)
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-Original Message-
From: [EMAIL PROTECTED]
Hey, are my messages getting through to you? I have my doubts.
-Original Message-
From: BORKMAN Lee
Honestly, I can't imagine what it might mean outside Australia, but down
here it's very bad manners to "point your slash" the wrong way (and very
messy).
(Sorry about that)
Lee
Can anyone tell me what may be causing this error?
Error Diagnostic Information
ODBC Error Code = 22012 (Division by zero)
[Microsoft][ODBC Microsoft Access 97 Driver]Division by zero (null)
I am not performing any mathematical operations, nor do I have anything in
my CF code that would
PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: division by zero error?
Date: Fri, 15 Sep 2000 16:39:52 GMT
Can anyone tell me what may be causing this error?
Error Diagnostic Information
ODBC Error Code = 22012 (Division by zero)
[Microsoft][ODBC Microsoft Access 97 Drive
PROTECTED]
Subject: division by zero error?
Can anyone tell me what may be causing this error?
Error Diagnostic Information
ODBC Error Code = 22012 (Division by zero)
[Microsoft][ODBC Microsoft Access 97 Driver]Division by zero (null)
I am not performing any mathematical operations, nor do I hav
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 12:40 PM
To: [EMAIL PROTECTED]
Subject: division by zero error?
Can anyone tell me what may be causing this error?
Error Diagnostic Information
ODBC Error Code = 22012 (Division by zero)
[Microsoft][ODBC
a/Hyperion) |
| Subject: division by zero error? |
|
Can anyone tell me what may be causing this error?
Error Diagnostic Information
ODBC Error Code = 22012 (Division by zero)
[Micro
It is your date!
It is probably formated like 09/00/00
This would look like division. Make sure there are not quotes around yor
date field. Also using the CreatODBCDate() is a good function to use when
inserting dates.
- Original Message -
From: "Terri Stocke" [EMAIL
This is a multi-part message in MIME format.
--=_NextPart_000_009B_01C01F38.A0432B00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
division by zero error?This right here:
#dateformat(Now(), 'mm/dd/yy')#,
Is what is causing your problem.
* -Original Message-
* From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
* Sent: Wednesday, August 23, 2000 2:50 PM
* To: [EMAIL PROTECTED]
* Subject: RE: Division in Cold Fusion?
*
*
* Just like you did but you're using the wrong slash it should be.
*
* CFSET MYVAL = thisval / thatval
I must be looking at all the wrong stuff... but I want to take 2 values and
divide them.
like:
cfset myval = #thisval# \ #thatval#
Is there a correct way to do this?
Thanks,
Pete
--
Archives:
ity
[EMAIL PROTECTED]
(740) 597-2524
- Original Message -
From: "Peter Benoit" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 23, 2000 2:33 PM
Subject: Division in Cold Fusion?
I must be looking at all the wrong stuff... but I want to take 2 values and
divide
]' [EMAIL PROTECTED]
Date: Wednesday, August 23, 2000 2:37 PM
Subject: Division in Cold Fusion?
I must be looking at all the wrong stuff... but I want to take 2 values and
divide them.
like:
cfset myval = #thisval# \ #thatval#
Is there a correct way to do this?
Thanks,
Pete
2000 11:33 AM
To: '[EMAIL PROTECTED]'
Subject: Division in Cold Fusion?
I must be looking at all the wrong stuff... but I want to take 2 values and
divide them.
like:
cfset myval = #thisval# \ #thatval#
Is there a correct way to do this?
Th
The backwards slash will divide and truncate the remainder, ie: it is an INTEGER
divide.
Use the normal / if you want to just divide.
At 02:33 PM 8/23/00 -0400, Peter Benoit wrote:
I must be looking at all the wrong stuff... but I want to take 2 values and
divide them.
like:
cfset myval =
: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
* Sent: Wednesday, August 23, 2000 2:50 PM
* To: [EMAIL PROTECTED]
* Subject: RE: Division in Cold Fusion?
*
*
* Just like you did but you're using the wrong slash it should be.
*
* CFSET MYVAL = thisval / thatval
*
* BTW you also don't need #'s
To: '[EMAIL PROTECTED]'
Subject: RE: Division in Cold Fusion?
Thanks for all the help with this one. One final question would be, is
there a way to round the results of this to say 2 decimal places?
It's hard to find what you're looking for when you don't know what you're
looking for! :)
Thanks
I must be looking at all the wrong stuff... but I want to take 2
values and divide them.
like:
cfset myval = #thisval# \ #thatval#
Is there a correct way to do this?
You have the wrong slash
cfset myval = thisval / thatval
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
On 8/23/00, Peter Benoit penned:
cfset myval = #thisval# \ #thatval#
Use a forward slash.
Geesh, you Windows people. LOL
Oh, you shouldn't use the pound signs inside a cfset either. Just
don't put double or single quotes around them and CF will know
they're variables.
--
Bud Schneehagen -
Well the backslash I saw somewhere (no can't remember where) and it worked,
just not the way I expected it to.
* -Original Message-
* From: Bud [mailto:[EMAIL PROTECTED]]
* Sent: Wednesday, August 23, 2000 3:30 PM
* To: [EMAIL PROTECTED]
* Subject: Re: Division in Cold Fusion
I must be looking at all the wrong stuff... but I want to take 2 values and
divide them.
Try:
cfset myval = evaluate(thisval/thatval)
Rob Keniger
--
Archives:
80 matches
Mail list logo