Managing Relational Tables in Data Bridge

Hi,

I just followed the tutorial for the SkyBlue example to manage relational Tables.

However after i finish everything the insert page gives me:

Undefined varaible _Session on line 139
which is: $WA_masterKeyValue = "".$_SESSION['WADA_Insert_items'] ."";

Any idea why this happens?

this is because of your error reporting level.

your error reporting level is set to include notices.

in reality, this is not really an error that indicates a problem. it is a notice that on page load, there is a variable being referenced that does not exist.

in a production environment, the reporting level should not show notices, and this message will not have any effect.

if you really must make it go away, you can change the line:

$WA_masterKeyValue = "".$_SESSION['WADA_Insert_items'] ."";

to:

$WA_masterKeyValue = "".(isset($_SESSION['WADA_Insert_items'])?$_SESSION['WADA_Insert_items']:"") ."";

Hi Jason,

It works. Just would like to know why the code is not generated as you suggested above in the first place? Even though these are warnings, they should not show right?

Will this be updated in future versions?

Thanks again.

Dear jason,

I also tried the DoubleOpt tutorial and that one also give some error like below:

Notice: Undefined variable: totalRows_reVerify in C:\wamp\www\blueSky\user-confirm.php on line 5

All is woring but like above i think it is not correct to get these messages or not?

Thanks.

Originally Said By: dvan_zelst

  Hi Jason,

It works. Just would like to know why the code is not generated as you suggested above in the first place?  

the manage relational table uses the standard dreamweaver bindings panel for selecting the value to use for the Main table key, Dreamweaver generates the code that is used for the session binding. The code is not generated using the isset check because that is the way Dreamweaver generates the code.

Originally Said By: dvan_zelst

  Even though these are warnings, they should not show right?

Will this be updated in future versions?

Thanks again.  

Notices are harmless, the only reason your are seeing them is because of the setting in your PHP.ini file for reporting level. only if the application is not working should you be concerned about notices.

Originally Said By: dvan_zelst

  Dear jason,

I also tried the DoubleOpt tutorial and that one also give some error like below:

Notice: Undefined variable: totalRows_reVerify in C:\wamp\www\blueSky\user-confirm.php on line 5

All is woring but like above i think it is not correct to get these messages or not?

Thanks.  

I'd need to see your confirm.php page to know why that error is happening in this instance

Here are all the pages generated and modified according to the tutorial.
Like i mentioned i just followed the tutorial from you to see how it is working.

the code to set the emailVerified session is at lines 3 - 8. it needs to come after the code for the reVerify record set which ends at line 59.

This is Dreamweaver placing the code in the wrong place. Dreamweaver uses a numbered weighting system to determine where the code gets placed. Recordsets should have a higher wight then setting sessions, but sometimes dreamweaver will misplace code regardless of the weight given to the code block.

Thanks Jason,

It worked!
Thanks for your clear explanation.