Still Does Not Work After Column Renamed, Etc.
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'