954,585 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Anyone tell me whats wrong with this code?

Anyone tell me why this Coldfusion code aint working ?
I built the system on the Coldfusion 9 developer server locally then uploaded it to a Coldfusion 8 hosted server and I get this strange error.

Error can be seen here: http://75.126.153.165/$sitepreview/ka-radio.co.uk

Code where error is highlighed can be seen here: http://pastebin.com/gGLQmaPD

Database design can be seen here: http://imageshack.us/photo/my-images/194/databasedesign.png/

Hmm :/ is there something different about how coldfusion 9 and 8 work with times .. its not even a variable with time in it.

I also tried this code on a locally hosted railo server and it worked fine.

Cheesecake87
Newbie Poster
11 posts since May 2010
Reputation Points: 10
Solved Threads: 0
 
its not even a variable with time in it. ...

Then why are you using timeFormat on it? :) If EndTime is null, its probably returning an empty string, hence the error when you try and perform subtraction. Make sure it's a number and problem solved.

<cfset ET = "">
   <cfset thisFails = ET - 1>
arrgh
Posting Whiz
381 posts since Dec 2008
Reputation Points: 32
Solved Threads: 47
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You