However, in order to realize this advantage fully, you really need to work within the "SQL world". This means applying relational solutions to sequential problems.
In short, I'm not sure much is gained (efficiency wise) by replacing Cold Fusion (or any other sequential processor) with SQL cursors.
Brian Grant
Senior Programmer
SI International
www.si-intl.com
----- Original Message -----
From: Robertson-Ravo, Neil (RX)
To: CF-Talk
Sent: Friday, February 13, 2004 7:55 AM
Subject: RE: OT- Sort of Loop in SQL
A cursor is the SQL Ability to performa a loop etc...Are you on SQL Server?
If so, open up Query Analyser and select Help > Books Online.
Search for Cursors
This will give you all the info you need!
_____
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 13 February 2004 13:51
To: CF-Talk
Subject: Re: OT- Sort of Loop in SQL
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]
