Community discussion forum

Back to discussion

Creating a Newsletter system

Last post was 23 May 2006 at 16:00
Tags: United Kingdom
This is a comment thread discussing Creating a Newsletter system
  • 10 years ago

    This thread is for discussions of Creating a Newsletter system.

    Report abuse
  • Advertisement

    Simply the fastest line-level profiler for .NET ever

    “The low overhead means it has minimal impact on the execution of my program”
    Mark Everest, Development Team Leader, Renault F1 Team Ltd.

    Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

  • 6 years ago

    I'm getting this error when I try to input text for the "Message" form field... anyone know why it's doing this?


    Error resolving parameter GETMEMBERS.MESSAGE


    The column MESSAGE is not present in the query named GETMEMBERS. It is likely that you have misspelled the name of the column.


    The error occurred while processing an element with a general identifier of (#GetMembers.Message#), occupying document position (41:1) to (41:20).

    Report abuse
  • 6 years ago

    Great job~!


    I tried change a bit on the code, thought you maybe interested:


    <CFIF Form.EmailType EQ "1">
     <CFSET mailType = "HTML">
    <CFELSE>
     <CFSET mailType = "Text">
    </CFIF>


    <CFQUERY NAME="GetMembers" DATASOURCE="Your DSN">
    Select *
    From Newsletter
    WHERE EmailType = #form.EmailType#
    Order By MemberID
    </CFQUERY>


    <!--- Determine if email going out will be in HTML format or not --->


    <CFMAIL To="#GetMembers.Email#"
    From="newsletter@menofvisionent.com"
    Subject="This Week's Newsletter!"
    Type="#mailType#">

    GetMembers.Message


    Sent: #DateFormat(Now(), 'ddd. mmmm dd, yyyy')#
    to Unsubcribe visit: http://www.menofvisionent.com/unsubscribe.cfm
    </CFMAIL>


    Report abuse
  • 6 years ago

    If you have notice, the sample code here does not have a field 'message' in the database. Maybe you can add in the field for 'message', or you can have a form before that to input all the email message, and then change the 'GETMEMBERS.message' to 'form.message' ... hope this help.

    Report abuse
  • 5 years ago

    Hi i am new in creating newsletters and i would like to ask you.This code you submit enters in the <BODY></BODY> section.I tried to put it there but in the PREVIEW i see nothiing but plain text.
    Please explain where this code should be put.
    Thank you in advance.


    P.S Should i create an html page with plain text forms to enter the code behind???

    Report abuse
  • 5 years ago

    I'm new to the web scene but need this script to work. Please let me know how I put it in. Is it in the body. Are they seperate pages?
    Can you make this dummy proof for a beginner like me.


    Thanks
    Please e-mail me asap if you can

    Report abuse
  • 2 years ago

    Hi, could anyone help me with this? Im getting an error on the unsubscribe page to do with the GTI line. Its pretty new to me and im not even sure what this line means!!!

    Element RECORDCOUNT is undefined in UNSUBSCRIBE.

     
    The error occurred in C:\Inetpub\wwwroot\sevenvinylsrecordstore\Unsubscribe.cfm: line 137

    135 : 
136 : <CFOUTPUT>
137 : <CFIF Unsubscribe.recordcount GTE 1>
138 : Thank you #Name#,
139 : Your email address [#Email#] Has been removed from our mailing list. You'll

    I tried it with and  without the"" but still get the same error???

     

    Anyone willing to help out?

    Thanks Pete

    Report abuse
  • 2 years ago

    Try using 'GTE' as opposed to 'GTI'.

    Its supposed to mean Greater Than or Equal to.

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

Quick links

Recent activity

Languages

Web Development

Frameworks & Architecture

Other major sections