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 htttp://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 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
