I have a SQL 2000 db with about 3400 records, which I upsized from MSAccess.
Each record has a unique memberID (1,2,3, and so on, from Access). I need
to insert (in a new field) a UUID into each of the first 3300 records (the
newer ones already have it). How would I go about doing it?
<cfquery name="updateRecords" datasource="dsn">
UPDATE myTable
SET controlID = '#createUUID()#'
WHERE memberID = ??? (this would Increment the memberID by one, I
guess, from 1 through 3300)
</cfquery>
Thanks, Mark
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
