0

How do I enclose table name (sql server) containing space while mapping files using d2rq language? table name is Compression Stats

So in my mapping file I have among other things:

d2rq:condition "Compression Stats.VelocityID = '2145C'" ;

I tried [], ```, () around table, and table.column, but nothing is working. Does anyone know?

Jens Piegsa
  • 7,399
  • 5
  • 58
  • 106
Angelina
  • 2,175
  • 10
  • 42
  • 82
  • 2
    I don't know anything about d2rq, but maybe you could create a view onto [Compression Stats] that doesn't contain a space in the name. –  Sep 19 '13 at 21:14
  • 1
    Try double quotes (`"`), they are name delimiters in standard SQL (Transact-SQL supports them too), perhaps they'll be recognised by this `d2rq` thing. I guess you'll need to escape them somehow, as they are also string delimiters in this language you are using. – Andriy M Sep 19 '13 at 21:26
  • 1
    Have you tried double-quotes. I have seem Crystal Reports do double-quotes for SQL Server names. – Steve Sep 19 '13 at 21:27

1 Answers1

0

This is a bug in d2rq mapping. and until they fix it, I will just have to remove space in my table name

Angelina
  • 2,175
  • 10
  • 42
  • 82