Re: How to turn on backquotes

[prev] [thread] [next] [Date index for 2005/05/24]

On Saturday 21 May 2005 08:07, Tony Bowden wrote:
> On Fri, May 20, 2005 at 11:49:38PM +0100, David Baird wrote:
> > Is there any way to automatically surround column names with backquotes?
> > I'm using Maypole on a database where some of the columns are reserved
> > words
>
> Not yet.
>
> It's planned for a later release.
>
> In the general case I'd suggest you try overriding the name() method in
> Column, but if you're working with Maypole, it might not like that.
>
> Tony

Lots of things didn't like it. I've implemented it instead in transform_sql() 
and put it on CPAN as Class::DBI::Plugin::Backtickify. I'm nervous about a 
few things it does which I've described in the pod, but it does seem to be 
working OK. 

Cheers,

d.