a missed comma (or space/carriage return) when moved to CF? For it to complain before the FROM clause is IMHO the clue.
divide and conquer until it's found perhaps? On Sat, Jan 14, 2012 at 10:20 AM, Stephen M <[email protected]> wrote: > > > 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. > > -- 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.
