Re: Suggestion: appendfounditems
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40551
interpreted = N
texte = Thank you. Of course this works, but that is exactly what I am trying NOT to do. Therefore my suggestion for a new appendfounditems tag.In the meantime your code works well:-)Sincerely, NitaiOn 11.6.2002 7:13 PM, marc malacarme
wrote:> 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/-- Tools to energize business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/ Hauptstrasse 12 info@computeroil.com 8252 Schlatt/Switzerland Tel: +41 (0)52 654 15 55 ------------------------------------------------------------- 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:
Thank you. Of course this works, but that is exactly what I am trying NOT to do. Therefore my suggestion for a new appendfounditems tag.In the meantime your code works well:-)Sincerely, NitaiOn 11.6.2002 7:13 PM, marc malacarme wrote:> 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/-- Tools to energize business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/ Hauptstrasse 12 info@computeroil.com 8252 Schlatt/Switzerland Tel: +41 (0)52 654 15 55 ------------------------------------------------------------- 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/
ComputerOil Nitai
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:
2nd WebCatalog2 Feature Request (1996)
WebDNA performance comparisons? (2004)
Nested tags count question (1997)
CMS - Formatting Content (2004)
webcat- multiple selection in input field (1997)
Max Record length restated as maybe bug (1997)
[OT] Indexing of dynamic web sites (2003)
Can this be done? (1997)
[encrypt] problems? (1998)
WebCat and WebTV (1997)
WCS Newbie question (1997)
formula??? (2000)
Cannot open database (1999)
reversing the effects of [url] (1997)
ListFields and [name] (1997)
listfiles-looking for slick solution (1997)
WebCatalog for Postcards ? (1997)
Languages (1997)
[CART] inside a [LOOP] (1997)
Re:upgrade problem with users.db (1998)