> > Anyone know how I can do a SQL query (MySQL) and have a column with a > row number auto incremented as the count goes up? > > I.e. I want: > > rowid userid username > 1 234 bob > 2 531 steve > 3 746 arnie > > Etc -- the "rowid" field is generated by the SQL... > Umm... are you saying you want to actually physically have that column in the table? If so then you can create a field so type autoincrement.
If not, then when you get the query back to CF one of the additional columns you get with the query is CurrentRow. The latter is only useful in this instance of the query. It would mean nothing to pass this number through to an action page, unless you still had the complete unchanged record set. Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
