UPDATE trd
SET seq='(seq+1)'
WHERE tr_d = '#TheTr_id#'
AND seq >= '#InsertSeq#'
This is my attempt to increment the column seq for a group of records bound by the
WHERE Clause...
It fails because the db can't seem to handle the seq+1 and I can't seem to find out
how to do this.
any ideas?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
