Send a suggestion!

We're building a brand new version of the site, and we'd love to hear your ideas

Members

Technology Zones

IBM Learning Center

Articles

Hosted By

MaximumASP

Info
Developer Fusion » Miscellaneous » User Comments » [1948] Creating a Newsletter system

[1948] Creating a Newsletter system

Last post 05-23-2006 4:00 PM by Jbuda. 7 replies.
Page 1 of 1 (8 items)
Sort Posts: Previous Next

  • 01-01-1999 12:00 AM

    [1948] Creating a Newsletter system

    Reply Contact

    This thread is for discussions of Creating a Newsletter system.
    • Post Points: 35

    • Advertisement

    • Red Gate Software

    Advertisement

    Want to boost your .NET application performance?

    Some developers always seem to write efficient and lightening-fast code. What is their secret? It’s ANTS Profiler. “We improved the performance of the application up to 10 times” Dan Ports, Intrigma.

    Try it for yourself now.

  • 06-27-2002 5:12 PM In reply to

    • betsyb
    • Not Ranked
    • Joined on 06-27-2002
    • New Member
    • Points 10

    Message variable error

    Reply Contact
    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).
    • Post Points: 0

  • 07-11-2002 12:08 AM In reply to

    • psfong
    • Not Ranked
    • Joined on 07-10-2002
    • New Member
    • Points 10

    CFMAIL

    Reply Contact
    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>

    • Post Points: 0

  • 07-11-2002 12:13 AM In reply to

    • psfong
    • Not Ranked
    • Joined on 07-10-2002
    • New Member
    • Points 10

    RE: Message variable error

    Reply Contact
    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.
    • Post Points: 0

  • 01-14-2003 4:00 AM In reply to

    • ak11
    • Not Ranked
    • Joined on 01-14-2003
    • New Member
    • Points 5

    questions on newsletters

    Reply Contact
    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???
    • Post Points: 0

  • 01-22-2003 2:24 PM In reply to

    • cralph
    • Not Ranked
    • Joined on 01-22-2003
    • New Member
    • Points 5

    quick question

    Reply Contact
    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
    • Post Points: 0

  • 05-13-2006 4:15 PM In reply to

    • 7vinyls
    • Not Ranked
    • Joined on 05-13-2006
    • Australia
    • New Member
    • Points 5

    Re: [1948] Creating a Newsletter system

    Reply Contact

    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
    • Post Points: 5

  • 05-23-2006 4:00 PM In reply to

    • Jbuda
    • Not Ranked
    • Joined on 05-12-2006
    • United Kingdom
    • New Member
    • Points 5

    Re: [1948] Creating a Newsletter system

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

    Its supposed to mean Greater Than or Equal to.
    • Post Points: 5
Page 1 of 1 (8 items)