Title: CCTApp Error
Thread: CCTApp Error
Forum: Need Help?
Conference: ColdBox
User: miked
Hi,
I am having trouble with the CCTApp. I have tried using the included
mssql.sql script to create the table and UDF (I am using MS SQL 2000), but it
errors out with "unable to find sys.objects".
I then created the table
manually and now I get the error "Incorrect syntax near the keyword 'WITH'". If
I replace the query (name=stReturn.results) with a simple
Select * From
[#arguments.tableName#] Where 0=0
it works. Anyone figure out what is
happening with this query?
Thanks!
Mike