Skip Menu |

This queue is for tickets about the Maypole CPAN distribution.

Report information
The Basics
Id: 7372
Status: resolved
Priority: 0/
Queue: Maypole
People
Owner: SIMONFLK [...] cpan.org
Requestors: eric256 [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Critical
Broken in: 1.7
Fixed in: (no value)

History Show all quoted text
  Mon Aug 16 19:31:31 2004 Guest - Ticket created
Subject: Doesn't Fields with spaces in them
Crahses with a less than gracefull error: undef error - DBD::mysql::st execute failed: Unknown column 'first' in 'field list' [for Statement "SELECT stamped, datahash, extension, first, inactive, last, flag, email, password, lastday, supervisor, extensionnote, incorporate FROM CorporateEmployee WHERE id=? "] at /usr/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm line 51. The feild shoulw be 'First Name' and there should be at least some way for you to alias bad colum names to something usable. I.e. setup paramters that let you tell it first_name IS 'First Name' or something along those lines. If this should be reported in a different module please let me know, but I can't figure out what modules is generating the SQL in this case.
  Wed Nov 24 17:20:20 2004 SIMONFLK [...] cpan.org - Taken
  Wed Nov 24 17:33:26 2004 SIMONFLK [...] cpan.org - Correspondence added
[guest - Mon Aug 16 19:31:31 2004]: Show quoted text
> Crahses with a less than gracefull error: > > undef error - DBD::mysql::st execute failed: Unknown column 'first' in > 'field list' [for Statement "SELECT stamped, datahash, extension, > first, inactive, last, flag, email, password, lastday, supervisor, > extensionnote, incorporate > FROM CorporateEmployee > WHERE id=? > "] at /usr/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm line 51. > > The feild shoulw be 'First Name' and there should be at least some way > for you to alias bad colum names to something usable. I.e. setup > paramters that let you tell it first_name IS 'First Name' or > something along those lines.
Please see the Class::DBI documentation for information on how to alias column names. If you need further help setting up Maypole, please consider posting to the mailing list: http://maypole.perl.org/?MailingList See also the Class::DBI resources at: http://www.class-dbi.com Thanks --simonflk
  Wed Nov 24 17:33:27 2004 SIMONFLK [...] cpan.org - Status changed from 'new' to 'open'
  Wed Nov 24 17:33:58 2004 SIMONFLK [...] cpan.org - Status changed from 'open' to 'resolved'