Re: Busted at the Border

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20705
interpreted = N
texte = >Hi Everyone, > >I have been fussing with trying to check for duplicate skus and >not allowing the append to occur if the sku exists. > >This is what I got working but it still writes to the db but tells me it >found the dup. > >Any direction Por Favor? > > >[hideif >[lookupdb=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&Found=[sku]]] >[sku] already exists! >[Append >db=catalog.txt][FormVariables][name]=[URL][value][/URL]&[/FormVariables][/Appen >d >] >[/hideif][hideif [lookupdb=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&Found=[sku]]]should probably be[hideif [lookup db=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&NotFound=OK]=[SKU]] instead ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Ideer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se Associated Messages, from the most recent to the oldest:

    
  1. Re: Busted at the Border (John Hill 1998)
  2. Re: Busted at the Border (Dave MacLeay 1998)
  3. Re: Busted at the Border (Christer Olsson 1998)
  4. Busted at the Border (The Mooseman 1998)
>Hi Everyone, > >I have been fussing with trying to check for duplicate skus and >not allowing the append to occur if the sku exists. > >This is what I got working but it still writes to the db but tells me it >found the dup. > >Any direction Por Favor? > > >[hideif >[lookupdb=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&Found=[sku]]] >[sku] already exists! >[Append >db=catalog.txt][formvariables][name]=[url][value][/URL]&[/FormVariables][/Appen >d >] >[/hideif][hideif [lookupdb=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&Found=[sku]]]should probably be[hideif [lookup db=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&NotFound=OK]=[SKU]] instead ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Ideer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se Christer Olsson

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:

Comments in db? (1997) Help! WebCat2 bug (1997) It's working (1997) WebCat2b15MacPlugin - [protect] (1997) Price and Formula.db (2002) Banner DNA (1997) Sending Email (2004) More on the email templates (1997) Sense/Disallow HTML tags during $Append (1997) Execute Applescript (1997) DDE feature in webcat (1998) Projects & Contractors (1997) Date Bug (1998) [BoldWords] WebCat.acgib15Mac (1997) Updating fields from different platforms (1998) Training Videos for 3.0 (1998) RE: [WebDNA] [test] (2009) WebCat2b12 - nesting [tags] (1997) Limiting user access to .tmpl files (1997) f2 download problems (1997)