Can you show us some of the procedure? The error is pretty self explanatory so we will need to see a little more that that
-----Original Message----- From: Stephen M [mailto:sgmul...@gmail.com] 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 cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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 cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.