Fernando wrote:
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0009_01BFC28E.9448B240
> Content-Type: text/plain;
> charset="Windows-1252"
> Content-Transfer-Encoding: quoted-printable
>
> Hi all!
>
> I'm trying to update only the first record that match my conditions. =
> I do,
>
> <cfquery name=3D"Update" datasource=3D"ExDataBase">
> UPDATE Stock =20
> SET Number=3DNumer - #Otherquery.Number#
> WHERE Status=3D'K' AND CodID=3D'#Code#' AND....
> </cfquery>
>
> But this way I update all the records that match this conditions, and I =
> only want to update the first that do it. I hope you can help me.
This sounds like a problematic thing to want to do. Can you make the
update more specific to grab only the correct record instead of relying
on the correct record being the first match? Relying on the correct
record being the first one would make me nervous. There must be some way
that multiple records would be unique, so maybe you should be searching
for that.
--
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Um, nevermind. I have a job now.
http://63.74.114.11/mr_urc/
http://www130.pair.com/jlarkin/
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
