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.
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
