jeeze!
Sheepish grin...
At 11:42 AM 9/1/01 -0600, you wrote:
>take the quotes of the (seq +1)
>Don Vawter
>www.cyberroomies.com
>[EMAIL PROTECTED]
>
>----- Original Message -----
>From: "Gonzo Rock" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Saturday, September 01, 2001 11:38 AM
>Subject: UPDATE Statement
>
>
>> 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
