Your query doesn't have any joining statement in it; the duplicates might be
resulting from not properly joining the tables.
WHERE Stories.field1 = MailingList.field1, etc.
> -----Original Message-----
> From: Mark Smeets [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 21, 2000 11:24 AM
> To: [EMAIL PROTECTED]
> Subject: Re: CF-Talk V1 #92
>
>
> Hi again everyone,
>
> My last problem, I pray with this cfmail stuff. It would seem as
> I can send
> the mail without a prob but now I'm getting double entries in each email.
> How do I stop this? Here's the new/updated code.
>
> Again, any help is appreciated.
>
> ---------------
>
> <CFQUERY NAME="News" DATASOURCE="OtherPress">
> SELECT Stories.Author,
> Stories.Type,
> Stories.Number,
> Stories.ByLine,
> Stories.Title,
> MailingList1.Email,
> Ads.Ads
> FROM Stories, MailingList1, Ads
> </cfquery>
>
> <CFMAIL QUERY="News" TO="[EMAIL PROTECTED]" FROM="The Other Press"
> SUBJECT="The Other Press Weekly Mailing List">
>
> Welcome #Email# to the Other Press Weekly Mailing List, here are
> this weeks
> stories
>
> <cfoutput>
> #Type# - #Title#
> By #Author# - #ByLine#
> Continue - http://24.113.34.178/op1999/Stories/story.cfm?Number=#Number#
>
> #Ads#
> </cfoutput>
>
> -------------------------------------------------
> You are recieving this email because you are subscribed to the
> Other Press
> Mailing List. To Unsubscribe, please visit the Other Press website.
>
> </CFMAIL>
>
>
> Mark Smeets/stranger0/ICQ #1062196
>
> "Mr. West, not every situation requires your patented approach of shoot
> first, shoot later, shoot some more and then when everybody's dead try to
> ask a question or two" - Wild Wild West
>
> Other Press Webslinger *New and Improved*
> http://otherpress.douglas.bc.ca/
>
> Official Splitting Adam Homepage
> http://www.splittingadam.com/
>
> Over the Wall Productions and Web Designs
> http://www.solarcourt.com/
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
