if you're outputting the query (especially if with ColdFusion), you have queryname.currentrow avaliable to you

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

  ----- Original Message -----
  From: Thanh Nguyen
  To: SQL
  Sent: Monday, August 30, 2004 12:48 PM
  Subject: auto-numbering the rows that the SELECT statement retrieves?

  Can I create a simple SELECT statement that generates an IDENTITY-type
  value by auto-numbering the rows that the SELECT statement retrieves?

  Thanh Nguyen
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to