_____
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 13 February 2004 15:09
To: CF-Talk
Subject: Re: Re:OT- Sort of Loop in SQL
I am using SYBASE and ACCESS. Thanks for the help
----- Original Message -----
From: Jeremy Brodie
To: CF-Talk
Sent: Friday, February 13, 2004 9:04 AM
Subject: Re:OT- Sort of Loop in SQL
Could you tell us what database you are using? There are major differences
between Oracle and SQL Server for the strategy and syntax to use in this
case.
Jeremy Brodie
Edgewater Technology
web: http://www.edgewater.com <http://www.edgewater.com>
phone:(703) 815-2500
email: [EMAIL PROTECTED]
>What are cursors? Could you show me some sample code?
> ----- Original Message -----
> From: MILAN MUSHRAN
> To: CF-Talk
> Sent: Friday, February 13, 2004 8:30 AM
> Subject: RE: OT- Sort of Loop in SQL
>
>
> You can use cursors.
>
> >From: "Mickael" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: OT- Sort of Loop in SQL
> >Date: Fri, 13 Feb 2004 08:23:04 -0500
> >
> >Hi All,
> >
> >I know how complete the following task in CF and SQL but I was
wondering if
> >there is a way to do it with only SQL. What I am trying to do is
modify
> >records sequentially in my database.
> >
> >I have a field in my database called destination, this is an office
> >location. And I have many records in my database that I would like to
> >assign 1/3 of the records to each of the three offices. I don't want
to
> >just do an update top (then 1/3) and set the office to each of the
office
> >ids. I was wondering if there is a way in SQL to update the first
record
> >to the first office ID, then the second record to the second office
id,
> >then the third to the third office id, then the forth record to the
first
> >office id and continue that way.
> >
> >Is this possible in SQL? There are Network security issues that won't
let
> >me connect to this database with CF.
> >
> >Mike
> >
> >
> >
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
