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
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
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 =, !=, <, <
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
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
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
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
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
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
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
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.
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
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
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
>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:[EMAIL PROTECTED]
--
15 matches
Mail list logo