Re: [WebDNA] Replace / Append only unique data
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110662
interpreted = N
texte = That works great! I never thought to only search for unique items in the first place. Thanks Steve. sfb On Sep 10, 2013, at 12:56 PM, Steve Craig
wrote: > Hi >=20 > You can add a summarise to your search FieldNamesumm=3DT.=20 >=20 >=20 > [search db=3D/reservations.db&geSKUdata=3D1&STAFF_NAMEsumm=3DT] > [founditems] > Append to other database stuff > [/founditems] > [/search] =20 >=20 > Maybe this will help. >=20 > Cheers > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Steve Craig - Asylum Interactive > Tel +44 1330 860550 Fax +44 1330 860880 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > http://www.asylumweb.com > Email: steve@asylumweb.com > Skype: s.craig - iChat: steve.craig > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >=20 >=20 >=20 >=20 >=20 > On 10 Sep 2013, at 17:37, Stephen Braun wrote: >=20 >> Hi Lawrence, >> Yes, Thank you, I looked at the [replacefounditems] tag, but I'm = using two different databases. I guess that I should have said that = upfront. >> I'm getting [founditems] out of reservations.db and [append] them to = temp.db, but I only want the unique ones. >>=20 >>=20 >> Here's the whole code: >> [search db=3D/reservations.db&geSKUdata=3D1][founditems] >> [replace = db=3Dtemp.db&eqSTAFF_NAMEdata=3D[STAFF_NAME]&autonumber=3DSKUT&append=3DT]= STAFF_NAME=3D[url][real_name][/url][/replace] >> [/founditems][/search] =20 >>=20 >> sfb >>=20 >>=20 >> On Sep 10, 2013, at 12:11 PM, Lawrence Banahan = wrote: >>=20 >>> You should try a replacefounditems >>>=20 >>> Lawrence >>>=20 >>> Le 10 sept. 2013 18:09, "Stephen Braun" a = =E9crit : >>> Hi All, >>> I would like to replace or append to a database as necessary, only = the unique data. >>> I know that there is a simple way, but I just can't seem to figure = it out. >>>=20 >>> Here's the code that I have: >>> [replace = db=3Dtemp.db&autonumber=3DSKUT&append=3DT&eqSTAFF_NAMEdatarq=3D[STAFF_NAME= ]]STAFF_NAME=3D[url][real_name][/url][/replace] >>>=20 >>>=20 >>>=20 >>>=20 >>> My Data going in: >>> John Doe >>> John Doe >>> Bill Smith >>> Jane Doe >>> Jane Doe >>> John Doe >>> John Doe >>> John Doe >>> Jane Doe >>> Bill Smith >>> Bill Smith >>> John Doe >>>=20 >>> Desired result in the temp.db >>> John Doe >>> Bill Smith >>> Jane Doe >>>=20 >>>=20 >>>=20 >>>=20 >>> Thanks for any assistance. >>> sfb >>>=20 >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
That works great! I never thought to only search for unique items in the first place. Thanks Steve. sfb On Sep 10, 2013, at 12:56 PM, Steve Craig wrote: > Hi >=20 > You can add a summarise to your search FieldNamesumm=3DT.=20 >=20 >=20 > [search db=3D/reservations.db&geSKUdata=3D1&STAFF_NAMEsumm=3DT] > [founditems] > Append to other database stuff > [/founditems] > [/search] =20 >=20 > Maybe this will help. >=20 > Cheers > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Steve Craig - Asylum Interactive > Tel +44 1330 860550 Fax +44 1330 860880 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > http://www.asylumweb.com > Email: steve@asylumweb.com > Skype: s.craig - iChat: steve.craig > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >=20 >=20 >=20 >=20 >=20 > On 10 Sep 2013, at 17:37, Stephen Braun wrote: >=20 >> Hi Lawrence, >> Yes, Thank you, I looked at the [replacefounditems] tag, but I'm = using two different databases. I guess that I should have said that = upfront. >> I'm getting [founditems] out of reservations.db and [append] them to = temp.db, but I only want the unique ones. >>=20 >>=20 >> Here's the whole code: >> [search db=3D/reservations.db&geSKUdata=3D1][founditems] >> [replace = db=3Dtemp.db&eqSTAFF_NAMEdata=3D[STAFF_NAME]&autonumber=3DSKUT&append=3DT]= STAFF_NAME=3D[url][real_name][/url][/replace] >> [/founditems][/search] =20 >>=20 >> sfb >>=20 >>=20 >> On Sep 10, 2013, at 12:11 PM, Lawrence Banahan = wrote: >>=20 >>> You should try a replacefounditems >>>=20 >>> Lawrence >>>=20 >>> Le 10 sept. 2013 18:09, "Stephen Braun" a = =E9crit : >>> Hi All, >>> I would like to replace or append to a database as necessary, only = the unique data. >>> I know that there is a simple way, but I just can't seem to figure = it out. >>>=20 >>> Here's the code that I have: >>> [replace = db=3Dtemp.db&autonumber=3DSKUT&append=3DT&eqSTAFF_NAMEdatarq=3D[STAFF_NAME= ]]STAFF_NAME=3D[url][real_name][/url][/replace] >>>=20 >>>=20 >>>=20 >>>=20 >>> My Data going in: >>> John Doe >>> John Doe >>> Bill Smith >>> Jane Doe >>> Jane Doe >>> John Doe >>> John Doe >>> John Doe >>> Jane Doe >>> Bill Smith >>> Bill Smith >>> John Doe >>>=20 >>> Desired result in the temp.db >>> John Doe >>> Bill Smith >>> Jane Doe >>>=20 >>>=20 >>>=20 >>>=20 >>> Thanks for any assistance. >>> sfb >>>=20 >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Stephen Braun
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:
Normalizing Dates and Phone numbers (2000)
about this server and links to who (1997)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
Error: Too many nested [xxx] contexts (1997)
[CART] inside a [LOOP] (1997)
Search returns all, not 20 (1997)
WebCat2b12 - nesting [tags] (1997)
Newbie problem blah blah blah (1997)
NetSplat and WebCat2 (1997)
Error Msg (1998)
WebCat2.0 [format thousands .0f] no go (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Max Record length restated as maybe bug (1997)
Sendmail problem (2002)
Calculating multiple shipping... (1997)
Looking for 5 to 12 shops with 3 URLs & statements (1997)
Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003)
WebCat2b12plugin - [search] is broken ... not! (1997)
[showif],[referer],[include] in errormessages.db (2002)
PCS Frames (1997)