Re: Prevent multiple appends with Reload Button
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15509
interpreted = N
texte = >>Instead of doing an [append] you can use [replace] but include the tag>>append=T (i.e. [replace append=T&...]). This will append if it's not>>found, but just replace the data with itself if they reload the page.>>Please show me how - my attempts haven't worked>I would like a new entry only if the customer and new customer code>hasn't been added already.Your code doesn't search for a particular record, that's why it's notworking. When you use [replace], you have to write some *searchparameters* into the [replace] tag so WebCat knows which record youwant to replace. Just specifying a database is not enough.You may be getting mixed up with [append], but append is different,because when you're appending, you don't care what records alreadyexist in the database, all you care about is adding a new one to theend of the file.Also, don't start your first replace parameter with &, because it'snot needed for the first parameter inside the replace context ... andyou forgot the brackets around your zipcode variable ... :)Your code:[replacedb=mcust.db&append=T]&firstname=[firstname]&lastname=[lastname]&company=[company]&building=[building]&suite=suite&zipcode=[zipcode]&areacode=[areacode]&phone=[phone]&faxareacode=[faxareacode]&emailname=[emailname]&specdel=[specdel]&custcode=[math]newnum[/math][/replace]My code:[replaceappend=T&db=mcust.db&eqSomeFieldData=XXX]firstname=[firstname]&lastname=[lastname]&company=[company]&building=[building]&suite=[suite]&zipcode=[zipcode]&areacode=[areacode]&phone=[phone]&faxareacode=[faxareacode]&emailname=[emailname]&specdel=[specdel]&custcode=[math]newnum[/math][/replace]Sincerely,Ken Gromeken@iav.com808-737-6499WebDNA Solutionshttp://www.hui.net/
Associated Messages, from the most recent to the oldest:
>>Instead of doing an
[append] you can use
[replace] but include the tag>>append=T (i.e. [replace append=T&...]). This will append if it's not>>found, but just replace the data with itself if they reload the page.>>Please show me how - my attempts haven't worked>I would like a new entry only if the customer and new customer code>hasn't been added already.Your code doesn't search for a particular record, that's why it's notworking. When you use
[replace], you have to write some *searchparameters* into the
[replace] tag so WebCat knows which record youwant to replace. Just specifying a database is not enough.You may be getting mixed up with
[append], but append is different,because when you're appending, you don't care what records alreadyexist in the database, all you care about is adding a new one to theend of the file.Also, don't start your first replace parameter with &, because it'snot needed for the first parameter inside the replace context ... andyou forgot the brackets around your zipcode variable ... :)Your code:[replacedb=mcust.db&append=T]&firstname=[firstname]&lastname=[lastname]&company=[company]&building=[building]&suite=suite&zipcode=[zipcode]&areacode=[areacode]&phone=[phone]&faxareacode=[faxareacode]&emailname=[emailname]&specdel=[specdel]&custcode=
[math]newnum[/math][/replace]My code:[replaceappend=T&db=mcust.db&eqSomeFieldData=XXX]firstname=[firstname]&lastname=[lastname]&company=[company]&building=[building]&suite=[suite]&zipcode=[zipcode]&areacode=[areacode]&phone=[phone]&faxareacode=[faxareacode]&emailname=[emailname]&specdel=[specdel]&custcode=
[math]newnum[/math][/replace]Sincerely,Ken Gromeken@iav.com808-737-6499WebDNA Solutionshttp://www.hui.net/
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Forms & Tables (1998)
Digest Version (2000)
Search or delete (or date or time) has bugs ... (1998)
ShippingCosts (1998)
Re:Searching for ALL / empty form field (1997)
FileMaker Pro (1999)
[lottaCopy] through SSL (1998)
MasterCounter Weirdness (1997)
how to deal with xml exported file (2007)
Emailer not working (1998)
Database Security (1998)
WebDNA and FreeBSD 6.1 with Apache (2007)
[OT] Mom's gift (2006)
Emergency Error (2000)
uploads (2000)
[WebDNA] 6.2 Monitor (2012)
WebDNA Verison 4.5 will Not Restart! This SUCKS! (2002)
Fun with Dates - revisited (1997)
Experience with creating real dynamic solutions?????? (1998)
LineItem variable set (2007)