[phorm] [Phorm:] Can't Write to DB Table

From: webbbs@xxxxxxxxx
To: support@xxxxxxxxx
Date: 24 Aug 2004 17:57:45 -0000
The following new message has been posted on Phorm Support Forum at 
<http://www.phorm.com/support/>. 

*************************************************************************** 

  MESSAGE:  (#4290) Can't Write to DB Table 
            <http://www.phorm.com/support/?rev=4290> 
  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 

*************************************************************************** 

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.
[phorm] [Phorm:] Can't Write to DB Table

Other related posts:
