Thank you Zac and Mark! The int() did the trick...you're right Mark, the <cfscript> way does look cleaner.
Thanks again -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:52 AM To: CF-Talk Subject: RE: QofQ weirdness when using QueryNew Ryan, We had this error discussed a little while back. QuerySetCell types your data as a string if you do not "trick" it into knowing othewise. It really needs an additional parameter called "type" or something. Anyway, try this trick on the "dist_wins" column set: QuerySetCell(teamStandings, "dist_wins", dist_wins * 1,loop_count); This will cause it to be stored and typed as a number. Also (since you are worried about formatting), you can do a lot less typing with <cfscript> and querysetcell - i.e. <cfscript> FOR(loopcount = 1; loopcount LE somevalue; loopcount = loopcount + 1) { newRow = QueryAddRow(teamStandings, 1); // set the cells in the query row QuerySetCell(teamStandings, "site_id",site_id,loop_count); QuerySetCell(teamStandings, "name", orginization_name,loop_count); QuerySetCell(teamStandings, "wins", wins,loop_count); QuerySetCell(teamStandings, "losses", losses,loop_count); QuerySetCell(teamStandings, "ties", ties, loop_count); QuerySetCell(teamStandings, "dist_wins", dist_wins * 1,loop_count); QuerySetCell(teamStandings, "dist_losses", dist_losses,loop_count); QuerySetCell(teamStandings, "dist_ties", dist_ties,loop_count); } </cfscript> As you can see - both in cfscript and <Cfset> syntax - you do not need the pound signs. But in cfscript, you can skip the "temp=" because functions that return boolean can be used directly. -Mark -----Original Message----- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:29 AM To: CF-Talk Subject: RE: QofQ weirdness when using QueryNew Let me format that code a little better: <cfset newRow = QueryAddRow(teamStandings, 1)> <!--- set the cells in the query row ---> <cfset temp = QuerySetCell(teamStandings, "site_id", #site_id#, #loop_count#)> <cfset temp = QuerySetCell(teamStandings, "name", #orginization_name#, #loop_count#)> <cfset temp = QuerySetCell(teamStandings, "wins", #wins#, #loop_count#)> <cfset temp = QuerySetCell(teamStandings, "losses", #losses#, #loop_count#)> <cfset temp = QuerySetCell(teamStandings, "ties", #ties#, #loop_count#)> <cfset temp = QuerySetCell(teamStandings, "dist_wins", #dist_wins#, #loop_count#)> <cfset temp = QuerySetCell(teamStandings, "dist_losses", #dist_losses#, #loop_count#)> <cfset temp = QuerySetCell(teamStandings, "dist_ties", #dist_ties#, #loop_count#)> <cfset loop_count = loop_count + 1> </cfloop> < ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
