After insert goes to blank detail page
Dreamweaver CS6
DataAssist ver. 1.2.1
After inserting a record the insert page redirects to the detail page, but the detail page is blank.
Dreamweaver CS6
DataAssist ver. 1.2.1
After inserting a record the insert page redirects to the detail page, but the detail page is blank.
It looks like you are setting the value for the EmplID field in the insert form.
Normal practice would be for the ID field to be set in the database as an auto number field, and not assign a value for that field, let the database assign the value instead.
Is there a particular reason you are setting the value from the form?
Where you are setting the value, it seams the ID column is not set to auto number, so the:
mysql_insert_id()
function that looks the outnumber for the last inserted record is not setting the session properly.
you could use the form element in the redirect instead of the session, change:
$GoToPage = "employeecontact_view.php?EmplID=".($_SESSION['WADA_Insert_employeecontact']) ."";
to:
$GoToPage = "employeecontact_view.php?EmplID=".((isset($_POST['EmplID']))?$_POST['EmplID']:'') ."";
but i think it would be better to set the EmplID column to outnumber and let the DB handle setting the ID value.
The ID number is the actual employee ID. I should have put an auto increment ID as well, but didn't think it would matter. I know it does now. I changed the gotopage to what you have above and it works perfectly now.
Thanks for your help.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.