This was a really good idea, and solved the problem. I validated for an
integer, and the error went away. TNX.
On 11/8/2010 7:49 AM, Michael Grant wrote:
> The best way would be to validate the data before getting your database
> involved.
>
>
> On Mon, Nov 8, 2010 at 10:07 AM, Rick Colman wrot
A good site-wide error handler that sends alert e-mails would help.
The cferror tag is one method that works well.
-Mike Chabot
On Mon, Nov 8, 2010 at 10:07 AM, Rick Colman wrote:
>
> What is the best way to gracefully trap this sort of error ...
>
> Error Executing Database Query. [Macromedia]
The best way would be to validate the data before getting your database
involved.
On Mon, Nov 8, 2010 at 10:07 AM, Rick Colman wrote:
>
> What is the best way to gracefully trap this sort of error ...
>
> Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
> Socket][Micros
Have you tried cftry/cfcatch?
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 8 November 2010 23:07, Rick Colman wrote:
>
> What is the best way to gracefully trap this sort of error ...
>
> Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
> Sock
What is the best way to gracefully trap this sort of error ...
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
The error occurred on line 3.
TNX for any suggestions.
Rick.
~~
I also believe (though I'm happy to be corrected if I'm wrong) that
you can later safely switch from a varchar to an nvarchar. You'd be in
danger of truncating data if you went from nvarchar to varchar, but
since varchar is a subset of nvarchar, changing the data type at a
later date should be saf
>>>Just out of curiosity, when should I use nvarchar as opposed to varchar?
nvarchar allows for an expanded set of characters, for example if you want
your app to be able to handle double byte characters for non latin languages
such as Chinese or Russian you would use nvarchar or ntext.
However,
That did it.
Set up a regular sql server datasource and it worked.
Thank you so much.
Just out of curiosity, when should I use nvarchar as opposed to varchar?
On Thu, Feb 18, 2010 at 12:20 PM, Jochem van Dieten wrote:
>
> On 2/18/10, Matthew Smith wrote:
> > I am getting an error in a query t
On 2/18/10, Matthew Smith wrote:
> I am getting an error in a query that does not happen with crystaltech.
>
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
> Driver]Invalid precision value
I am betting that a reputable hoster such a
, February 17, 2010 6:12 PM
To: cf-talk
Subject: local sql error, not on live site.
I have a local install of sql server developer edition 2005. I have used
the data base publishing wizard to copy the db from crystaltech to my local
server.
I am getting an error in a query that does not happen with
I have a local install of sql server developer edition 2005. I have used the
data base publishing wizard to copy the db from crystaltech to my local server.
I am getting an error in a query that does not happen with crystaltech.
Error Executing Database Query.
[Macromedia][SequeLink JDBC Dri
I'm using Oracle and CF7, doing a Query of Query. I'm attempting to research a
query to find any that the title doesn't have "affiliate Faculty" in it.
The query of query is giving me an error:
"The system has attempted to use an undefined value, which usually indicates a
programming error, ei
This is related to an earlier post today "Coldfusion 8 Data Source Timeout".
I am still getting a timeout when configuring a certain Data Source to a remote
database.
Using dbaccess from my CF8 machine works - no problem.
I looked the cfserver.log and get: A non-SQL error occu
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
WWW: http://www.evoch.com/
> -Original Message-
> From: Scott Stewart [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2008 4:04 PM
> To: CF-Talk
> Subject: Break from the SQL Injection thread
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 28: Incorrect syntax
near '@P10'.
I haven't the foggiest idea what's going on here.
here's the passed in params from the java trace:
(param 1) = [type='IN', class='java.lang.String', value='Elmer',
sqltype='cf_sql_varchar'] ,
(param 2) = [type
-Original Message-
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: 11/14/06 7:17 PM
Subject: Sql error during insert
I do not recall seeing this before. Could someone tell me what I am doing
wrong? I get the following error while executing this que
Thanks. I hate it when the little stuff haunts you -)
Doug
- Original Message -
From: "Bobby Hartsfield" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, November 14, 2006 8:21 PM
Subject: RE: Sql error during insert
> You are mis
Never mind...I missed a closing ) on my query. Geez looked at it forever.
D.B
- Original Message -
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, November 14, 2006 8:15 PM
Subject: Sql error during insert
> I do not recall seeing th
You also need to specify the delimiter in your loop as a |
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Crow T. Robot [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 10:22 PM
To: CF-Talk
Subject: Re: Sql error during insert
If
You are missing a ) after the queryparam
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 10:15 PM
To: CF-Talk
Subject: Sql error during insert
I do not recall seeing this
If this is a true "copy and paste", you're missing your ending ')' in the
VALUES statement.
On 11/14/06, Doug Brown <[EMAIL PROTECTED]> wrote:
>
> I do not recall seeing this before. Could someone tell me what I am doing
> wrong? I get the following error while executing this query.
>
> Erro
I do not recall seeing this before. Could someone tell me what I am doing
wrong? I get the following error while executing this query.
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax
near '@P1'.
INSERT INTO ca
Hi everyone first post and unfortunately it had to be OT... Here's the
scoop...
Real new to SQL, currently reading through CF7 Web application
construction kit and the install script for the MySQL data for this book
is throwing me this error:
You have an error (1064) in your SQL syntax; check th
Rick Root wrote:
> Anyone ever seen this?
>
> Error Occurred While Processing Request
> 7 >= 7
>
> the query is a simple select query...
>
> SELECT * FROM GALLERY_PHOTOS
> where
> blog_id=
> and gallery_id= value="#GALLERY_ID#">
>
> (I don't know what database is involved, the person who report
Anyone ever seen this?
Error Occurred While Processing Request
7 >= 7
the query is a simple select query...
SELECT * FROM GALLERY_PHOTOS
where
blog_id=
and gallery_id=
(I don't know what database is involved, the person who reported this
bug to me didn't specify... she also said it was sporadi
1, 2005 4:31 PM
To: CF-Talk
Subject: RE: SQL Error
I recently had this same issue with a site that was switched from CF5 to
MX61. Client storage DB was choking on the CFDATA table's data field which
is also a memo field. Solved it by creating a new data source in CFadmin
using the Access d
Doug
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: April 1, 2005 2:27 PM
To: CF-Talk
Subject: SQL Error
Does anyone know why this would occur?
Error Executing Database Query. [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Microsoft Access D
D]
Sent: 02 April 2005 00:50
To: CF-Talk
Subject: Re: SQL Error
But there is no decimals in this.
Adrian Lynch wrote:
>I'm not too hot with Access but if that were SQL Server my first thought
>would be to look at decimal datatypes.
>
>Ade
>
>-Original Message-
&
April 2005 23:27
>To: CF-Talk
>Subject: SQL Error
>
>
>Does anyone know why this would occur?
>
> Error Executing Database Query. [Macromedia][SequeLink JDBC
>Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid
>precision value
>
>I am using
I'm not too hot with Access but if that were SQL Server my first thought
would be to look at decimal datatypes.
Ade
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: 01 April 2005 23:27
To: CF-Talk
Subject: SQL Error
Does anyone know why this would
Does anyone know why this would occur?
Error Executing Database Query. [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid
precision value
I am using MS-Access and using CFQUERYPARAM tags. The tags are specified
properly such
as Integer or
YES ! Thank you... was using it for the INSERT but not for the
SELECT... rumor has it that it should be used for EVERYTHING... but
alas I find it hard to buckle down and upgrade all the queries.
Thanks Pete,
Very Much Appreciated!
Gonz
On Fri, 19 Nov 2004 16:12:55 -0500, Pete Freitag <[EMAIL PR
Yep '\ is reserved in Postgres, and CF doesn't escape it like it
auto-escapes apostrophe.
I think \\ is the escape for it, so turning
'H:\UpLoadImages\CmosPic.jpg' into 'H:\\UpLoadImages\\CmosPic.jpg' may
work. Also, cfqueryparam may clear it up completely.
Someone here is bound to know more
Try using the CFQUERYPARAM tag
__
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/
~|
Special thanks to the CF Community Suite G
> after an insert... the inserted record can not be found...
> it's there, I can see it but this query returns with zero
> records found.
>
> The Details:
> First:
> INSERT INTO DocsList
> (DocsList_ID,filename)
> VALUES (746,'H:\UpLoadImages\CmosPic.jpg')
>
> then sometime later we Check
after an insert... the inserted record can not be found... it's there,
I can see it but this query returns with zero records found.
The Details:
First:
INSERT INTO DocsList
(DocsList_ID,filename)
VALUES (746,'H:\UpLoadImages\CmosPic.jpg')
then sometime later we Check4Duplicate with:
SELE
Why would I get this SQL error : Error converting data type varchar to numeric on one filed and not another when I do a submit from a form even though they are setup the same. Both are numeric in the SQL table.
I'm entering them this way:
INSERT INTO purchaseorders
(
ponumber,
cn
This parameter value: (param 15) = [type='IN', class='java.lang.Double',
value='44.5', sqltype='CF_SQL_MONEY']
is creating the following error: Error Executing Database Query. Invalid data
for CFSQLTYPE CF_SQL_DOUBLE.
This is storing a value to a MS Access DB field that has data type of
currency
: Encrypt() putting single quote in string, causes SQL error when
trying to SELECT
Hi,
Have an interesting problem. I'm using Encrypt() to store sensitive user
data in SQL Server. On some strings, the function is encrypting with a
single quote as one of the chars. This is causing a SQL
Hi,
Have an interesting problem. I'm using Encrypt() to store sensitive user
data in SQL Server. On some strings, the function is encrypting with a
single quote as one of the chars. This is causing a SQL error when I'm
trying to either enter or retrieve the data with cfquery.
Has
:http://www.euservices.com
__
> -Original Message-
> From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 10:47 AM
> To: CF-Talk
> Subject: RE: Unusual SQL error
>
>
> Bil
:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 10:36 AM
To: CF-Talk
Subject: RE: Unusual SQL error
That should fix it.
__
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:
-1299WWW:http://www.euservices.com
__
> -Original Message-
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 10:34 AM
> To: CF-Talk
> Subject: RE: Unusual SQL error
>
>
>
Thanks,
I added the option (maxdop 1) to the end of the query to set the max degree of
parallism to 1
-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 9:30 AM
To: CF-Talk
Subject: RE: Unusual SQL error
Sounds to me like when SQL created it&#
http://www.euservices.com
__
> -Original Message-
> From: Creese, Eric [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 04, 2003 1:17 PM
> To: CF-Talk
> Subject: Unusual SQL error
>
>
> I never have received this e
I never have received this error before.
[Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query parallelism caused
your server command (process ID #52) to deadlock. Rerun the query without
intra-query parallelism by using the query hint option (maxdop 1).
Can anyone give some insite?
---
Quoting integers in SQL Server is valid, and can help protect against some
hack attempts.
-Justin Scott
- Original Message -
From: "Randell B Adkins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 10, 2003 10:00 AM
Subject: Re:
apping the table
name in brackets such as [2da] and see if that works.
-Justin Scott
- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 10, 2003 9:58 AM
Subject: OT: SQL Error with Syntax
If the weight field is number then it should be weight = 30 and not
weight = '30'
>>> [EMAIL PROTECTED] 03/10/03 09:58AM >>>
OK, I cannot see where this SYNTAX error is can anyone else see the
possible problem? Below are two queries, both are the same, one is
PRE-CF (variables) one is POST CF af
OK, I cannot see where this SYNTAX error is can anyone else see the possible problem?
Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF
after CF processes the variables that makes it a query.
> (WHERE weight <= '30') Is just what is outputted in the error,
I think I must be the king of strange errors and events, but I do have
another one to ask about.
Today, all of our applications on one server which all have been
performing for over a year with client variables in a SQL database
started showing up with the following error.
An error occurred while
I am getting a very non-descript error in CFMX when doing a query on
query. Has anybody seen this error before? I have posted the CFMX/SQL
code below as well.
Thanks
- Error Message -
Error casting an object of type java.lang.boolean to an incompatible
type. This usually indicates a p
;, 'decimal' etc
If you've auto-upsized your access db to SQL and all the values in an access
'number' field were integers, the upsizer would probably create a SQL field
with type 'int'.
HTH
Alex
> -Original Message-
> From: Ed Gordon [mailto:[EMAIL PRO
This ran just fine using Microsoft Access. Now I get an overflow?
Can you spot what's wrong? The values in the fields aren't very big - the
largest is like 1952 to which I'm adding 20 or 30 or so...
=
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC SQL Server
lto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 11:26 AM
To: CF-Talk
Subject: strange SQL error
I have a action page that accepts any form page and its variables then based
on the stored proc "sp_columns" builds sql statment for update or insert.
When I try to use it I get an Date
I have a action page that accepts any form page and its variables then based on the
stored proc "sp_columns" builds sql statment for update or insert.
When I try to use it I get an Datefield overflow error (SQL 2000). But if I output
the sql statment and then copy and past it into my sql enter
> But isn't it what's happening with the "hotspot" problem? -
> the query is done, but the database still has the page locked.
I seriously doubt that your problem is occurring because of one individual
instance of your page running. However, if you have more than one person
adding records at the
ED]]
Sent: Friday, May 17, 2002 1:07 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: What is this SQL Error?
> I thought about using cftry/cfcatch, but what if my second
> attempt is still done before the table is again available...
> I was wonde
> 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"?
No, it doesn't, but I don't think that matters, since CF's processing
lto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:50 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
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 lo
> 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?
It has to wait until the database server returns a message, before
continuing.
riday, May 17, 2002 12:46 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: What is this SQL Error?
> 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..
:) yes, I guess I can do that!
Thanks
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:40 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
I guess you could wait for a return code from the SP and test for it in your
code. Used to do this
> 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?
I'm pretty sure that CF will handle this for you; CF won't call t
(LNG) [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:27 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
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
> 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 table in each iteration.
Well
(LNG) [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:27 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
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
pass code through notepad if I've touched anything like Word or
Wordpad
for example because of the illegal characters.
Margaret
-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 9:25 AM
To: CF-Talk
Subject: RE: Strange SQL error
What
x27;[EMAIL PROTECTED]'
Subject: RE: What is this SQL Error?
> I'm trying to figure out if ColdFusion locks the whole table
> when running a cfquery.
This is entirely dependent on the database. CF is just a regular database
client, like any other database client.
> I'm
o: CF-Talk
Subject: RE: Strange SQL error
uh?
> -Original Message-
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: 17 May 2002 17:18
> To: CF-Talk
> Subject: RE: Strange SQL error
>
>
> Right fixed it - all we did was to move the declaration of
> the Ju
uh?
> -Original Message-
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: 17 May 2002 17:18
> To: CF-Talk
> Subject: RE: Strange SQL error
>
>
> Right fixed it - all we did was to move the declaration of
> the JuryTitle
> param to the bottom
Right fixed it - all we did was to move the declaration of the JuryTitle
param to the bottom of the list and itr works! SQL schmeequel
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 16:50
To: CF-Talk
Subject: RE: Strange SQL error
I assume in this bit
> I'm trying to figure out if ColdFusion locks the whole table
> when running a cfquery.
This is entirely dependent on the database. CF is just a regular database
client, like any other database client.
> I'm getting those deadlock errors in production, where too
> many people access the same
If you're getting a deadlock error, chances are that it has to do with the
order that your queries are going. If you have one page with a transaction
that starts with an insert to Table A and then updates all the rows in Table
B while you have another page with a transaction that inserts into Tab
ah - yes sorry - forgot to change it back
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 16:50
To: CF-Talk
Subject: RE: Strange SQL error
I assume in this bit:
VALUES (
@CountryID
, @JuryName
, @test
tryID
, @JuryName
, @JuryTitle
, @JuryCompany
, @JuryCity
, @JuryTypeID
?
> -Original Message-
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: 17 May 2002 16:56
> To: CF-Talk
> Subject: Strange SQL error
&g
res me that it would lock at row level, so I'm guessing ColdFusion is
requesting a lock at table level somewhere. Is there a CFAdmin setting for
this?
-Original Message- From: Houk, Gary
[<mailto:[EMAIL PROTECTED]>] Sent: Tuesday, April 16, 2002 3:06
PM To: CF-Talk Subject: What is
In all my time developing SQL I have never come across sommat like this -
please someone tell me I'm being stoopid as it's a Fri
afternoon.
I have the following SP which refuses to release - it says it cannot find
parameter @JuryTitle. If I comment out @JuryTitle and the corresponding
That's exactly what happened. The datasource was there but with no database
specified on one of the servers.
>From: Dave Watts <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: sql error
>Date: Wed, 15 May 2002
> > I think I figured it out. I have a web farm and the database
> > name was not specified on one of the server's CF Admin.
>
> that's not it. That would give you a DATASOURCE NOT FOUND
> error. Chances are you just mapped to the wrong DB somewhere
> or your permissions are screwed up somehow.
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 3:31 PM
To: CF-Talk
Subject: RE: sql error
I think I figured it out. I have a web farm and the database name was not
specified on one of the server's CF Admin.
thx
>From: "S R" <[EMAIL PROTECTED]>
I think I figured it out. I have a web farm and the database name was not
specified on one of the server's CF Admin.
thx
>From: "S R" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: sql error
>Date: Wed
m: "Matthew Walker" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: sql error
>Date: Thu, 16 May 2002 10:18:41 +1200
>
>Um, wild guess . . . no Products table? Are you referencing the wrong
>database?
>
&
age-
> From: S R [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 16 May 2002 10:13 a.m.
> To: CF-Talk
> Subject: sql error
>
>
> This one is driving me nuts. I keep getting a 'Base table not
> found error'.
> Invalid object name 'Products'.
>
> This is
-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wed 5/15/2002 5:12 PM
To: CF-Talk
Cc:
Subject: sql error
__
Structure your ColdFusion code with Fusebox. Get the
This one is driving me nuts. I keep getting a 'Base table not found error'.
Invalid object name 'Products'.
This is my query:
SELECT Industries.name as industryName, Products.name as
productName,
Products.version, Products.prefix, Products.ID as prodID
FROMProduc
are you sure you are using transaction statements.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 4:11 PM
To: CF-Talk
Subject: RE: What is this SQL Error
Thanks Bob...I'll let you know if I find a workaround.
- Gary
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 4:11 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
We've run into this from time to time, it occurs when two or
lto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 3:06 PM
To: CF-Talk
Subject: What is this SQL Error?
First time I've seen this one...what does it mean?
Diagnostics: ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID
60
First time I've seen this one...what does it mean?
Diagnostics: ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID
60) was deadlocked on {lock} resources with another process and has been
chosen as the deadlock victim. Rerun the
After re-starting sql server2000 sp2, I have noticed the following error in
the CF log files. Its happening sporiacally for the users. Then if they hit
refresh once it happens, the page will execute successfully.
Can't find anything on Microsoft's site about it or in the actual sql server
lo
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2002 16:16
To: CF-Talk
Subject: RE: SQL Error, I know
Thanks everyone! You guys are the best!
D-
> You would have to have admin rights to the SQL server to increase the
space.
> Have your ISP check to see how much free spa
space needs to be added.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 19, 2002 11:06 AM
> To: CF-Talk
> Subject: RE: SQL Error, I know
>
>
> Is there any solution?
> > If you are running SQL on SBS there i
ECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 11:06 AM
To: CF-Talk
Subject: RE: SQL Error, I know
Is there any solution?
> If you are running SQL on SBS there is a maximum size to your filegroups
> (which you can easily reach). It sucks believe me
>
>
:[EMAIL PROTECTED]]
> Sent: 19 March 2002 16:02
> To: CF-Talk
> Subject: RE: SQL Error, I know
>
>
> Not quite sure. Our ISP is hosting our CF Web site
> along with SQL 2000. The ISP's Adminsitrator is trying
> to tell me it's a Professional Services reques
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 19, 2002 10:01 AM
Subject: RE: SQL Error, I know
> Not quite sure. Our ISP is hosting our CF Web site
> along with SQL 2000. The ISP's Adminsitra
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 19 March 2002 15:48
> > To: CF-Talk
> > Subject: Re: SQL Error, I know
> >
> >
> > > ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
> > > Server]Could not allocate space for
> >
If you are running SQL on SBS there is a maximum size to your filegroups
(which you can easily reach). It sucks believe me
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2002 16:02
To: CF-Talk
Subject: RE: SQL Error, I know
Not quite sure. Our
ull it's your
> filegroup (SQL groups data/objects into filegroups). By any chance are you
> running SQL on SBS (Small business Server)?
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 19 March 2002 15:48
> To: CF-Talk
> Subject:
15:48
To: CF-Talk
Subject: Re: SQL Error, I know
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Could not allocate space for
> object 'Tmp_samp_request' in database 'hititte4_db'
> because the 'PRIMARY' filegroup is full.
is that db set t
1 - 100 of 151 matches
Mail list logo
