<cfloop query="myQ"> <cfif MOD currentrow 10 is 0> MARK IT </cfif> </cfloop>
That should give you what you want. Just be sure to order the query in the same order the records were entered (probably by default PK asc if you are using numbered PKs) -----Original Message----- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Monday, November 22, 2004 11:12 AM To: CF-Talk Subject: every 10 row I have a table in my DB which has a field "Mark" I want to put "1" in this field on every after 10th row. What logic should I use MOD??? any other suggession? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185070 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
