I assume in this bit:
VALUES (
@CountryID
, @JuryName
, @test
, @JuryCompany
, @JuryCity
, @JuryTypeID
you're actually using
VALUES (
@CountryID
, @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
>
>
> 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
> field insert it works. If I change the name of the variable it
> doesn't............someone slap me with a kipper so I can see
> where I've
> gone wrong...........
>
> CREATE PROCEDURE JuryInsert
>
> -- Any parameters here
> @CountryID int
> , @JuryName varchar(100)
> , @JuryTitle varchar(50)
> , @JuryCompany varchar(50)
> , @JuryCity varchar(50)
> , @JuryTypeID int
>
> AS
>
> BEGIN
>
> INSERT INTO tblJury (
> CountryID
> , JuryName
> , JuryTitle
> , JuryCompany
> , JuryCity
> , JuryTypeID
> )
> VALUES (
> @CountryID
> , @JuryName
> , @test
> , @JuryCompany
> , @JuryCity
> , @JuryTypeID
> )
>
> IF @@error <> 0
> BEGIN
> GOTO ERROR_EXIT
> END
>
> RETURN @@error
>
> ERROR_EXIT:
> RETURN @@error
>
>
> END
> GO
> ------------------------------------------------------------------
> Andy Ewings
> Director
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> ------------------------------------------------------------------
> United Kingdom
> http://www.thoughtbubble.net
> Tel: +44 (0) 20 7387 8890
> ------------------------------------------------------------------
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 419 4235
> ------------------------------------------------------------------
> The information in this email and in any attachments is
> confidential and
> intended solely for the attention and use of the named
> addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further
> distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy,
> distribute, or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
