[phorm] [Phorm:] Re: Can't Write to DB Table
- From: webbbs@xxxxxxxxx
- To: support@xxxxxxxxx
- Date: 25 Aug 2004 17:07:40 -0000
The following new message has been posted on Phorm Support Forum at
<http://www.phorm.com/support/>.
***************************************************************************
MESSAGE: (#4293) Re: Can't Write to DB Table
<http://www.phorm.com/support/?rev=4293>
AUTHOR: Steve Hurlburt
DATE: August 25, 2004 at 1:07 p.m. EST
Reply To: (#4290) Can't Write to DB Table
Author: Steve Hurlburt
Date: August 24, 2004 at 1:57 p.m. EST
> I have a large form which writes to a MYSQL database,
> using Phorm, and it works great. I created another
> form, using the exact same format in the Phorm config
> file, to write data to a different table in the same
> database, and I'm getting this in the Phorm Alert
> email:
> 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
> 'group,type,category,cost values
> 'c12773','12773','Community Blend'
> I set dbug 71 and 72 and got this:
> Host: localhost User: myusername Pass: mypassword
> Base: mydatabase
> Log: insert into product_info
> (db_number,product_number,description,group,type,category,cost)
> values ('c10408','10408','Community
> Blend','coffee','reg','5#','24.50')
> Those values correspond to the fields properly.
> All permissions are the same for both forms.
> Can I assume Phorm is doing what it's supposed to, and
> my problem is MYSQL-related?
> Thanks.
> Steve
Never mind. Turns out 'group' is one of those mysql "reserved words". Still
not sure why myphpadmin let me create the field with that name. Ichanged it
and it works fine now.
***************************************************************************
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:
- » [phorm] [Phorm:] Re: Can't Write to DB Table
