> 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 to grow? if so, your disk is probably filled. if
not, allow it to grow...
__
Your database is full. Allocate more space for it in Enterprise Manager.
Dan Phillips
CFXHosting.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 10:42 AM
To: CF-Talk
Subject: SQL Error, I know
I know this is suppose to be for
I know this is suppose to be for CF stuff, but I know
someone can help with this. I'm under the gun here.
I'm getting this SQL 2000 error message when I try to
add a new column to an existing table that's filled with
data.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Could not
That might be it.
Good Catch!!
-Original Message-
From: Justin Greene [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 4:45 PM
To: CF-Talk
Subject: RE: weird sql error
How about the missing comma in the Values part of your query... looks like
a temp stored procedure is being
> To: CF-Talk
> Subject: weird sql error
>
> I keep getting a really strange sql error and I don't know
> what the heck
> it's coming from.
>
> ===
> DETAIL: [Microsoft][ODBC SQL Server Driver][SQL Server]Line
> 33: Incorr
I keep getting a really strange sql error and I don't know what the heck
it's coming from.
===
DETAIL: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 33: Incorrect
syntax near '@P11'.
SQL = "SET NOCOUNT ON INSERT INTO images ( ar
Has anyone ever had this problem:
ODBC Error Code = 08S01 (Communication link failure)
We started getting this error message at the bottom of all our pages out of
nowhere, and I can't figure out why or how to get rid of it.
I'm using CF 4 to connect to Microsoft SQL 7.
jim
Never mind. I figured it out. My tempdb was out of room. I just had to create a new
device on the SQL Server and then alter the tempdb to use the new device that I
created. Man, I cannot wait until we upgrade to SQL 2K (Currently are on SQL 6.5)
CTED]>
Sent: Friday, August 24, 2001 11:35 AM
Subject: RE: Invalid SQL error - need help
>
> Entire Query is below:
>
>
> select sfbetrm_pidm, stvcnty_desc,stvcnty_code
> from stvcnty,spraddr y,sgbstdn x, sfbetrm
> where
> spraddr_pidm = sgbstdn_pidm
> and
sgbstdn_levl_code in('50','54')
and x.sgbstdn_term_code_eff =
(select max(sgbstdn_term_code_eff)
from saturn.sgbstdn
where sgbstdn_pidm = x.sgbstdn_pidm
and sgbstdn_term_code_eff <= '200104')
and spraddr_seqno =1
and spraddr_atyp_code ='MA'
and stvcnty_code i
Ah yes, you are correct on that renaming. I wasn't catching that that was
what you were doing. Sorry.
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at
sgbstdn_levl_code in('50','54')
and x.sgbstdn_term_code_eff =
(select max(sgbstdn_term_code_eff)
from saturn.sgbstdn
where sgbstdn_pidm = x.sgbstdn_pidm
and sgbstdn_term_code_eff <= '200104')
and spraddr_seqno =1
and spraddr_atyp_code ='MA'
and stvcnty_code i
age -
From: "Jim Watkins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 24, 2001 8:34 AM
Subject: Invalid SQL error - need Help
> I am running CF 5 and accessing an Oracle 7 database using Oracle SQL
> When I run this Query in
r" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 24, 2001 9:50 AM
Subject: Re: Invalid SQL error - need Help
>
> Well, you have a couple of problems. The first is that you're missing a
> comma: (inserted after stvcnty_desc). The s
Well, you have a couple of problems. The first is that you're missing a
comma: (inserted after stvcnty_desc). The second problem that you'll find is
that you're not grouping by county, which you need to do if you're grouping
by stvcnty_desc and counting fcount.
select stvcnty_desc, county, count(*
I am running CF 5 and accessing an Oracle 7 database using Oracle SQL
When I run this Query in a Query:
select stvcnty_desc county,count(*) fcount
from STUDENTS
group by stvcnty_desc
ORDER BY county
I get this error:
"Query Manipulation Error Code = 0 Invalid SQL"
If I comment out this que
I have a template that strips out HTML code from a string. It then takes the
first 255 chars to create a blurb that is used as a summary in a verity
collection. When I try to insert the blurb in the DB, I get the following
SQL error:
ODBC Error Code = 37000 (Syntax error or access violation
Do you have an update trigger on the table?
-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 2:33 PM
To: CF-Talk
Subject: Strange SQL Error...
Has anyone seen this?
There are no "subqueries" going on in this SQL statement.. But
D]]
Sent: Wednesday, April 04, 2001 12:33 PM
To: CF-Talk
Subject: Strange SQL Error...
Has anyone seen this?
There are no "subqueries" going on in this SQL statement.. But yet we get
this error.
==
ODBC Error Code = 21000 ()
[Microsoft][ODBC SQL Server Driver][SQL Server]S
Has anyone seen this?
There are no "subqueries" going on in this SQL statement.. But yet we
get this error.
==
ODBC Error Code = 21000 ()
[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more
than 1 value. This is not permitted when the
subquery follows =, !=, <, <
Jeff
It's not a silly error, but exactly what it says...
Your second value is 2330 characters long...
a 2,000 char field fills up quickly, doesn't it!
HTH
Dick
At 11:16 AM -0500 2/17/01, Jeff Davis wrote:
>Help?
>I'm sure this is a silly insert error but I just don't see the
>problem.
Guys.
Jeff Davis
- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 2:31 PM
Subject: Re: SQL error
>
> You may want to use a text field, not a char field.
>
>I
You may want to use a text field, not a char field.
I imagine the quotes in the insert may be cause of the problems. There are a
handful of statements that have an effect on the quotes. Look into htmleditformat()
first. I don't see any single quotes
in your insert, so preservesinglequo
Is that # hash mark in the color value causing you trouble?
- Original Message -
From: "Jeff Davis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 10:16 AM
Subject: SQL error
> Help?
> I'm sure this i
Help?
I'm sure this is a silly insert error but I just don't see the problem. The answer
filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the
field? Running CF 4.5 and SQL7.
ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server
Driv
Thanks. At this point I haven't seen the db design. I'll have to have a look
to see if there is a design flaw.
Duane
-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 10:54 AM
To: CF-Talk
Subject: RE: SQL Error
You get a dea
and resubmit the transaction.
If possible, change the design so that it can't happen.
Nick
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 3:27 PM
To: CF-Talk
Subject: SQL Error
Has anyone seen this error here before? What is the
01 3:27 PM
>To: CF-Talk
>Subject: SQL Error
>
>
>Has anyone seen this error here before? What is the cause and the fix?
>
>ODBC Error Code = 40001 (Serialization failure)
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID
>#17) was deadlocked
Has anyone seen this error here before? What is the cause and the fix?
ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID
#17) was deadlocked with another process and has been chosen as the deadlock
victim. Rerun your trans
I get the following intermittent error from my SQL 2000 Server:
Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 52 generated fatal exception c01d EXCEPTION_ILLEGAL_INSTRUCTION.
SQL Server is terminating this process.
Any suggestions?
Thanks,
Neil
~~
[mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 5:31 AM
To: CF-Talk
Subject: Re: SQL error (minus the mess)
Thankyou Thankyou (as I smile until my cheeks hurt)
I forwarded your suggestion through to my ISP - he followed your
instructions and it works like a charm.
Did I say Thank
gt;
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 4:42 PM
Subject: RE: SQL error (minus the mess)
> ok, second round.
>
> when setting up the datasource, did you restrict access to the SQL command
> set? in the CFAdministrator, under "ODBC Da
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Kylie Lovelock [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 2:46 AM
To: CF-Talk
Subject: Re: SQL error (minus the mess)
Thanks for taking the time Christopher. I removed the username and
; <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 3:29 PM
Subject: RE: SQL error (minus the mess)
> at just a quick glance, is the username/password combination valid for
that
> database? did you give access to the user "username"? access by default
> does not hav
ies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Kylie Lovelock [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 2:01 AM
To: CF-Talk
Subject: SQL error (minus the mess)
That was a really bad start - please accept my apologies for the mess. Let's
try agai
That was a really bad start - please accept my apologies for the mess. Let's
try again.
The page I have done up is a very simple test page with code:
SELECT * FROM input
I am using a Access 97 database, if that helps.
Remote, I am getting this error:
SQL operation unauthorized.
The SQL
>On that note, does anyone have a list of Microsoft SQL Error Codes?
They are listed in the online books online-reference.
If you like I'll post you a text file offlist.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EM
for Information Technology
Division of Computer System Services
-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 2:12 PM
To: CF-Talk
Subject: strange SQL error code
Anyone ever seen this one?
ODBC Error Code = 01004 (Data truncated
Anyone ever seen this one?
ODBC Error Code = 01004 (Data truncated)
[Microsoft][ODBC SQL Server Driver]Fractional truncation
On that note, does anyone have a list of Microsoft SQL Error Codes?
Please copy me with your reply.
Thanks
o: CF-Talk
Subject: Re: NEED HELP!! Ignore Previously SQL Error I posted. New SQL
Error 408
This is a multi-part message in MIME format.
--4FB7B0DD43D4F9E2FDA1BF6B
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
You mean like using SQL Query Builder in S
This is a multi-part message in MIME format.
--46E6CC4E93010FE7E8BA65C5
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
William,
ok, that worked...
But now I get my other error back SQL error 7008, inconsistent data?
How do I know when or when not to use
what sort of data feilds are the rows you are putting this stuff into?
datetime, char, varchar, etc...
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 2:27 PM
To: CF-Talk
Subject: Re: NEED HELP!! Ignore Previously SQL Error I posted. New
n
>
> -Original Message-
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 26, 2000 3:12 PM
> To: CF-Talk
> Subject: NEED HELP!! Ignore Previously SQL Error I posted. New SQL Error
> 408
>
> This is a multi-part message in MIME format.
> ---
AIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 26, 2000 3:12 PM
Subject: NEED HELP!! Ignore Previously SQL Error I posted. New SQL Error 408
> This is a multi-part message in MIME format.
> --294808483026881139F5AB7E
> Conten
October 26, 2000 3:12 PM
To: CF-Talk
Subject: NEED HELP!! Ignore Previously SQL Error I posted. New SQL Error
408
This is a multi-part message in MIME format.
--294808483026881139F5AB7E
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Ok, I understand what th
This is a multi-part message in MIME format.
--294808483026881139F5AB7E
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Ok, I understand what the error is saying, but I can't figure why it is
saying it. All my columns are set to the proper data types. I am r
This is a multi-part message in MIME format.
--349BCA69A7CAD89DC18E181D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I think I understand the error, but how comes it only happens on my
production server and not on my local development server. It works fin
Hi Pablo,
GROUP BY is an aggregate SQL function and must include all fields found in
the SELECT clause.
SELECT Name, PackageSent
FROM location
WHERE NOT PackageSent IS NULL
GROUP BY PackageSent, Name;
> I'm performing the following query to an Access database in a page:
>
>
> SELECT Name, Pac
.
Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315
- Original Message -
From: "Duane Boudreau" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, April
UP BY lname
ORDER BY lname
Duane Boudreau
CFExperts.Com
-Original Message-
From: Pablo Nevares [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 29, 2000 9:57 PM
To: [EMAIL PROTECTED]
Subject: SQL Error using 'Name' as field
I'm performing the following query to a
I'm performing the following query to an Access database in a page:
SELECT Name, PackageSent
FROM location
WHERE NOT PackageSent IS NULL
GROUP BY PackageSent;
However, I get this error when executing it:
-
Error Diagnostic Information
ODBC Error Code = S100
101 - 151 of 151 matches
Mail list logo