Something that's happened to me before is that, depending on what you used to write the code originally, a hidden illegal character may have been introduced. When you moved it, once again depending on what you were using, the cut and paste would eliminate any illegal characters.
I usually 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 Andy meant was that he moved the @JuryTitle param to the bottom of the list like so: -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryCompany varchar(50) , @JuryCity varchar(50) , @JuryTypeID int , @JuryTitle varchar(50) @JuryTitle was originally declared after the second param @JuryName. For some reason the SP then released perfectly. Bizarrely I then moved the @JuryTitle param back to where it was and then the SP relases again. For the last 2 hours the SP would not release and we are at a loss as to why it didn't work. Any Ideas SQL gurus what may have happened? -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:10 To: 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 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. > > > > > > > > ______________________________________________________________________ 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
