Re: Problems deleting when a search field is blank...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19057
interpreted = N
texte = >The primary problem... >When I use the bit of code below, it looks like I've got it set to do >this the right way, but since WebCatalog ignores blank fields, if I pass a >blank field to the search OR delete context it ends up trying to delete BOTH >of these records. How do I get around this? There is no completely unique >value for any of the records in this database.There should ALWAYS be a field with a unique value in it for each record ... and if you use [cart] to create this unique value in the append context, you will never have to worry about getting a duplicate in this field, because each time [cart] creates a value, it's a unique value ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>The primary problem... >When I use the bit of code below, it looks like I've got it set to do >this the right way, but since WebCatalog ignores blank fields, if I pass a >blank field to the search OR delete context it ends up trying to delete BOTH >of these records. How do I get around this? There is no completely unique >value for any of the records in this database.There should ALWAYS be a field with a unique value in it for each record ... and if you use
[cart] to create this unique value in the append context, you will never have to worry about getting a duplicate in this field, because each time
[cart] creates a value, it's a unique value ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.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:
Not really WebCat (1997)
read and write you own cookies with webcat (1997)
A Trigger Question (2000)
Include a big block of text (1997)
Triggers and coupons (two questions) (2003)
WebCat editing, SiteGuard & SiteEdit (1997)
Multi-User Security on *nix using mod_rewrite (2002)
More on the email templates (1997)
Hello??? (1997)
Security Question (1997)
Mozilla/4. and Browser Info.txt (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
In Digest Dijon (2000)
db access problem after switching to SSL (2001)
Calendar using WebCatalog? (1997)
Silly Question (1997)
Using Applescript to process WebCatalog functions (1998)
WC Database Format (1997)
Database Repopulation (2004)
Help! WebCat2 bug (1997)