Thanks Deanna :) sas
-- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 10:04 AM To: CF-Community Subject: Re: SQL Question 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:256583 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
