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 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:
>
> 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.
> >
> >
> >
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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