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?
*** *** *** Error Diagnostic 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 identifier of (CFSET), occupying document position (39:2) to (39:43). Date/Time: 01/12/03 23:33:29 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 207.195.97.118 *** *** *** My code is below: <!--- QUERIES AND VARIABLE SETTING ---> <cfquery name="tools" datasource="#dsn#" username="jubilee" password="cds337"> SELECT jubileeid, globalnumber, nanumber, rotundanumber, binlocation, name FROM tools ORDER BY name ASC </cfquery> <!--- END QUERIES AND VARIABLE SETTING ---> <!--- Next/Previous Logic Start ---> <!--- Set the number of records to display on each page. ---> <CFSET OnEachPage = #toolsviewnum#> <!--- Set the default startrow to 1 if a value was not passed. ---> <!--- Determine whether or not to show the previous or next links. ---> <CFPARAM NAME = "StartRow" DEFAULT = "1"> <!--- Set the value of endrow to the maxrows + startrow - 1 ---> <CFSET EndRow = StartRow + OnEachPage - 1> <!--- If the end row is greater than the recordcount, determine how many records are left. ---> <CFIF EndRow GTE tools.RecordCount> <CFSET EndRow = tools.RecordCount> <CFSET Next = false> <!--- Othereise, set Next to true and determine the next set of records. ---> <CFELSE> <CFSET Next = true> <CFIF EndRow + OnEachPage GT tools.RecordCount> <CFSET NextNum = tools.RecordCount - EndRow> <CFELSE> <CFSET NextNum = OnEachPage> </CFIF> <CFSET NextStart = EndRow + 1> </CFIF> <!--- If StartRow is 1, set Previous to false. ---> <CFIF StartRow IS 1> <CFSET Previous = false> <!--- Othewise, determine the previous set of records. ---> <CFELSE> <CFSET Previous = true> <CFSET PreviousStart = StartRow - OnEachPage> </CFIF> <!--- Determine how many pages will be displayed. ---> <CFSET NumPages = Ceiling(tools.RecordCount / OnEachPage)> <CFPARAM NAME = "PageNum" DEFAULT = "1"> <!--- Next/Previous Logic End ---> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
