At night I'm working in MySQL and days now my job is to convert Access to SQL Server and build some webapps around them, so please forgive me for the simpleness of this.
I have a connection to a remote server that has a table with some data (all imported). However the column names have spaces in them. So when I perform my query...
@For Each row in db.Query(QueryString)
Next
I'm trying to create a row in a table using @:<tr><td>@row.x</td></tr>, however it's failing when x has a space in it. Additionally I tried @row.[x] and it still fails. Any ideas? Or a article/page that can point me in the right direction?
Thanks.
