Nope....anyway the code you have suggested won't work anyway as you will
have an extra "OR" at the end of your SQL statement.
Just one point to make. If your table that you are updating is being used
for transactions (updates, selects, inserts) on a regular basis then you
should rethink your database structure so that your table has less fields.
You should really have a relational database structure and only have one
table with lots of fields when building a data warehouse.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 01 May 2001 14:13
To: CF-Talk
Subject: 1000s of SQL updates
I'm trying to find the best possible way to update 1000s of SQL records
at a time. I currently have a huge list that has all the colum values that
need to
have the change made (set the date to NOW()).
Is there a better way then:
SET colum=value WHERE <CFLOOP list>colum=#listitem# OR </CFLOOP>
Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
