looks like its a DAL issue,
The DAL need to include the [ ] by default around column names, I also
tested using " " around the columns and it works too.
Hopefully Massimo you will look at this, in the meantime I will try to hack
my way in the source files.
here is a code I tested outside w2p :
con = pyodbc.connect('DRIVER={SQL
Server};SERVER=chi-c7269ceba93\\SQLEXPRESS;DATABASE=SambaData2;UID=sa;PWD=sambapos.1234')
cur = con.cursor()
>>> x = cur.execute('select * from MenuItems')
>>> x = cur.execute('select Id, Order from ScreenMenuCategories')
Traceback (most recent call last):
File "<pyshell#15>", line 1, in <module>
x = cur.execute('select Id, Order from ScreenMenuCategories')
ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server
Driver][SQL Server]Incorrect syntax near the keyword 'Order'. (156)
(SQLExecDirectW)")
>>> x = cur.execute('select "Id", "Order" from ScreenMenuCategories')
>>> for i in x:
print i
(1, 0)
(2, 0)
(3, 0)
(4, 0)
(5, 0)
(6, 0)
(7, 0)
>>> x = cur.execute('select Id, [Order] from ScreenMenuCategories')
>>> for i in x:
print i
(1, 0)
(2, 0)
(3, 0)
(4, 0)
(5, 0)
(6, 0)
(7, 0)
