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

Data Assist 2 Send Email with Dynamic Data

Thread began 1/30/2019 12:04 pm by wdtp.com | Last modified 2/20/2019 4:06 pm by Ray Borduin | 68 views | 7 replies |

wdtp.com

Data Assist 2 Send Email with Dynamic Data

I don't see an option to include dynamic data from a Recordset into the new Data Assist 2 Send Email interface. Is there a way to edit in Dreamweaver as before or has that gone away?

If gone, is there a recommended way to manually code the template to include dynamic record from a Recordset?

Sign in to reply to this post

Ray BorduinWebAssist

The new interface always uses a separate php page for the body. You can open that page and add recordsets and other dynamic data directly. If you want to reference a recordset from the page where the email is applied, you just have to declare it as a global variable on the top of the email body page like:

<?php
global $Recordset;
?>

If you have a specific example of what you are doing I can help with the steps, but it depends on the data you are adding and what is on the original page already. Give it a try and send me the files if you get stuck and I can help you update them.

Sign in to reply to this post

wdtp.com

Thanks! Just wanted to make sure I wasn't missing something. I'll give it a try.

Sign in to reply to this post

wdtp.com

I've tried using <?php global $rsAppraisal; ?> but it doesn't work. The Recordset on the page where the email is applied is dependent on $_GET['ID'] being present to choose the proper row.Is this causing the issue?

Sign in to reply to this post

Ray BorduinWebAssist

GET variables are always global and available, so that wouldn't be the issue. I'd have to take a look at the pages and get a better description of what you are or aren't seeing to debug why it might not be working.

Sign in to reply to this post

wdtp.com

I've attached the page which contains the Recordset called $rsAppraisal (edit_appraisal.php) and the email template page (waue_edit_appraisal_1_body.php).

The email is getting sent it just isn't grabbing the ID from $rsAppaisal

Thanks!

Sign in to reply to this post

Ray BorduinWebAssist

It should be:
global $row_rsAppraisal;

Since that is what you are referencing in the body.

Sign in to reply to this post

wdtp.com

Worked like a charm. Thanks!

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...