On Jan 13, 7:17 pm, "Steve Onnis" <[email protected]> wrote: > Can you show us some of the procedure?
Its about 1200 lines so its not really practical. In any case, SSMS would tell me if it was a SQL syntax error. We've been using this same stored proc for a few years without any problem. All I did was add in some new columns to some temp tables and ColdFusion started to complain. Maybe its the size that's the problem because it was only 800 lines before I started. Too much business logic in the database. > > The error is pretty self explanatory so we will need to see a little more > that that > > > > > > > > -----Original Message----- > From: Stephen M [mailto:[email protected]] > Sent: Friday, 13 January 2012 6:37 PM > To: cfaussie > Subject: [cfaussie] bizarre CF9 sql server error > > I am calling this stored proc in a sql server 2005. (actually version is > 10.50.1617) is that 2005 or 2008? > > This stored proc runs fine from with SQL Server Management Studio (SSMS). I > can compile it and call it and it returns the data. BUT, when I call it > from my CF9 app I get this error as below. between the lines. > So CF9 is telling me that my stored proc has incorrect syntax even though > SQL Server Management Studio thinks it is fine. > > I've double checked every line of code that has "from" and there is nothing > unusual going on. I even created a new CF user with sysadmin rights just to > rule out some kind of permissions error. Because it compiles OK in SSMS I > cannot get a line number for this error. > > Does the CF9 JDBC driver recompile the stored procs before it runs them? > > ============== > Message Error Executing Database Query. > Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax > near the keyword 'from'. > =============== > > regards, > Stephen > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
