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:
insecure client not shown (1998)
search results (1998)
WebCat virtual postcard is done! Thanks for the help! (1998)
pc (1997)
WebCat2 several catalogs? (1997)
My first ship table (1998)
SKU lookup (1997)
Re:quit command on NT (1997)
Suddenly can't see files... (2000)
credit card (1997)
Associative lookup style? (1997)
Banners (1997)
Next (1997)
Get current URL with Variables (2005)
Question on the sandbox (2003)
Webcat deletes last line from Excel-saved text db (2004)
show all problem (1997)
suffix mapping for NT? (1997)
Re:no [search] with NT (1997)
Multiple download orders of the same product? (1997)