How to Create an Auto-Number in a Query?

[Monizzle]

I want to create a verity search collection by indexing the contents of a Union
Query. My Union query collects data from multiple databases/DSNs.

I believe the cfindex function (used to create a verity collection) needs a
primary key from query. However, I do not know how to create an auto-number
primary key in a query.
Could someone offer some help?

For reference, here?s the cfindex tag:
<cfindex collection="myCollection" action="update" type="custom" body="title,
article_body" key="autonumber_id" title="title" query="union_articles">

[Dan Bracuk]

In your union query, select the constant 10000 as an extra field. Then loop through the query and set this field to the current rownumber.

[Monizzle]

Dan,

Not sure I understand. Are you suggesting that I establish an alias column in
my union query and then cfloop over it, using a SQL update query to update the
Union results to #currentrow#?
I thought I could only update tables, not queries.
You must mean that I can place a loop in my SQL statement, but I have no clue
how to do this.
If you could get me started it would be much appreciated.

BTW, thanks for being such great presence on these forums. I?m sure you?re
keeping ColdFusion alive for a lot of folks.