I know its not an easy enough task but I think Transfer should respect the quoting rules for the given RDBMS. That is, Transfer should be configured with the RDBMD type (e.g. MySQL, Oracle, etc) then have an adaptor which implements the quote() method which knows how to enclose identifiers appropriately. The MySQL adaptor would enclose identifiers in backticks, for instance.
However, one could make an argument that this breaks CFs DB-agnosticism which is already achieved by using JDBC under the hood. On the other hand, every ORM that I know of has knowledge of the underlying RDBMS type and issues SQL that is tailored appropriately. /Cody On Wed, Dec 9, 2009 at 10:39 AM, Ryan Lynch <[email protected]> wrote: > As an aside I went ahead and modified the database schema to use case > insensitive identifiers. I suppose that time could have been better > spent creating a patch for Transfer. ;-) > > Ryan > > On Dec 7, 5:12 pm, Mark Mandel <[email protected]> wrote: >> Elliot - want to provide a patch? ;o) >> >> Mark >> >> >> >> >> >> On Tue, Dec 8, 2009 at 9:09 AM, Elliott Sprehn <[email protected]> wrote: >> > Transfer should really do this by default for all SQL it generates >> > without specifying anything. ANSI SQL specifies double quotes around >> > identifiers and I don't know of any database that doesn't support it >> > if the connection is setup right. >> >> > It should just be a single quoted-identifiers="true" option, and not >> > character generic. This is in ANSI after all. >> >> > On Dec 7, 3:50 pm, Mark Mandel <[email protected]> wrote: >> > > Hmnn.. I don't know if this possible at this stage. >> >> > > Single quotes you can use in the XML file, but double is going to be >> > tough >> > > inside XML. >> >> > -- >> > Before posting questions to the group please read: >> >> >http://groups.google.com/group/transfer-dev/web/how-to-ask-support-qu... >> >> > 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 >> >> -- >> E: [email protected] >> T:http://www.twitter.com/neurotic >> 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 -- 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
