[Maypole] Problem with unusual column names

Sai Nelson Tong sai.nelson.tong@gmail.com
Fri, 6 Aug 2004 03:37:00 -0400


I am trying to use Maypole to display data from a table wich unusual
column names such as, for examlpe:  p-m-abc   or o-/m-/2,5

Then Maypole will give the following error when enter the url to
'list' the content of the table:

undef error - DBD::mysql::st execute failed: Unknown column 'p' in
'field list' [for Statement "SELECT ......."] at
/usr/lib/perl5/site_perl/5.8.3/DBIx/ContextualFetch.pm line 57.

I am using mysql to store the data and the column name is intact
inside the database.  Is there any way  to get around this problem
without having to do any compromise such as changing the unusual names
of the columns in order to allow Maypole to display the data in the
table?

S. Tong