Re: Cannot convert to number.

2003-01-13 Thread Bud
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? ***

RE: Cannot convert to number.

2003-01-13 Thread Everett, Al
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:

RE: Cannot convert to number.

2003-01-13 Thread Robertson-Ravo, Neil (RX)
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

RE: Cannot convert to number.

2003-01-13 Thread Everett, Al
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.

2003-01-13 Thread Robert Bailey
: 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

RE: Cannot convert to number.

2003-01-13 Thread Robertson-Ravo, Neil (RX)
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

RE: Cannot convert to number.

2003-01-13 Thread Robert Bailey
: 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

RE: Cannot convert to number.

2003-01-13 Thread Robertson-Ravo, Neil (RX)
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

Re: Cannot convert to number.

2003-01-12 Thread Srimanta
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

Re: Cannot convert to number

2001-11-19 Thread savan . thongvanh
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

RE: Cannot convert to number

2001-11-19 Thread Kevin Gilchrist
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

RE: Cannot convert to number

2001-11-19 Thread Kevin Gilchrist
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