> 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 calib
d multiple
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
#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 err
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 were using structClear(session), and while
working on a workaround, I coincidentally came to the livedocs for
structClear, which mention never to use it on se
> So my question is what is the correct way to kill a session?
If you simply want to disconnect the session from the user's browser, just
delete the session cookie and let the session itself expire normally. If
you're concerned about memory usage, you could delete everything from the
session that'
> This is what I'm using as a workaround
>
>
>clientmanagement="Yes"
> sessionmanagement="Yes"
> setclientcookies="No"
> sessiontimeout="#CreateTimeSpan(0,2,0,0)#"
> clientstorage="myclientdsn">
>isDefined("session")> var="#session#">session is not defined
s bad...
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:
ilto:[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 and redirect them
> to the
Message-
> 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/o
> 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
ilto:[EMAIL PROTECTED]
> Sent: 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 no
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 Q
> 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
> -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
> 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 J2
> 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. Howev
r this is a bug or not and perhaps
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 bee
races. 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
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.
key ||
sKey.equalsIgnoreCase(k.toString(
return code;
code = (code + 1) % keys.length;
}
throw new IllegalStateException();
}
> -Original Message-
> From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 01, 2006 1
: 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
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\c
pendent
> queries and have CF 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.co
have two independent
queries and have CF do the division.
Additionally, query1 or query2 may return NULL its totally random.
Thanks,
Brian
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245167
Archives: http
ELSE 0
> END AS Yield
>
> -Original 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
sage-
> 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 Z
est 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,
G
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 yiel
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
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+ ''
Subject: RE: T-SQL 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)
ints/2.0
Since "2.0" 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 wha
e it is it always 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-080
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
> 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 alway
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
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
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-
> F
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 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
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 o
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 odd
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 w
> 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
>
> > 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
vulnerabil
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
> >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
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 a
> 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 web-ad
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
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
>
> >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) - th
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 - Tr
> 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
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
~~
Structu
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 confusio
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 (Bjork)
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] [mailto:[
Try this:
"/" 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. Currently my
> recordcount is 162 and i'm using the ceiling function to round up
bject: 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 sug
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-
> F
or
should work fine.
-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 9:02 AM
To: CF-Talk
Subject: division
This was suppose to be easy...
I'm trying to divide a recordcount by 100 and then round up. Currently my
recordcount i
forward ( / ) slash not back ( \ ) slash
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 12:02 PM
To: CF-Talk
Subject: division
This was suppose to be easy...
I'm trying to divide a recordcount by 100 and then rou
Try using
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 PM
Subject: division
> This was suppose to be
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
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:
Tha
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
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 P
| cf-talk |
|| |
|+--->
>|
||
| To: [EMAIL PROTECTED]|
| cc: (bcc: Mary Baotic/na/Hyperion) |
| Subject:
nal Message-
> 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
>
> O
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 Microsoft Access 97 Driver]Division by zero (null)
I am not performing any mathematical operations, no
t; <[EMAIL 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
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
;* 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.
>*
>*
>*
>* BTW you also don't need #'s in set's
>I must be looking at all the wrong stuff... but I want to take 2 values and
>divide them.
Try:
Rob Keniger
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http:
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 F
On 8/23/00, Peter Benoit penned:
>
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 - Tropical Web Creations
_/_/_/_/_/_
: '[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
> I must be looking at all the wrong stuff... but I want to take 2
> values and divide them.
>
> like:
>
>
>
> Is there a correct way to do this?
You have the wrong slash
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**
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.
*
*
*
* BTW you also don't need #&
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:
>
>
>
>Is ther
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:
Is there a correct way to do this?
Thanks,
Pete
---
IL 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:
>
>
>
>Is th
) 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 them.
like:
I
I must be looking at all the wrong stuff... but I want to take 2 values and
divide them.
like:
Is there a correct way to do this?
Thanks,
Pete
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Un
84 matches
Mail list logo