Title: RE: CCTApp Error
Thread: CCTApp Error
Forum: Need Help?
Conference: ColdBox
User: miked
Here's snippets from the debug output:
[code]
ID: CFQUERY
LINE: 96
Template:
D:\coldbox\coldbox\samples\applications\CCTApp\model\appUser\appUserGateway.cfc
[/code]
[code]
Database Driver Error Message:
[Macromedia][SQLServer JDBC
Driver][SQLServer]Incorrect syntax near the keyword 'WITH'.
[/code]
[code]
SQL Sent:
WITH [sqlStatement] AS ( SELECT
AppUserId,Username,Password,FirstName,LastName,Email,UpdatedOn,CreatedOn,isActiv
e, ROW_NUMBER() OVER( ORDER BY AppUserId asc ) AS rowNumber FROM [AppUser] WHERE
0 = 0 ) SELECT * FROM [sqlStatement] WHERE rowNumber BETWEEN (param 1) AND
(param 2)
[/code]
[code]
Current Event: ehAppUser.dspAppUsers
[/code]