Luis Majano Forums Notification: Post to CCTApp Error

Title: CCTApp Error
Thread: CCTApp Error
Forum: Need Help?
Conference: ColdBox
User: miked


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?