Re: [Rainbowportal-devel] Newsletter

[Emmanuele De A. <ma...@gm...>]

A nice thing would be have a list separate for each newsletter so that
one can subscribe only to one or more.
If we detach the email list from user base we have much more freedom
(maybe also import and so on).
I use this mail to inform the list that we have a partnership with
activeup for a free version of active mail specially dedicated to
rainbow users (you can use only on rianbow portal) and this is mainly
for newsletter (it supports queue and a lot of other things... on
rainbowportal home there is a link to full features (left column,
active mail) I anybody is interested in implement in current
newsletter I would be glad... thanks all
Manu

On Fri, 10 Dec 2004 17:35:28 +0100, Christoph Schramm
<sc...@co...> wrote:
>=20
>=20
>=20
> Hi,
>=20
> I'm in need of changing newsletter sourcecode since one of my clients wan=
ts
> a =E2=80=9ENewsletter signup" on HomeTab where only a mailadress is requi=
red to
> signup for newsletter.
>=20
> So I changed rb_GetUsersNewsletter to:
>=20
> =20
>=20
> CREATE PROCEDURE rb_GetUsersNewsletter
>=20
> (
>=20
> @PortalID int
>=20
> )
>=20
> =20
>=20
> AS
>=20
> =20
>=20
> CREATE TABLE #TempItems
>=20
> (
>=20
>             ID int IDENTITY,
>=20
>             UserID nvarchar(255),=20
>=20
>             Name nvarchar(255),=20
>=20
>             Password nvarchar(255),=20
>=20
>             Email nvarchar(255),=20
>=20
>             PortalID int
>=20
> )
>=20
>             -- We don't want to RETURN the # of rows inserted
>=20
>             -- into our temporary table, so turn NOCOUNT ON
>=20
>             SET NOCOUNT ON
>=20
> =20
>=20
>             -- INSERT the rows FROM tblItems into the temp. table
>=20
>             INSERT INTO
>=20
>             #TempItems
>=20
>             (
>=20
>                         UserID,=20
>=20
>                         Name,
>=20
>                         Password,
>=20
>                         Email,
>=20
>                         PortalID
>=20
>             )
>=20
>             SELECT
>=20
>                         UserID,=20
>=20
>                         Name,=20
>=20
>                         Password,=20
>=20
>                         Email,=20
>=20
>                         PortalID
>=20
>             From rb_Users WHERE PortalID =3D @PortalID
>=20
> =20
>=20
>             INSERT INTO
>=20
>             #TempItems
>=20
>             (
>=20
>             EMail
>=20
>             )
>=20
>             SELECT EMail from rb_Newsletter WHERE PortalID =3D @PortalID
>=20
> =20
>=20
> =20
>=20
>            =20
>=20
> SELECT distinct(EMail),Name,UserID,Password,PortalID FROM #TempItems
>=20
> =20
>=20
> DROP TABLE #TempItems
>=20
> GO
>=20
> =20
>=20
> =20
>=20
> =20
>=20
> So it now takes E-Mailadresses out of both tables.
>=20
> But I have to change whole newsletter-module for sending mails now.
>=20
> What do you all think about that?
>=20
> =20
>=20
> Chris
>=20
> =20
>=20
> =20
>=20
> -----------------------------
> COMMON digital
> Gesellschaft f=C3=BCr Kommunikation
> mit interaktiven Medien mbH
> Hamburger Allee 45
> 60486 Frankfurt
> Telefon: (0 69) 71 03 51-18
> Fax: (0 69) 71 03 51-17
> sc...@co...
> www.common-digital.de
>=20
>