close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Repeat region only working for first sent email

Thread began 11/05/2011 2:31 am by simmo515303621 | Last modified 11/07/2011 10:32 pm by simmo515303621 | 683 views | 4 replies |

simmo515303621

Repeat region only working for first sent email

HI,

I am creating a Newsletter - and sending products from a DB... The first email to the first recipient works perfect, but to every other recipient - they get nothing?

Sign in to reply to this post

illbe322016

Maybe turn on looping?

Hi, I'm fairly new to this plug-in so please forgive me if this is a stupid reply. I believe there is a setting for looping that must be checked (literally) to send emails from a db. It should be in the setup screens for UE. I hope this helps.

Tom

Sign in to reply to this post

simmo515303621

Hi Tim,

No there are no stupid replies :) Appreciate it...

I have the loop set and the record set selected... It is sending emails to the complete Subscribers list...

The issue is the repeat region applied to the products within the email itself... It send say 12 products in then newsletter email for the first subscriber, but all subsequent subscribers do not get the products listed...

I hope that helps to clarify my issse a bit better

Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

when using a repeat region, the recordset pointer will be left on the last record after the repeat region finishes the first time, you will need to add code to the email file to reset the recordset pointer after the repeat region finishes.

In the email file, add the following code just before the repeat region:

php:
<?php

mysql_data_seek
($rsRecordset0);
$row_rsRecordset mysql_fetch_assoc($rsRecordset);
?>





where rsRecordset is the name of the recordset.

Sign in to reply to this post

simmo515303621

Ahhhhhhh.....Of course!

Perfect!

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