'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 transfer-dev@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
