Still Does Not Work After Column Renamed, Etc.
Database column names should not contain a space.Try naming the column "PersonalReferrals" instead.
After changing the name, you will need to delete the pages created by the DataAssist wizard and recreate them.
Jason:
I renamed the column to PersonalReferrals and it still does not work! Really getting frustrated. The resume_Insert.php page adds a record to the db. Currently there are 10 records;however, when resume_Insert.php attempts to redirect to resume_Detail.php that is when the error occurs. Appreciate anyone's help on getting this error resolved. Thanks!
Renee'
Jason:
Okay it seems to be only the resume_Detail.php page, as the resume_Results.php works and when I update a record from that page, which loads the resume_Update.php page with record I selected it updates the record just fine. The resume_Delete.php page works fine as well. So the only page that seems to be generating the MySQL error is the resume_Detail.php page...Hope this provides some insight so I can get this issue resolved today. Thanks!
Renee'
Support:
Okay folks thru problem solving I compared the code from both the resume_Update.php and resume_Detail.php pages. The detail page was generating the MySQL error and determined that this bit of code created by DataAssist was causing the problem, see code below:
?>
<?php
if (!session_id()) session_start();
I removed that code and now I am able to view the details of each record in my database. This was very frustrating, as I purchased DataAssist to help me develop applications for my clients quickly without a huge learning curve as advertised on your site and I have to say that bugs like this in your code cost me over day in development time. I would like an explanation. Thanks!
Renee'
