Try this:
<cfloop index="memberID" from="1" to="3300">
<cfquery name="updateRecords" datasource="dsn">
UPDATE myTable
SET controlID = '#createUUID()#'
WHERE memberID = #memberID#
</cfquery>
</cfloop>
-Frank
----- Original Message -----
From: Mark Leder <[EMAIL PROTECTED]>
Date: Sun, 4 Jul 2004 11:39:25 -0400
Subject: Updating multiple records
To: CF-Talk <[EMAIL PROTECTED]>
Hi all,
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]
