Without seeing your code, it's hard to gauge what the problem is, but my guess is that your insert statement in missing a VALUES field (or one has been transposed). If data types don't match up, this will cause your query to fall on its face, just as it seems to be doing.
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Suchita Choksi - Bhatt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 09:09 Subject: Cannot execute query Hello, I have 140 fields in a HTML survey form that needs to be passed into a MYSQL database. I am using php script in the HTML form to send the data to the database. I have successfully been able to insert data from the HTML form into the database with about 20 fields or so. When I use the bigger HTML form and on submit I get a "Cannot execute query" error. My question is whether there is a restriction on the number of fields that can be inserted at the same time in the database. And if there is a probable solution in case of a restriction. Thanks Suchita Choksi-Bhatt Educational Technology Project Manager/Instructor Fairleigh Dickinson University Tel: 201-692-7060 Fax: 201-692-7273 Email: [EMAIL PROTECTED] <https://webmail.fdu.edu/servlet/com.endymion.sake.servlet.mail.MailServ let?cmd_compose=1&[EMAIL PROTECTED]> Mail Stop: H-DH2-15 Dickinson Hall-2nd Floor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
