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:
Attn: Bug in GeneralStore example b15 (1997)
[accountNum] and [math] (1997)
Emailer (WebCat2) (1997)
WebDelivery downloads alias, not original ? (1997)
Now you see it now you donīt (1997)
THANKS!!! ShipCosts.db and debugging (1997)
[purgeDatabase], [replaceChars] and others ... (1997)
Netscape 3.01 can't see db in form (was problems problemsproblems) (1997)
[date] insanity! (2001)
why is this line in GeneralStore? (1998)
sort by day of week... (2003)
URGENT! ACGI Stopped!!!! (1997)
WC Database Format (1997)
Only charge card when product shipped ? (1997)
Purchase command error problem (1997)
Anyone have an invoicing system? (1999)
WebCommerce: Folder organization ? (1997)
Download URL & access on the fly ? (1997)
Associative lookup style? (1997)
Registration Form (1998)