On 1/13/03, Jillian Carroll penned:
I am having a really weird problem... I do some calculations in CF, they
work on my development machine (Windows XP Home/Apache) but when I
upload them to my host (Windows 2000/IIS) they don't work. I get this
error... anybody able to help me on this one?
***
cfquery name=tools datasource=#dsn# username=jubilee
password=cds337
Better change your password now.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
why? do you know the DSN...?
-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 16:28
To: CF-Talk
Subject: RE: Cannot convert to number.
cfquery name=tools datasource=#dsn# username=jubilee
password=cds337
Better change your password now
No, but better safe than sorry.
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 11:32 AM
To: CF-Talk
Subject: RE: Cannot convert to number.
why? do you know the DSN...?
-Original Message-
From: Everett, Al
: RE: Cannot convert to number.
No, but better safe than sorry.
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 11:32 AM
To: CF-Talk
Subject: RE: Cannot convert to number.
why? do you know the DSN...?
-Original
I would have though you would need registry access? or object access?
-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 16:45
To: CF-Talk
Subject: RE: Cannot convert to number.
And as long as you can get a script on the server, can get a list
: Monday, January 13, 2003 8:43 AM
To: CF-Talk
Subject: RE: Cannot convert to number.
I would have though you would need registry access? or object access?
-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 16:45
To: CF-Talk
Subject: RE: Cannot
yeah, but both of these functions can be disabled via the CFAS IDE
-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 16:53
To: CF-Talk
Subject: RE: Cannot convert to number.
Yeah, would need to call an object. Not much for navigating the
registry
Yes,
I have had similar errors. Its usually when your query does not return a
numerical data where a number is expected.
Check your database--specially the rows in numerical columns. Replacing
null/empty numerical cells with 0 (zero) might solve your problem
HTH
Srimanta
are there any limitations or exceptions to nesting #var#'s?
Angel Stewart [EMAIL PROTECTED] on 11/19/2001 02:29:31 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: Cannot convert to number
OMG.
I feel like its all coming apart now.
Got hit with
What are exactly are you trying to do? What result are you expecting?
What's a typical value for attcode?
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 15:30
To: CF-Talk
Subject: Cannot convert to number
OMG.
I feel like its all
You can't use functions on the left-hand side of an assignment but this
might help you:
CFSET SUM_#attributes.attcode# = Evaluate(SUM_
attributes.attcode) + GetVacationDetails.RegHrs
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 15:30
12 matches
Mail list logo