You can set the column as the Identity in the Design of the SQL Table. This will automatically increment your row number.
Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 3:54 PM To: CF-Talk Subject: OT: (cross post) SQL row numbering How can I get SQL server to automatically number my rows of a recordset, as I retrieve it? If I have the following information in a table (example data) Name Age Joe 20 Sally 14 Jim 15 And I do a query: Select somefunction() as rownum, name, age from table I want a recordset of Rownum Name Age 1 Joe 20 2 Sally 14 3 Jim 15 Since this is going to be a small part of a larger stored procedure, I can't use CF. Thanks Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 4:42 PM To: CF-Talk Subject: RE: MM Pricing Problem on CFMX for J2EE I would agree that it is an over-generalized statement, however, the technical support DOES have its issues. I've had a problem with JVM Memory Settings in CFMX Pro but in order to speak to someone in your tech support dept. I have to pay at least $250. It seems that when you pay over $1000 for software that you should get at least SOME technical support - even for a limited time. I bought an iBook and got 90 days unlimited support. My iBook cost about the same as CFMX Pro. It would be nice to get some temporary support for our money. After all, isn't that one of the arguments about why people choose retail products over open-source? Technical Support. You're supposed to get more if you pay right? I can write PHP and pay someone to give me support on that, but since I paid $1000 for CFMX I expected some free support - or at least someone courteous on the phone. I'm not leaning towards MM bashing mind you - I love CFMX and MM products in general, but seriously, do something about your support options. Even email or chat-based support to determine if higher-level paid support is in order. Sort of a Tech Support Triage or something. That's just my opinion ... Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Mike Chambers [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 4:28 PM To: CF-Talk Subject: RE: MM Pricing Problem on CFMX for J2EE > -----Original Message----- > From: samcfug [mailto:[EMAIL PROTECTED]] > advantage. And of course everyone knows that their tech > support sucks big time. That is quite a generalization, and one i personally feel is incorrect. While some people may have had poor experiences with tech support (such as yourself), to state that "everyone" feels the way you do is, in my opinion a rather large leap. mike chambers [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4