Ajax DataGrid Support Product Page

Bug with Access/ASP using Datagrid

Reported 19 Feb 2011 09:37:13
has this problem
19 Feb 2011 09:37:13 David volle posted:
When using the datagrid with MS Access database and ASP the grid does not support a field if the field name is numeric. I have a table with data where the columns are years, and when DW creates a recordset the values come back fine, but with Datagrid recordset the values for all data in the 1991 column is 1991 etc. Perhaps when using access the field names may need to be wrapped in brackets IE [1991] so that the number is interpreted as a field instead of as a numeric constant. To prove this out I temporarily changed the field to y1991 and it works fine with the alphanumeric name but not with a numeric column name.
Thanks for any help you can provide.


Replied 08 Mar 2011 13:06:22
08 Mar 2011 13:06:22 Miroslav Zografski replied:
Hello David,

I'll have this added for next update if it is not a big deal of change. Otherwise will need to stall it till the update after next.


Reply to this topic