Search or Lookup before Append
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16550
interpreted = N
texte = Our bookstore system wants to do an in-house store for employees. They're going to sentence someone to do all the data entry through an adminAdd.tpl type of page. (I know, I know, but there's no database to do a tabbed export from).Since the SKU is key to many functions, before the new item is appended to the database, I want to do a search of the database FIRST to check for a duplicate number.How/where can I do this? Within the Add page or on AdminAdded? Will I have to put another page between these two just to get the search result before moving on to Append?My simple attempts so far don't seem to even do the search correctly in the first place, so when there is a dupe, Append still records the new item.[search db=bookstore.db&eqskudata=[url][sku][/url]] [showif [numfound]>0] [founditems]
Sorry, but that SKU (UPC) is already on file: SKUs must be unique for each item.
[/founditems] [/showif] [/search]Thanks in advance for any wisdom . . . .--.Dave. webmaster metropolitan community colleges kansas city, missouri, 64111 http://www.kcmetro.cc.mo.us mailto:herriman@kcmetro.cc.mo.us
Associated Messages, from the most recent to the oldest:
| |
- Search or Lookup before Append (Dave Herriman 1998)
|
Our bookstore system wants to do an in-house store for employees. They're going to sentence someone to do all the data entry through an adminAdd.tpl type of page. (I know, I know, but there's no database to do a tabbed export from).Since the SKU is key to many functions, before the new item is appended to the database, I want to do a search of the database FIRST to check for a duplicate number.How/where can I do this? Within the Add page or on AdminAdded? Will I have to put another page between these two just to get the search result before moving on to Append?My simple attempts so far don't seem to even do the search correctly in the first place, so when there is a dupe, Append still records the new item.[search db=bookstore.db&eqskudata=
[url][sku][/url]] [showif [numfound]>0]
[founditems] Sorry, but that SKU (UPC) is already on file: SKUs must be unique for each item.
[/founditems] [/showif] [/search]Thanks in advance for any wisdom . . . .--.Dave. webmaster metropolitan community colleges kansas city, missouri, 64111 http://www.kcmetro.cc.mo.us mailto:herriman@kcmetro.cc.mo.us
Dave Herriman
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:
RE: Error: template (1997)
Multiple SSL Keys (1998)
Group search doesn't work. (1997)
Using WC for Bulk Emailings (1997)
[Webcat 2]Next (1997)
RE: [WebDNA] Google Cloud (2014)
WC2b15 File Corruption (1997)
Repost: Orderfile, Grandtotal: How do I get it to all add up. (2000)
Mondo amounts of Mail [long] (1999)
[SearchString] problem with [search] context (1997)
problems with 2 tags shakur (1997)
Generating and appending SKU to a db automatically (1998)
Payments -> Bank Accounts (2005)
WebCat2 Append problem (B14Macacgi) (1997)
[WebDNA] tcp connect is slow...any ways to speed it up? (2008)
Quit revisited (1997)
Include Files (1998)
[replaceChars] would be nice ... (1997)
Re:quit command on NT (1997)
frames & carts (1997)