could use as you mentioned : cftransaction but there are granular levels of
control in say SQL Server which allow greater locking - SQL Server by
default locks anyway so its actually impossible for a users to edit records
at the same time.
_____
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: 17 February 2004 04:57
To: SQL
Subject: Locking Records
Is it possible to lock a record, so that another user can not edit delete
this until you are finished with it.
I was using cftransaction with a cflock that had the same name if it was an
update or delete, hoping that if one user tried to read this while I was
editing it or updating it that it would not return until the lock had
finished.
Would this work, or would it be best to handle it with SQL....
Regards
Andrew Scott
Technical Consultant
NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205
Phone: 03 9686 0485 - Fax: 03 9699 7976
_____
From: David Brown [mailto:[EMAIL PROTECTED]
Sent: Saturday, 20 December 2003 3:03 AM
To: SQL
Subject: DTS package
I have a pipe delimited text file (17 columns) with LF as the row delimiter.
One of the files that I need to import is over 56 megs. I have tried DTS to
import the file, but get around 1000 rows per second.
Is bulk copy the best or just straight import through a dts package?
I am looking for the fastest way to import it. After 4 min I had 86000 rows
out of about a million.
David
----- Original Message -----
From: Antony Sideropoulos
To: SQL
Sent: Thursday, December 18, 2003 8:49 PM
Subject: Re: multi-step SP
What's wrong with sp_ ?? I thought I was quite clever using that as my
prefix?
:-(
>From: "Neil Robertson-Ravo - Team Macromedia"
><[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: SQL <[EMAIL PROTECTED]>
>Subject: Re: multi-step SP
>Date: Wed, 17 Dec 2003 21:11:46 -0000
>
>Hey Michael,
>
>Do you want this variable to be passed around from within an sproc itself
>or out from an sproc into another SP? It sounds and looks as though you
>can do the whole shebang in one SQL query/sproc.
>
>You can also set a variable in the SP can call it via:
>
>usp_yourproc @input , @result output
>
>where @result is defined and set inside the sproc.
>
>Are you planning to use cfstoredprocedure or EXEC within a cfquery block?
>
>Also, remember and NOT to name your sproc "sp_" as that will degrade SQL
>Server performance on your db operations.
>
>
>
>
>
>----- Original Message -----
> From: Michael Dinowitz
> To: SQL
> Sent: Wednesday, December 17, 2003 7:33 PM
> Subject: multi-step SP
>
>
> I've got a massive uploader where the data (after mapping) is put into
a
>temp
> table and then has to be transformed some and put into 2 live tables.
I
>need to
> do the following queries:
> 1. get lastid+1 from items table
> 2. generate parent/child relationship for item
> 3. put tempitem into items table
> 4. put tempitem into lotmatrix table
> 5. delete temp item
> These have to be done in a one at a time fashion and is a lot of
>queries. CFMX
> doesn't like 1500+ queries inside a CFTRANSACTION block (I'm assuming
>that's the
> source of the error as it works) so I have to do the whole operation
one
>at a
> time.
> Does anyone have the syntax offhand for assigning variables from a
query
>in an
> SP to another query in an SP? I want query 1 in the SP to get the
lastid
>and
> store it as a var. Query2 in the SP will then use that var with others
>to
> insert.
> Thanks
> --
> Michael Dinowitz
> Finding technical solutions to the problems you didn't know you had
yet
>
>
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
