Re: Suggestion: appendfounditems
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40539
interpreted = N
texte = I use this which works very well,(webstar, mac, 0S 9.1) all you need to do is replace the db_is=value with your dbs name, and unique_field=SKU field name with your unique field name, and your search context. Once you remove the comments it isn't so long. If you use the old [date %Y%m%d][time %H%M%S] to generate you original skus you should be able to leave the new_unique_field_value below alone. Although it will make your new sku longer in length than [date %Y%m%d][time %H%M%S]. It duplicates 1000 records in a db with 5000 records & 10 fields in 6 seconds. [text]db_is=books_li.db[/text] [text]unique_field=SKU[/text] [text]dup_search=neSKUdata=findall[/text] [text]db_fields=[ListFields [db_is]][hideif [fieldname]=[unique_field]][FieldName]=[[FieldName]]&[/hideif][/ListFields][ /text] [search db=[db_is]&[dup_search]][numfound] [founditems] [!]-----------------------// you need to find a new unique_field value for the append. depending on your db unique_field I use [math][sku]+[index][/math] because my field is numeric and called sku----------[/!] [text]new_unique_field_value=[interpret][[unique_field]][/interpret][index][ /text][!]-----------------------// copies all the fields except sku back into the db from the found set----------[/!] [append db=[db_is]][interpret][db_fields][/interpret][unique_field]=[new_unique_fiel d_value][/append] [/founditems] [/search]Good luck > Hi SMSI, > > Sometimes we need to copy a record and for this it would be great to have a > [appendfoundrecords] tag, sort of like the [replacefounditems]. > > With the current settings, to be able to copy a record, we need to: > > [search] > [founditems] > > [append]fieldname1=[xxxx]&fieldname2=xxxx&etc...[/append] > > [/founditems] > [/search] > > With the new tag we could: > > [search] > > [appendfounditems]sku=[newsku][/appendfounditems] > > [/search] > > Thus we would NOT need to add all the fieldnames in a append tag, because > [appendfounditems] would just do that for us. The current method is a pain > in the rear when one has over 20 or more fields. > > Thank you for consider this suggestion. > > Sincerely, > Nitai ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I use this which works very well,(webstar, mac, 0S 9.1) all you need to do is replace the db_is=value with your dbs name, and unique_field=SKU field name with your unique field name, and your search context. Once you remove the comments it isn't so long. If you use the old [date %Y%m%d][time %H%M%S] to generate you original skus you should be able to leave the new_unique_field_value below alone. Although it will make your new sku longer in length than [date %Y%m%d][time %H%M%S]. It duplicates 1000 records in a db with 5000 records & 10 fields in 6 seconds. [text]db_is=books_li.db[/text] [text]unique_field=SKU[/text] [text]dup_search=neSKUdata=findall[/text] [text]db_fields=[ListFields [db_is]][hideif [fieldname]=[unique_field]][FieldName]=[[FieldName]]&[/hideif][/ListFields][ /text] [search db=[db_is]&[dup_search]][numfound] [founditems] [!]-----------------------// you need to find a new unique_field value for the append. depending on your db unique_field I use [math][sku]+[index][/math] because my field is numeric and called sku----------[/!] [text]new_unique_field_value=[interpret][[unique_field]][/interpret][index][ /text][!]-----------------------// copies all the fields except sku back into the db from the found set----------[/!] [append db=[db_is]][interpret][db_fields][/interpret][unique_field]=[new_unique_fiel d_value][/append] [/founditems] [/search]Good luck > Hi SMSI, > > Sometimes we need to copy a record and for this it would be great to have a > [appendfoundrecords] tag, sort of like the [replacefounditems]. > > With the current settings, to be able to copy a record, we need to: > > [search] > [founditems] > > [append]fieldname1=[xxxx]&fieldname2=xxxx&etc...[/append] > > [/founditems] > [/search] > > With the new tag we could: > > [search] > > [appendfounditems]sku=[newsku][/appendfounditems] > > [/search] > > Thus we would NOT need to add all the fieldnames in a append tag, because > [appendfounditems] would just do that for us. The current method is a pain > in the rear when one has over 20 or more fields. > > Thank you for consider this suggestion. > > Sincerely, > Nitai ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
marc malacarme
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:
WebMerchant when CC network is down (1998)
really annoying feature (2001)
WebCat2: multiple currency support (1997)
WebCatalog vidoes (was: Prices Dropped) (1998)
MATH TIME (1997)
Search in 2 or more catalogs (1997)
Cybersource and WebCat ... again (2000)
WebCatalog on G3 Macs? (1997)
ReplaceFoundItems (2006)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Online Docs? (1997)
emailer w/F2 (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
Users.db (1998)
Help! I've fallen in Structured Query Language and can't getup. (2002)
OH CRAP!!!!!- Template not found error!!! (1999)
Location of Browser Info.txt file (1997)
All of a Sudden Type 2 errors (1999)
[WebDNA] Sorry WebDNA server not running - September 2019 Edition (2019)
Include a big block of text (1997)