I suppose it depends on what you mean by "10th row". How is that sorted? Is it every 10th row that ever existed, or that currently exists? How are you going to handle deletions?
Generically speaking, I'd do this on output, but I don't know the specifics of your situation. Now that I've muddied the water thoroughly, I'm going to lunch. :-) --Ben Asim Manzur wrote: > 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:185036 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
