Re: Problem 'setting' data.

[prev] [thread] [next] [Date index for 2005/03/09]

Hi John,

'to' is a reserved word in MySQL so you'll need to change the name of
that column..

http://dev.mysql.com/doc/mysql/en/reserved-words.html

cheers,

J


John Day wrote:
> Hi!,
> 
> I am using Class::DBI to save emails sent from a contact management 
> system. Here is the code:
> 
>     my $outbox = InContact::cDBI::outbox->create( {
>                                                    contact_id => 
> $self->{_cid},
>                                                    to => $self->{_to},
>                                                    #cc => $self->{_cc},
>                                                    #bcc => $self->{_bcc},
>                                                    response => $rv,
>                                                    body => $outbox_body,
>                                                   } );
> 
> The contact_id, response and body in this case are okay, but I get an 
> error when I try to include the to.
> 
> To isolate I tried this:
>     $outbox->set( to => $self->{_to} );
>     $outbox->update();
> 
> and get the following:
> 
> Tk::Error: Can't update 5: DBD::mysql::st execute failed: You have an 
> error in your SQL syntax; check the manual that corresponds to
>  your MySQL server version for the right syntax to use near 'to = 'John 
> Day <johnday@xxxxxxxxxxxx.xxx>'
> WHERE  id='5'' at lin [for Statement "UPDATE outbox
> SET    to = ?
> WHERE  id=?
> "] at C:/Perl/site/lib/DBIx/ContextualFetch.pm line 51.
> 
> The data is an email address in the form:
> 
> John Day <johnday@xxxxxxxxxxxx.xxx>
> 
> Which has been passed to Net::SMTP and used to send an email. Any clues?
> 
> John
> 
> 
>