[phorm] [Phorm:] Re: Database Error
- From: webbbs@xxxxxxxxx
- To: support@xxxxxxxxx
- Date: 29 Mar 2004 14:34:32 -0000
The following new message has been posted on Phorm Support Forum at
<http://www.phorm.com/support/>.
***************************************************************************
MESSAGE: (#3911) Re: Database Error
<http://www.phorm.com/support/?rev=3911>
AUTHOR: Holotech
DATE: March 29, 2004 at 9:34 a.m. EST
Reply To: (#3910) Database Error
Author: Scott
Date: March 29, 2004 at 2:10 a.m. EST
> Internal Alerts:
> 040 - Error on query:
> insert into Email Database (First Name,Last Name,Email
The problem is the table name. If a table name contains special characters
(such as a space), it must be quoted in the query. Unfortunately, Phorm does
not know how to do this yet. It will in the next release. Meanwhile, you can
either change the name of your table so it contains no special characters
(only letters, numbers and the _ character), or enclose the table name in
back-tick characters, like this:
$PHORM_MYTABLE = "`Email Database`";
I have not tested this, but it should work fine.
***************************************************************************
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:
