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:
unable to launch acgi in WebCat (1997)
Requiring that certain fields be completed (1997)
Multiple catalog databases and showcart (1997)
[WebDNA] Authenticating with Twitter OAuth API v1.1 (2013)
WCS Newbie question (1997)
Intermitent problem using [referrer] (1997)
Click-through/Referral tracking solution needed (2000)
RE: Automatic Forwarding using WebCat (1997)
[sendmail] on NT? (1997)
Cancel Subscription (1996)
http upload (2001)
[WebDNA] Upgrade from OS 10.7.5 WebDNA 6.2 to Mavericks (2013)
[WebDNA] Error: Can't open order file. Ignoring [OrderFile] (2011)
combine search (1998)
protect tag on NT IIS (1997)
E-Mail (1998)
Need help with emailer- 2 issues (1997)
Nested tags count question (1997)
[WebDNA] [MATH] & formatting (2015)
Re:no [search] with NT (1997)