close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Managing Relational Tables in Data Bridge

Thread began 10/02/2012 2:48 am by dvan_zelst | Last modified 10/04/2012 10:17 pm by dvan_zelst | 1119 views | 7 replies |

dvan_zelst

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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:

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



to:

php:
$WA_masterKeyValue = "".(isset($_SESSION['WADA_Insert_items'])?$_SESSION['WADA_Insert_items']:"") ."";
Sign in to reply to this post

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? Even though these are warnings, they should not show right?

Will this be updated in future versions?

Thanks again.

Sign in to reply to this post

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

dvan_zelst

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.

Attached Files
DoubleOpt.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

dvan_zelst

Thanks Jason,

It worked!
Thanks for your clear explanation.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...