"OLEDB Error Code = 3621 The statement has been terminated."
The query looks fine and runs without error in Query Analyzer. We have
CF4.5, MSSQL 2000, latest MDAC.
Does anyone have some insight on this?
Thanks,
Claudia
__
This
I believe you have to use '%' such as:
SELECT * FROM purchases where 0 = 0
And invoicenumber LIKE '%2%'
And contact LIKE '%%'
And vendor LIKE '%%'
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 2:09 PM
To: CF
I sent this posting early in the morning... I didn't see it posted so I sent
it again. People has already replied (thanks all) and now this gets
posted... Hm.
Is this a common problem with cf-talk?
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
otential for disaster I
would think). Just my $.02
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 2:18 PM
To: CF-Talk
Subject: RE: sharing sessions due to url.cfid and url.token
Yes, but by the time your Application.cfm runs this, the cfid a
I'm trying to think of a way not to allow people to inadvertedly share a
session by sending each other a url with their cfid and cftoken in it. Of
course we can just make sure that those are not passed as url parameters,
but I'm thinking if there's a way to check if this is a session initiated by
right hand side
of each expression.
-----Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:01 PM
To: CF-Talk
Subject: RE: sharing sessions due to url.cfid and url.token
You can have multiple users showing the same IP address if they're behind
the sam
ing I can think of is to add some code to your App.cfm
file
>which checks for the existence of CFID and CFTOKEN as URL variables and if
>found, just redirect to the same page minus the session info on the url
>line. Of course this assumes you don't ever pass the session info in the
>
I mean mySQL!
*looking for coffee cup*
-Original Message-
From: Hoag, Claudia (LNG)
Sent: Tuesday, May 21, 2002 11:50 AM
To: '[EMAIL PROTECTED]'
Subject: RE: mySQL vs. Access
Hm, if we're talking SMALL small then I would think you don't have to pay
anything
Hm, if we're talking SMALL small then I would think you don't have to pay
anything to use msSQL, right?
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 11:34 AM
To: CF-Talk
Subject: RE: mySQL vs. Access
If we're talking SMALL small and soft
exist, then they swapped links.
DRE
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 8:19 AM
To: CF-Talk
Subject: sharing sessions due to url.cfid and url.token
I'm trying to think of a way not to allow people to inadvertedly share a
I'm trying to think of a way not to allow people to inadvertedly share a
session by sending each other a url with their cfid and cftoken in it. Of
course we can just make sure that those are not passed as url parameters,
but I'm thinking if there's a way to check if this is a session initiated by
ation Systems
[EMAIL PROTECTED]
+---+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PRO
t use the stats
CF keeps about last visit's and hitcounts. Disabling the global stats is SOP
here. You will probably notice an overall performance boost as well...
jon
- Original Message -
From: "Hoag, Claudia (LNG)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAI
Does anyone know why I get row level deadlocks in CFGLOBAL and what are the
implications of that?
The other day I talked to our DBA about some deadlocks (not related to
CFGLOBAL) and she started to look for them... And found a whole bunch of
deadlocks in the CFGLOBAL table. Those are row level loc
eszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:39 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
this is exactly right, just the query, not the table, and after I get the
results. thanks for clarifying.
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[
I think he doesn't want to alter the table... just the results.
And it's not during the query, it's after you get the results... right?
Otherwise you could query like
select col1, col2, col3, '24' as myCol from mytable
-Original Message-
From: Andre Turrettini [mailto:[EMAIL PROTECTED]]
The other day I talked to our DBA about some deadlocks and she started to
look for them... And found a whole bunch of deadlocks in the CFGLOBAL table.
Those are row level locks and if she didn't start looking for them, I would
never take notice that those were happening.
Does anyone know why I get
But isn't it what's happening with the "hotspot" problem? - the query is
done, but the database still has the page locked.
BTW, Thanks bunches Dave, it's great to have a geekguru available like this
;)
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17,
I thought about using cftry/cfcatch, but what if my second attempt is still
done before the table is again available... I was wondering if ColdFusion
had a "timer" function - such as, "wait 300ms before continuing"?
-Original Message-
From: Hoag, Claudia (LNG) [mai
Yes, but if it calls the database and doesn't wait for anything back, just
goes ahead and calls it again... wouldn't it happen the same as when I call
the queries - and the loop is faster than the database?
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 1
all the time with VB but never done it with CF
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 17:37
To: CF-Talk
Subject: RE: What is this SQL Error?
The DBA wants me to call a stored procedure, "wait" until the stored
procedure is
The DBA wants me to call a stored procedure, "wait" until the stored
procedure is done, then continue with the loop to call it again... Is there
a way to make sure the store procedure is "done" before the code continues?
-Original Message-
From: Hoag, Claudia
Thanks, I'll discuss that with our DBA.
I'm not using any CFTRANSACTION, though. What might have an impact here is
that this is a code that loops up to four times and does an insert every
time. The user selects up to four items, and then the code loops through
them and inserts a record in the tabl
I'm trying to figure out if ColdFusion locks the whole table when running a
cfquery.
I'm getting those deadlock errors in production, where too many people
access the same table at the same time. It never happens in the development
environment or in the testing environment. But the thing is, I get
24 matches
Mail list logo
