late night last night? lol
Don Vawter
www.cyberroomies.com
[EMAIL PROTECTED]
----- Original Message -----
From: "Gonzo Rock" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, September 01, 2001 12:43 PM
Subject: Re: UPDATE Statement
>
> 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
