Depends on your database. In sql server, it's an identity field, in Oracle, you'd use a sequence and do mysequence.nextval.
Also, count is probably a reserved word in whatever database you're using, so don't name your column that. You might also be able to do something like: Insert into myTable(mycount, fieldname) (select max(mycount) + 1 from mytable, #fieldname#) On Mon, Mar 17, 2008 at 8:30 AM, Scott Stewart wrote: > Hey all, > > > > How do I create a row in a query that contains a sequential number IE: > > > > ----------------------------------- > > Count | Fieldname > > > > Thanks > > > > sas > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:256579 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
