Re: append duplication help
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34454
interpreted = N
texte = Parker,;-)1) how many records you reckon will get found with your [search] (which has the embedded [sendmail])? Be careful that you don't crash the works with trying to fire too many emails too fast. Webcat can handle it, but your OS might not. There has been a few thorough discussions in the archives about this. Solution #1 - if you *must* use webcat to fire off mass mailings, slow it down (again see the archives - like 50-100 per minute). Solution #2 (better) - use listserver software instead of webcat, or in conjunction with webcat (like Joseph D'Andrea did - see archives).2) see belowParker wrote:> Kenneth one day said about mass mailing in the archives: > > >>>> > [search db=../emaillist.db&neIDdatarq=[blank]&EMAILsumm=T] > [founditems] > [sendmail] > Put your email message here ... > [/sendmail] > [/founditems] > [/search] > >>>> > > Cool thanks Kenneth. Coupla questions if I might. I have a > form that appends to a database email addresses (works > dandy). Obviously I run the risk of a duplicates someday. I > found the above code in the archives. The questions: > > 1. Do I need to have an ID/SKU field to cycle through the > emails. My current db only has an EMAIL field, that's it. > The above code isn't working so I thought maybe that was it > because maybe WebCat doesn't know what to do?huh? Sounds like you are making some assumptions that aren't right. Why isn't the email address good enough? If someone else gets the exact same email address then don't they assume responsibility for receiving the previous owner's newsletters. ;-) If you mean you don't want the same person to subscribe twice or more, then why not just use [replace .... &append=T]...[/replace]?Your code probably isn't working for reasons less mysterious than what you thought. like: you pass the vars: 'zip' and 'message', but in your [sendmail] you want [subject] not [zip].&neIDdatarq=[blank] means find all the records that do not have a value of *nothing* in the 'ID' field - which will find all the records where ID has any value at all. You would substitute 'EMAIL' for 'ID'.Maybe your search is currently not finding any records at all. Have you stick [numfound] within the [search]...[/search] to see?Also what is- [formvariables name=__&exact=F][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables]for? Why do you have that there? It is not hurting anything, ... I ask only to stimulate your sructiny (is that the right word?) ;-)-John> > > 2. If yes to 1 then could you explain [blank]? And if I need > to have an index of numbers how can I add that to the code > below? > > Here is my current code: > > Form: > >