You can just make a query of query to resort it. I'll send you a copy of my ..cfc as an example.
[]'s Alex On Nov 16, 2007 1:44 PM, Jeff F <[EMAIL PROTECTED]> wrote: > Thanks Alex. > > I've never had a need to use those tags. One question, how do I get the > new row at the start? > For example: > <cfset queryaddrow(data)> > <cfset querysetcell(data,"make","please select")> > > The above puts the new row at the end of my record set. The example at > Adobe live docs is a little poor. Do I need to loop through and change the > sort by field (id) for every row? -then set the new field as 1?? > > -jeff > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293484 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

