you can use aif control and if ID is null then its value is equal to 0.but firstly you must define a int variable and you use it for ID's value.
Sam Fisher [EMAIL PROTECTED] wrote:
Hi Everyone,
Can someone tell be why I get a string convert error.I have tried setting up ID to Val(ID) and even
Hi Everyone,
Can someone tell be why I get a string convert error.I have tried setting up ID to Val(ID) and even IncrementValue(Val(ID)), but all it ever returns is either 0 or 1, respectively.Apparently ID is not getting converted.I feel like I'm taking crazy pills!What is wrong with converting a
cannot convert to number
Hi Everyone,
Can someone tell be why I get a string convert error.I have tried setting up ID to Val(ID) and even IncrementValue(Val(ID)), but all it ever returns is either 0 or 1, respectively.Apparently ID is not getting converted.I feel like I'm taking crazy pills!What
PROTECTED]
Sent: Monday, December 01, 2003 12:32 PM
To: CF-Talk
Subject: value cannot convert to number
Hi Everyone,
Can someone tell be why I get a string convert error.I have tried
setting up ID to Val(ID) and even IncrementValue(Val(ID)), but all it ever
returns is either 0 or 1
Original Message:
From: Sam Fisher [EMAIL PROTECTED]
The value cannot be converted to a number
155 : CFOUTPUT#ID#/CFOUTPUT
156 : CFSET ID=ID + 1
What code have you used when using Val() on ID.
Have you tried this:
CFSET ID = VAL(ID) + 1
?
If so and it still throws an error, send
[mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 3:32 PM
To: CF-Talk
Subject: value cannot convert to number
Hi Everyone,
Can someone tell be why I get a string convert error.I have tried
setting up ID to Val(ID) and even IncrementValue(Val(ID)), but all it ever
returns is either 0 or 1
Original Message:
From: Charlie Griefer [EMAIL PROTECTED]
val() won't convert an empty string.
Yeah, it will convert an empty string. It converts it to 0.
Scott
---
Scott Brady
http://www.scottbrady.net/
[Todays Threads]
[This Message]
[Subscription]
[Fast
learn something every day :)
- Original Message -
From: Scott Brady
To: CF-Talk
Sent: Monday, December 01, 2003 1:50 PM
Subject: Re: value cannot convert to number
Original Message:
From: Charlie Griefer [EMAIL PROTECTED]
val() won't convert an empty string.
Yeah, it will convert
Message -
From: Sam Fisher
To: CF-Talk
Sent: Monday, December 01, 2003 12:32 PM
Subject: value cannot convert to number
Hi Everyone,
Can someone tell be why I get a string convert error.I have tried setting up ID to Val(ID) and even IncrementValue(Val(ID)), but all it ever returns is either 0
.
-Sam
- Original Message -
From: Cameron Childress
To: CF-Talk
Sent: Monday, December 01, 2003 3:46 PM
Subject: RE: value cannot convert to number
You've not included what you think the value of ID is, but if it's (an
empty string as the error indicates), then val() will return a zero
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
Information
An error occurred while evaluating the expression:
EndRow = StartRow + OnEachPage - 1
Error near line 39, column 8.
Cannot convert to number.
Please, check the ColdFusion manual for the allowed conversions between
data types
The error occurred while processing an element with a general
://www.digitalshop.co.nz
- Original Message -
From: Jillian Carroll [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, January 12, 2003 10:15 PM
Subject: Cannot convert to number.
I am having a really weird problem... I do some calculations in CF, they
work on my development machine (Windows
#attributes.attcode# +
#GetVacationDetails.RegHrs#
Error near line 106, column 9.
Cannot convert SUM_8000 to number.
Please, check the ColdFusion manual for the allowed conversions between
data types
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
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
To: CF-Talk
Subject: Cannot convert to number
OMG.
I feel like its all coming apart now.
Got hit with another error , on another screen.
-
An error occurred while evaluating the expression:
SUM_
24 matches
Mail list logo