-
From: transfer-dev@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of Mark Mandel
Sent: 23 November 2008 06:24
To: transfer-dev@googlegroups.com
Subject: [transfer-dev] Re: Escaping reserved column names
Its not crazy Chris, and it has come up as an enhancement ticket previously
Arrghh.. I'm afraid my reserved word nightmare continues ...
I have a table called Contact which has a column named Primary - ooh lovely
i hear you all say :)
I used backticks around the column name and aliased the column to
isPrimary to get transfer working.
object name=Contact
Its not crazy Chris, and it has come up as an enhancement ticket previously:
http://tracker.transfer-orm.com/issue.cfm?p=89977683-A728-9CD3-ABD9545A91734422i=0D079B94-C0FA-6455-DF8C9502C74BB3A7
Honestly, there hasn't been that much demand for it, so it never been
a huge priority.
Mark
On
, November 19, 2008 11:09:20 PM
*Subject:* [transfer-dev] Re: Escaping reserved column names
Hi Stephen,
Fortunately this db schema is not of my design and unfortunately i'm not
able to change it.
Most applications have a User table, if those users are organized then
there may be a Group table
2008/11/20 Alan Livie [EMAIL PROTECTED]
I prefer Users, Groups, Orders as my db tables avoids the reserved
words problem I have an Order class and object though but my db tables
are plural.
I'm with Stephen on this. Reserved words as table and column names annoy me
too
This is
'Order' is just a reserved word in SQL, so it will throw an error when
you attempt to use it without escaping it.
By changing the XSD to allow back ticks (should be a small change),
I'm surprised it didn't work out for you. Did you recreate Transfer
between attempts, to ensure the meta data was
2008/11/19 Mark Mandel [EMAIL PROTECTED]
Ah yeah.. that's not going to work.
It is a limitation of Transfer.
Probably quite a good limitation.
Not sure why you would want to allow or continue to use badly formed sql.
To be honest, if you're building something new and have the access to
Hi Stephen,
Fortunately this db schema is not of my design and unfortunately i'm not
able to change it.
Most applications have a User table, if those users are organized then there
may be a Group table, and if theres any kind of ecommerce or whatever going
on then it might have a Order table.
: Chris Blackwell [EMAIL PROTECTED]
To: transfer-dev@googlegroups.com
Sent: Wednesday, November 19, 2008 11:09:20 PM
Subject: [transfer-dev] Re: Escaping reserved column names
Hi Stephen,
Fortunately this db schema is not of my design and unfortunately i'm not able
to change it.
Most applications have