> Say I have code that is accesses multiple datasources. CFTransaction cannot
> be used across multiple datasources.
>
> My question is can I make two CFTransaction blocks and on the first one set a
> CFTransaction SavePoint.
>
> Then if the second CFTransation errors can I roll back the first
> That is what snapshot isolation is designed for:
> http://msdn.microsoft.com/en-us/library/tcbchxcb%28v=vs.80%29.aspx
Great information, thank you Jochem.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Ado
On Tue, Nov 1, 2011 at 1:13 AM, Matt Blatchley wrote:
> Microsoft SQL Server 2008 (SP1)
> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
>
> Database table stores the Metrics by daily values so it's constantly
> being hit by the imported data and the user interface.
That
Very true. Thanks Russ.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:
well don;t forget that CF now has debugging again, so you could use
cfeclipse to step through and see what is happening.
I wouldn't expect 2 concurrent requests to run exactly the same, as
presumably each would be working on different data surely ?
On Tue, Nov 1, 2011 at 11:22 AM, Matt Blatchley
I thought that would be the case as well after researching a bit
further, but I haven't been able to get the two to finish at the same
time. Could just be a timing thing. The code that is executed once
the XML response is returned is quite lengthy, performing a number of
checks and rolling up th
that really shouldn't cause you to only be able to run 1 request at a time.
what actually happens if you run the page twice at the same time ?
On Tue, Nov 1, 2011 at 12:39 AM, Matt Blatchley wrote:
>
> Win2003 Standard
>
> I removed the cflock and I'm currently using isolation="READ_COMMITTED">
Win2003 Standard
I removed the cflock and I'm currently using
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.co
what type of cftransaction are you using, do u have cflocking as well,
if so what type.
are you really using Windows NT ? i'm pretty sure the minimum
requirements for SQL Server 2008 is windows 2003 server.
Russ
~|
Order the Ad
I'm not sure how much flexibility I have on this version because it's
a hosted solution in a shared environment:
Microsoft SQL Server 2008 (SP1)
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Database table stores the Metrics by daily values so it's constantly
being hit
On Mon, Oct 31, 2011 at 8:56 PM, Matt Blatchley wrote:
> So my question is this: Is it possible to have multiple queues
> running on different machines and dumping the data into the same
> table?
Yes.
> Using cftransaction, the second queue attempts to run but has to wait
> until the main Queu
How about using cfthread and processing multiple items with each request,
that will at least half the time it takes.
Regards
Russ Michaels
>From my mobile
On 31 Oct 2011 19:57, "Matt Blatchley" wrote:
>
> Greeting all,
>
> I'm running into an issue and was wondering if someone could give me
> s
I figured out a work around. I made a view of the table.
So now all my tables inside of the CFTransaction are in the same database.
Chad
-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com]
Sent: Wednesday, March 24, 2010 4:05 PM
To: cf-talk
Subject: cftransaction and multi
On Wed, Mar 24, 2010 at 9:05 PM, Chad Gray wrote:
> Datasource FOO verification failed.
> The root cause was that: java.sql.SQLException: Datasource names for all the
> database tags within the cftransaction tag must be the same.
>
> How can I get around this error? The function is just doing a
If the databases are on the same server, you can try accessing the
"other" database from your "main" data source by specifying the full
path to the table:
SELECT *
FROM databaseName.owner.tableName
On SQL Server, owner is often "dbo". Or you can use the shortcut
databaseName..tableName
~Brad
Thanks everyone - looks like the sproc is indeed committing on the backend. I
do miss writing my own queries...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing l
> I suppose what I should be asking is - is it even possible
> to do what I'm trying to do?
Yes. Unless, as someone else mentioned, the procedure you are calling is using
its own transaction. Is it?
-Leigh
~|
Want
The way the CFTransaction tag works is CF is putting the TRANSACTION statements
in the T-SQL it sends to the server. So the rollback tag will rollback any
transactions that haven't been committed. You could have 100's of queries
running with Inserts/deletes/updates and everything will rollbac
Good catch - you're right; I would normally include a cfif to append the return
string and the "" to allReturnMessages only if the return string isn't
empty.
The stored proc was written by someone else, so I'm not 100% sure what's
happening with it, which is part of the problem. I suppose wha
Nevermind, I read the cfif backwards. I was thinking it was looking for an
empty string. In that case, the cfif will always be true. This doesn't
explain the rollback issue, but once the rollback is fixed, it will always
rollback.
Do you have any commits in your stored procedure? If so, th
The way the code is written, the cfif will never be true because it will always
have "" in so the length will never be below 4.
> Hi all, I understand the gist of cftransaction, but I've tried using
> it with a conditional rollback on an action page in the below example
> and it doesn't seem t
I'm pretty sure the rollback is not occurring because your cfstoredproc call
inside your saveDataToDatabase() function is running in it's own
transaction. I think you'd need to include a "rollback;" command inside
your stored procedure if you have a failure.
Dave
-Original Message-
From
Keen"
Sent: Wednesday, July 29, 2009 1:00 AM
To: "cf-talk"
Subject: Re: CFTRANSACTION with MS Access Database
>
> hey Dave... can you provide me with some literature or example code on
> this
> topic ... specially in regard to MS Access...?
>
> ---
hey Dave... can you provide me with some literature or example code on this
topic ... specially in regard to MS Access...?
--
From: "Dave Watts"
Sent: Wednesday, July 29, 2009 12:34 AM
To: "cf-talk"
Subject: Re: CFTRANSA
> No guys this isn't working ... nor that what Barney and Dave advised...
> does anyone has a working example of such scenario? I would be very thankful
> if someone provides me with a somewhat similar working example
> and yes... I am using using CFTRY/CFCATCH because I need to log the er
try / catch is still the right way to capture errors, but if it's inside
the transaction, then the TR won't fire.
if this isn't working, though, then I gotta question whether Access
supports transaction locking at all? It's been years since I used it, so I
can't vouch one way or the other ...
rrors
and get a notification if a database exception occurs without breaking the
flow of my page is there any alternate to CFCATCH/CFTRY for this
purpose?
--
From: "Jason Fisher"
Sent: Tuesday, July 28, 2009 10:50 PM
To: "c
Try putting your CFTRY / CFCATCH around the outside of the CFTRANSACTION
... the error handler is not triggering your roll-back, I would guess.
INSERT STATEMENT 1
> Guys cumbersome
> below is my code and still its not rolling back ... I have
> injected an error in the 2nd insert statement but the transaction
> doesn't rolls back... 1st insert takes place... 2nd one has error wat
> could be the problem ... dear experts???
>
>
>
ENT 2
--
From: "Barney Boisvert"
Sent: Tuesday, July 28, 2009 1:00 PM
To: "cf-talk"
Subject: Re: CFTRANSACTION with MS Access Database
>
> The CFTRANSACTION tag takes care of the top-level rollback all on it's
> o
looks like is missing
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325027
Su
28, 2009 1:00 PM
To: "cf-talk"
Subject: Re: CFTRANSACTION with MS Access Database
>
> The CFTRANSACTION tag takes care of the top-level rollback all on it's
> own. The explicit rollback is only used if you have logic inside the
> CFTRANSACTION tag that needs to roll back
The CFTRANSACTION tag takes care of the top-level rollback all on it's
own. The explicit rollback is only used if you have logic inside the
CFTRANSACTION tag that needs to roll back because of some
non-exception situation. So you'll get the behaviour you want if you
remove the CFTRY..CFCATCH stu
Thanks for your comments. So long as I do not mess up my transactions because
of cfcs.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;20717
> Yes, you can, so long as they all hit the same datasource.
>
> > Wondering if we can wrap cfc methods (with db queries) in a outer
> > cftransaction?? Any comments ???
I've heard that they've added the feature enhancement in CF9 that allows
you to nest cftransactions now. So if you have alrea
Yes, you can, so long as they all hit the same datasource.
> Wondering if we can wrap cfc methods (with db queries) in a outer
> cftransaction?? Any comments ???
~|
Adobe® ColdFusion® 8 software 8 is the most important and dra
On 3/13/07, megan c wrote:
> Thank you so much--this worked like a charm (once I realized that there
> was a tab at the end of the lines mucking things up, that is).
Glad I could help!
~|
ColdFusion MX7 and Flex 2
Build
>
> It is EASY with cfhttp (if you've got well formed data), but I have
> never load tested it.
>
> or (not nearly as easy)
>
> If you've got createObject "power" you can use HSSQLDB, which seems
> pretty
> robust for CSV stuff- but CFHTTP is probably fastest from 0 to Query.
>
> The one advan
On 3/13/07, megan c wrote:
> Thanks for the suggestion. For one of my sites I'm going to need to do
> something along
It is EASY with cfhttp (if you've got well formed data), but I have
never load tested it.
or (not nearly as easy)
If you've got createObject "power" you can use HSSQLDB, wh
Thanks for the suggestion. For one of my sites I'm going to need to do
something along these lines, because the LOAD DATA function is disabled by the
host in the shared hosting environment. I need to import/update the data (a CSV
file that gets FTPed to the server) into a MySQL database a few ti
On 3/12/07, megan cytron <[EMAIL PROTECTED]> wrote:
>
> >Does load data infile query of mysql doesnt work in cftransaction?
>
> I'm curious... did you ever figure this out? I'm also trying to determine
> the simplest/most efficient way of loading the data from a .csv file into a
> mysql DB using CF
>Does load data infile query of mysql doesnt work in cftransaction?
I'm curious... did you ever figure this out? I'm also trying to determine the
simplest/most efficient way of loading the data from a .csv file into a mysql
DB using CF.
~~
.
Of course, I could be thinking of something else, as I said, I didn't
just test this.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 21, 2007 4:14 PM
To: CF-Talk
Subject: RE: cftransaction and two datasources
> I have a question.
> I have a question. I have a application where on one template
> I have several inserts into one datasource are wrapped inside
> a cftransaction. At the end of the loop, but outside the
> cftransaction, I have an update of a record in a second
> datasource, marking it as viewed. My question,
> I was wondering if anyone had any experience executing
> cfstoredproc calls within cftransaction's.
>
> The livedocs for cftransaction focus on cfquery operations.
> Though, using a MS Sql Server 2000 database, cftransaction
> seems to fully support rollback of cfstoredproc calls.
>
> I kno
Meaning a success/fail value for the transaction as a whole?
The only time CFTRANSACTION will implicitly roll back is when an
exception is raised. So if the CFTRANSACTION block exits normally
(assuming you're not doing a manual rollback), then you know the
transaction was successful. Conversely,
>> Jacob Munson wrote:
>> > Unless someone has created a new record after your
>> > insert,
>> > then you'll get their identity instead.
>> > SCOPE_IDENTITY,
>> > on the other hand, returns the last identity value
>> > generated for any table in the current session and the
>> > current scope. So w
> Jacob Munson wrote:
> > Unless someone has created a new record after your insert,
> > then you'll get their identity instead. SCOPE_IDENTITY,
> > on the other hand, returns the last identity value
> > generated for any table in the current session and the
> > current scope. So with one, you
>> SELECT IDENT_CURRENT('tablename ') which returns the
>> latest identity in the table name in question. That
>> also prevents getting the identity of the wrong table
>> in the event of the query being used as part of a
>> trigger which affects multiple tables.
Jacob Munson wrote:
> Unless som
S.Isaac Dealey wrote:
>>
>> That's a good idea, except that UUIDs take more
>> space and are slower to index when compared to
>> integers. However, that's only a problem if you
>> are dealing with large amounts of data.
>
> It only starts to become an issue with tens of millions of records, at
>
> Actually what I do more frequently nowdays is use
> createUUID() to
> generate a primary key of my own and insert that instead
> of using
> identity fields. All of these issues go away then.
> The only reason I use identity fields nowdays is if I
> think it's
> likely I might have to be typing
>> Actually what I do more frequently nowdays is use
>> createUUID() to generate a primary key of my own
>> and insert that instead of using identity fields.
>> All of these issues go away then.
> That's a good idea, except that UUIDs take more
> space and are slower to index when compared to
> in
Doing well, lots of fun new things on the horizon! How've you been? Btw,
it's good to see you on here.
Rich Kroll
Application Developer
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 10:56 AM
To: CF-Talk
Subject: RE: cft
> Actually what I do more frequently nowdays is use createUUID() to
> generate a primary key of my own and insert that instead of using
> identity fields. All of these issues go away then.
That's a good idea, except that UUIDs take more space and are slower to
index when compared to integers. Ho
Actually what I do more frequently nowdays is use createUUID() to
generate a primary key of my own and insert that instead of using
identity fields. All of these issues go away then.
The only reason I use identity fields nowdays is if I think it's
likely I might have to be typing queries out in t
> SELECT IDENT_CURRENT('tablename ') which returns the latest identity
> in the table name in question. That also prevents getting the
> identity of the wrong table in the event of the query being used as
> part of a trigger which affects multiple tables.
Unless someone has created a new record
If you're going to put two SQL statements in the same CFQUERY tag, you
also have to suppress the returned messages from the database, or the
second SQL Statement will throw an error. SET NOCOUNT ON will
supress the returned messages. so your CFQUERY looks something like
this:
SET NOCOUNT ON
I
Well, I think we're talking apples and oranges. This is what we tried
in DB2: in SQL Server we tried to use OpenQuery to send more than one
statement at once to DB2, and it just silently ignored the second
statement. However, we /could/ do two separate OpenQuery statements in
the same SQL script.
Dave Watts wrote:
>> That said, SQL Inject attacks /can/ be prevented by doing
>> proper data cleaning for all queries that use values
>> generated by outsiders (URL params, forms, etc.) I'm just
>> saying that Oracle, DB2 and the others prefer to prevent
>> things at the database level, rathe
I believe he was wrong, unless I am just misunderstanding "multiple
queries" because I do multiple ones all the time just not with a CFQUERY
and due to the JDBC drivers from what I can tell.
On 4/4/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
>
>
> I was told by someone that develops on Oracle th
> I was told by someone that develops on Oracle that multiple
> queries are not supported, but I suppose he could have been
> wrong.
You can run an SQL batch through SQL*Plus and see for yourself. That's just
another Oracle client. And I'm pretty sure that you can run SQL batches
against DB2 wit
> Whether you can run multiple queries within a single SQL
> batch is generally
> determined by the JDBC drivers (or other database clients)
> being used, not
> by the database. It's my understanding that Oracle and DB2
> both can accept
> SQL batches. Generally, Oracle is just as vulnerable to
> That said, SQL Inject attacks /can/ be prevented by doing
> proper data cleaning for all queries that use values
> generated by outsiders (URL params, forms, etc.) I'm just
> saying that Oracle, DB2 and the others prefer to prevent
> things at the database level, rather than putting the
> s
Right. The problem is not that the developer is going to do a SQL
injection, it's that Hackers on a public facing site will. DB2, Oracle
and others don't allow two queries in one statement to stop things like
what Ben Forta demonstrates in this blog post:
http://tinyurl.com/ozq8x
That said, SQL
I'm not sure about MySQL, but in Postgres you can select a new identity
key /before/ you do an insert. The key is unique to you, and can never
be used by anybody else (just like getting a new key when you do an
insert). Then you can use that key for your insert and any subsequent
queries. Much s
> I'm looking through someone elses code and I came across this...
>
>
>
> INSERT INTO t_doctors (#ColNames#)
> VALUES (#preserveSingleQuotes(ColValues)#)
>
>
>
>
>
> SELECT @@identity AS newpkey
>
>
> Moreover, a better solution would be something like this
> (assuming SQL Server):
>
>
>
>INSERT INTO t_doctors (#ColNames#)
>VALUES (#preserveSingleQuotes(ColValues)#);
>SELECT SCOPE_IDENTITY() AS newpkey;
>
>
Using CFTRANSACTI
How would you to this in (say) MySQL?
Munson, Jacob wrote:
> Keep in mind that most other databases (besides SQL Server) don't allow
> you to send two queries with at once like this. It's very insecure,
> because of sql injection possibilities. But since you guys are all
> talking about MS SQL,
The 2nd query won't allow anyone to perform a sql injection attack
against the database, although it's possible that using #ColNames# or
#preserveSingleQuotes(ColValues)# in this example might.
> Keep in mind that most other databases (besides SQL
> Server) don't allow
> you to send two queries wi
Hey Rich, how are things at Site?
I think "sessions" is the wrong label for this (although I could be
wrong) :) -- I believe scope_identity() works on the "batch", whereas
an open session for example in Query Analyzer can execute multiple
batches. I think CF Server in particular only creates one s
> Tony wrote:
>> does that retrieve the newest UUID Primary Key generated?
>> right now, i have a dateAdded field that i sort by, to
>> get the newest one.
> That's not real reliable. What happens if two records are
> added in the
> same second? :)
> Yes, it returns the last identity inserted, a
If possible you should use SCOPE_IDENTITY() for the reasons stated - as
noted direct from BOL.
-Original Message-
From: Rich Kroll [mailto:[EMAIL PROTECTED]
Sent: 04 April 2006 15:31
To: CF-Talk
Subject: RE: cftransaction
In MS SQL I've seen two ways to handle returning the
In MS SQL I've seen two ways to handle returning the last inserted primary
key:
INSERT INTO t_doctors (#ColNames#)
VALUES (#preserveSingleQuotes(ColValues)#);
SELECT SCOPE_IDENTITY() AS newpkey;
This will return the last inserted primary key for the current scope
Keep in mind that most other databases (besides SQL Server) don't allow
you to send two queries with at once like this. It's very insecure,
because of sql injection possibilities. But since you guys are all
talking about MS SQL, this works fine. :)
> -Original Message-
> From: Pete Ruck
Yep, indeed. They should also not be using @@identity :-)
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 04 April 2006 03:51
To: CF-Talk
Subject: cftransaction
I'm looking through someone elses code and I came across this...
INSERT INTO t_
Tony wrote:
> does that retrieve the newest UUID Primary Key generated?
> right now, i have a dateAdded field that i sort by, to get the newest one.
That's not real reliable. What happens if two records are added in the
same second? :)
Yes, it returns the last identity inserted, and inside a tr
does that retrieve the newest UUID Primary Key generated?
right now, i have a dateAdded field that i sort by, to get the newest one.
tony
On 4/3/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:
> You are correct.
>
> Moreover, a better solution would be something like this (assuming SQL
> Server)
You are correct.
Moreover, a better solution would be something like this (assuming SQL Server):
INSERT INTO t_doctors (#ColNames#)
VALUES (#preserveSingleQuotes(ColValues)#);
SELECT SCOPE_IDENTITY() AS newpkey;
Pete
On 4/3/06, Ric
I'm going through old emails I hadn't read, sorry it's taken so long to
respond.
> I always, always, always set the first column in my table to primary
> key, identity, and often (but NOT always) a clustered index.
I think you're usually better off reserving the clustered index for
something othe
I'm going through old emails I hadn't read, sorry it's taken so long to
respond.
> There are rules for passwords, and "no spaces" be one of mine. I
> figure if Microsoft can tell me that "Backup 2/15/2005.zip" is an
> illegal file name, then I can tell someone that "my dog has$$fleas "
> is an i
> If I comment out the "CFTRANSACTION action=COMMIT" tag and the query
> completes without errors, the data is still written to the database.
> Shouldn't I have to explicitly use COMMIT in order for the data to be
> saved? At first glance it seems that the only time I'd want
> to ROLLBACK is i
> CFTRANSACTION action=BEGIN
>
> CFTRY
>
> many CFQUERY tags
>
> CFTRANSACTION action=COMMIT /
>
> CFCATCH
>
> CFTRANSACTION action=ROLLBACK /
>
> /CFCATCH
>
> /CFTRY
>
> /CFTRANS
That is the expected behavior as I understand it.
If you just wrap one or more query blocks inside a pair of basic
tags, the data will be committed if there are no failures,
otherwise none of the data is committed.
You do not need to use the "begin", "commit" or "rollback" properties, unless
It's expected behavior. The from will automatically commit if no error occurred or
rollback if an error occurred.
Pascal
> -Original Message-
> From: Cliff Meyers [mailto:[EMAIL PROTECTED]
> Sent: 22 March 2005 17:23
> To: CF-Talk
> Subject: cftransaction behavior
>
> I've noticed some
Using your pseudo code, I do the following... Never had a problem with it
and I'm not dependent on varables being set etc...
CFTRANSACTION action=BEGIN
CFTRY
many CFQUERY tags
CFTRANSACTION action=COMMIT /
CFCATCH
That makes sense...
I think I (and probably others) end up with a story that goes "once
upon a time, back in the day, I tried that and I couldn't get it to
work" and stick with it, never thinking about the fact that it was 3
or 4 years ago on a substantially different platform. It's not until a
th
wrote:
>
> While the same OS allows spaces in passwords...
>
> -Original Message-
> From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 8 March 2005 9:21
> To: CF-Talk
> Subject: Re: cftransaction... it wasnt safe?
>
> [snip]
>
>
ories, Inc. | Web Developer
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 11:16 AM
To: CF-Talk
Subject: Re: Password Rules - Was: RE: cftransaction... it wasnt safe?
For usernames, I usually only allow alphanumerics, constrain the length,
> and I believe that as I refactor the site and continue
> to develop it that I'll be able to define much MORE
> elegant ways of doing the same thing in CF. Starting
> with refining the database design... because the
> tbl_login+tbl_{user_type} did NOT work out as well
> as I'd hoped. Most annoying
ertified Advanced ColdFusion MX Developer
> Wyle Laboratories, Inc. | Web Developer
>
> -Original Message-----
> From: James Holmes [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 08, 2005 10:28 AM
> To: CF-Talk
> Subject: RE: cftransaction... it wasnt safe?
>
> While the sa
all sessions.
>
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 08, 2005 7:46 AM
> To: CF-Talk
> Subject: Re: cftransaction... it wasnt safe?
>
> :) thank you adam...
>
> any idea, how i could restructure it to achieve that?
>
>
Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 10:28 AM
To: CF-Talk
Subject: RE: cftransaction... it wasnt safe?
While the same OS allows spaces in passwords...
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTEC
While the same OS allows spaces in passwords...
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 8 March 2005 9:21
To: CF-Talk
Subject: Re: cftransaction... it wasnt safe?
[snip]
There are rules for passwords, and "no spaces"
Just wrap an exclusive lock around the transaction. Make it a named lock
that will cross all sessions.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 7:46 AM
To: CF-Talk
Subject: Re: cftransaction... it wasnt safe?
:) thank you adam...
any
Why serializable instead of repeatable_read?
OK, serializable then... According to the BOL, the only benefit of
serializable over repeatable_read is the prevention of phantoms, and I
can see that applying to this situation.
As far as sprocs are concerned... it's probably a fine idea, although
I'v
Interesting... I think I all-too-often assume someone's using the dame
DB design paramters as I do, and I completely missed this until you
said something, Jochem.
I always, always, always set the first column in my table to primary
key, identity, and often (but NOT always) a clustered index. I rea
My personal preference would be to make a Store procedure that does it...
It would follow the same basic concept as you already have only
instead of it being written in CF it would be in SQL.
Transaction serializable would be a good idea too.
Adam H
On Tue, 8 Mar 2005 07:52:51 -0600, Jared Ry
Tony Weeg wrote:
>
> i have two records with the same acctNo, and there should only
> be one!
Define the field as UNIQUE.
>
Make this transaction serializable.
Jochem
~|
Find out how CFTicket can increase your company's cus
Tony,
I've messed with this, but not for a long, long time... since the CF5
days, because the tags never seemed to work as expected.
I'd recommend you actually try something like this:
.code here
Be sure t
:) thank you adam...
any idea, how i could restructure it to achieve that?
thanks.
tony
On Tue, 8 Mar 2005 07:27:37 -0500, Adam Haskell <[EMAIL PROTECTED]> wrote:
> I think your concept of how cftransaction works is faulty. The way
> this is set up it is not keeping 2 Select max(acctno) happeni
1 - 100 of 275 matches
Mail list logo