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 dois replace the db_is=value with your dbs name, and unique_field=SKU fieldname with your unique field name, and your search context. Once you removethe 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 thenew_unique_field_value below alone. Although it will make your new skulonger in length than [date %Y%m%d][time %H%M%S]. It duplicates 1000 recordsin 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 forthe append. depending on your db unique_field I use[math][sku]+[index][/math] because my field is numeric and calledsku----------[/!][text]new_unique_field_value=[interpret][[unique_field]][/interpret][index][/text][!]-----------------------// copies all the fields except sku back into thedb from the found set----------[/!][append db=[db_is]][interpret][db_fields][/interpret][unique_field]=[new_unique_field_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 dois replace the db_is=value with your dbs name, and unique_field=SKU fieldname with your unique field name, and your search context. Once you removethe 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 thenew_unique_field_value below alone. Although it will make your new skulonger in length than [date %Y%m%d][time %H%M%S]. It duplicates 1000 recordsin 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 forthe append. depending on your db unique_field I use[math][sku]+[index][/math] because my field is numeric and calledsku----------[/!][text]new_unique_field_value=[interpret][[unique_field]][/interpret][index][/text][!]-----------------------// copies all the fields except sku back into thedb from the found set----------[/!][append db=[db_is]][interpret][db_fields][/interpret][unique_field]=[new_unique_field_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!

Re: Suggestion: appendfounditems

2002

Top Articles:

Related Readings: