> i have a query which has sort criteria applied at mysql level. > > i want to add a row at the top of the query after mysql has finished with it. > > If i use the queryaddrow method it adds the row to the bottom of the query > > is there anyway to get it to add it as the first item?
You could add the new row in the SQL itself using a UNION statement, couldn't you? Otherwise, you could add it using queryAddRow, querySetCell, etc, but you'd have to figure out how to get things in the order that you want them. You could create a new query, add the row to the new query, then loop through the old query and add each row to the new query. Or you could use queryAddRow and querySetCell with the existing query, but have a sortable field for all rows including the new row, then use query of query to sort the query again. But I'd go with doing this in your SQL if I were you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
