valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 10614
Questions & Answers
Q: I've checked out your help files and haven't been able to find what I need. I'm getting the Error MySQL email....and I noticed the email have the information listed with no "_" in it...and my fields in my mySQL database and my form fields have "_" instead of spaces. For some reason could this mean the data is being sent to the database wrong? I have labels set up in the html, is this an issue? I've used your program before on another site and have had no issues...so I'm confused why it's not working.
A: The email you receive is modified for human display ie the _ are replace by spaces. When a form field name includes a _ the _ should also be used in the database field name. From a quick look at your form it appears ok. The MYSQL error email indicates that the data cannot be added the specified database table. Recheck MYSQL Server Name, MYSQL User Name, MYSQL User Password, MYSQL Database Name, MYSQL Table Name. These must match existing settings in the MYSQL database. Also recheck that the existing table (MYSQL Table Name) has field names that correspond to form field names and text variable types are used. Remember if your form field is First_Name it displays as First Name in your browser but the MYSQL field must be First_Name. It is also recommended that the form is run on the same server as your MYSQL database. Also make sure that any MYSQL table fields that are not skipped can accept the MYSQL Empty Value or NULL values. If you have access to the error log files for your server you may be able to identify the problem by checking the error log entries. If you still have difficulty try stripping your form and database down to a single field ie subject to eliminate/minimize potential data mismatches and determine if it is an access or data issue.
Question and Answer Item 10614 - Browse All Question and Answer Items