I've just tried editing the attribute definition for column in the xsd to
allow the backtick character, which allows me to use the following in my
object
<property name="Order" type="string" column="`Order`" />
but when i try and do a list() on the table i get an error because the
generated SQL doesn't include my backticks
* You have an error in your SQL syntax.. near 'Order, ID from*
However if i change the column name to be something other than Order it
works ok. Other columns don't seem to have this issue, is transfer looking
for reserved words and treating them specially?
<property name="Surname" type="string" column="`Surname`" />
<property name="OrderNumber" type="string" column="`Order`"
/>
generates this SQL
select `Surname` as Surname, `Order` as OrderNumber, ID from ...
I'm about 2 hours into using transfer so i've no idea whats going on here :)
Chris
2008/11/19 Chris Blackwell <[EMAIL PROTECTED]>
>
> Hi all,
>
> My clients db has a column "Order", which i need to use.
> I searched the list archive and found a thread about escaping reserved
> table names
>
> http://groups.google.com/group/transfer-dev/browse_thread/thread/d3fe14990464d26b/c18097e57e9ded11?lnk=gst&q=escape#c18097e57e9ded11
>
> It looks like this is done by including square brackets in the table
> definition. So i have 2 problems, this doesn't seem to work for
> <property column="" />, and secondly i'm using MySQL so it needs to be
> a backtick `
>
> I'm guessing this may have come up before, so hoping someone can point
> me in the right direction
>
> Cheers, Chris
> >
>
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
