2 messages in com.mysql.lists.mysqlRe: Cannot execute query| From | Sent On | Attachments |
|---|---|---|
| Suchita Choksi - Bhatt | 10 Jun 2003 06:08 | |
| Becoming Digital | 10 Jun 2003 07:37 |
| Subject: | Re: Cannot execute query |
|---|---|
| From: | Becoming Digital (su...@becomingdigital.com) |
| Date: | 06/10/2003 07:37:38 AM |
| List: | com.mysql.lists.mysql |
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" <sbh...@fdu.edu> To: <mys...@lists.mysql.com> 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: sbh...@fdu.edu <https://webmail.fdu.edu/servlet/com.endymion.sake.servlet.mail.MailServ let?cmd_compose=1¶m_to=sbh...@fdu.edu> Mail Stop: H-DH2-15 Dickinson Hall-2nd Floor