Need to create a numerical column in a Select Query containing consecutive numbers starting from 1 to identify the current row. Cannot use the existing autonumber field cause is full of holes.

<cfquery name="getFeedBack" datasource="#db#">
SELECT f.*, ........... as cur_row
FROM feedback f
WHERE f.f_userId = #qGetUser.userId#
ORDER BY f_date asc
</cfquery>

Thanks for Helping

Take a look at this post.

Thank you very much. Like a charm!

Glad it helped.

Thanks for that thread ken. Another addition to my archives.