It has sort of worked for me, this property works fine <property name="OrderNumber" type="string" column="`Order`" />
however what you can't do is <property name="Order" type="string" column="`Order`" /> because transfer will generate sql like SELECT `Order` AS Order FROM ... I'm coming to transfer after a while working with reactor which escapes every column and table name using dbms specific syntax, so maybe i've been a bit spoiled ;-) Cheers, Chris 2008/11/19 Mark Mandel <[EMAIL PROTECTED]> > > '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 refreshed? > > Mark > > On Thu, Nov 20, 2008 at 4:45 AM, Chris Blackwell <[EMAIL PROTECTED]> > wrote: > > 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 > >> > > > > > > > > > > > > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
