table called user and dynamic data

playing around with LS and DD and I was getting an "incorrect syntax near User" error when I ran the DD project and selected Users.

changing the table name to SiteUser solved the problem so i'm guessing the use of the sql reserved word is killing it?

Hi Daren,

If you set quoteIdentifiers="true" on your LightSpeedContext then LightSpeed will quote the names and you will not have this issue with reserved words.

I hope that helps,

John-Daniel Trask

thanks, figured i must have been missing something