We're a community of 1.1M IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,080,445 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

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.

2
Contributors
1
Reply
2 Hours
Discussion Span
1 Year Ago
Last Updated
2
Views
Cheesecake87
Newbie Poster
11 posts since May 2010
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

its not even a variable with time in it.
...
<cfset ET = timeformat(EndTime, 'H')>

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 Pro in Training
405 posts since Dec 2008
Reputation Points: 32
Solved Threads: 50
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page generated in 0.2403 seconds using 2.63MB