[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