First always add a prmiary key to your tables! Second, you could also use #queryName.currentRow#
Taco Fleur ----- Original Message ----- From: "Burcham, Steve" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 1:08 AM Subject: RE: (cross post) SQL row numbering > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
