[phorm] [Phorm:] Re: Database Error
- From: webbbs@xxxxxxxxx
- To: support@xxxxxxxxx
- Date: 29 Mar 2004 17:05:51 -0000
The following new message has been posted on Phorm Support Forum at
<http://www.phorm.com/support/>.
***************************************************************************
MESSAGE: (#3916) Re: Database Error
<http://www.phorm.com/support/?rev=3916>
AUTHOR: Scott
DATE: March 29, 2004 at 12:05 p.m. EST
Reply To: (#3911) Re: Database Error
Author: Holotech
Date: March 29, 2004 at 9:34 a.m. EST
> $PHORM_MYTABLE = "`Email Database`";
Thank you so much for your help. I made a change to the Table name. It is now
EmailDatabase. I sent another email from the form and I get the following.
The difference is the 'Bonnie', 'Clark' after values.
The back-tick produced the same error on "`Email Database`".
Internal Alerts:
040 - Error on query:
insert into EmailDatabase (First Name,Last Name,Email Address,Source) values
('Bonnie','Clark','scott@xxxxxxxxxxxx','Discovery Channel') MySQL says: 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 'Name,Last Name,Email
Address,Source values 'Bonnie','Clark','
***************************************************************************
This is an automatically-generated notice. If you'd like to be removed from
the mailing list, please visit Phorm Support Forum at
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx If
you wish to respond to this message, please post your response directly to the
board. Thank you!
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing
list. To send messages to the mailing list, simply send email to
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe
from the list by sending email to phorm-request@xxxxxxxxxxxxx with
'unsubscribe' in the SUBJECT field.
Other related posts:
