Re: [WebDNA] Replace / Append only unique data

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110660
interpreted = N
texte = Hi You can add a summarise to your search FieldNamesumm=3DT.=20 [search db=3D/reservations.db&geSKUdata=3D1&STAFF_NAMEsumm=3DT] [founditems] Append to other database stuff [/founditems] [/search] =20 Maybe this will help. 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 On 10 Sep 2013, at 17:37, Stephen Braun wrote: > 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
  2. Re: [WebDNA] Replace / Append only unique data (Steve Craig 2013)
  3. Re: [WebDNA] Replace / Append only unique data (Steve Craig 2013)
  4. Re: [WebDNA] Replace / Append only unique data ("Dan Strong" 2013)
  5. Re: [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
  6. Re: [WebDNA] Replace / Append only unique data (Lawrence Banahan 2013)
  7. [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
Hi You can add a summarise to your search FieldNamesumm=3DT.=20 [search db=3D/reservations.db&geSKUdata=3D1&STAFF_NAMEsumm=3DT] [founditems] Append to other database stuff [/founditems] [/search] =20 Maybe this will help. 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 On 10 Sep 2013, at 17:37, Stephen Braun wrote: > 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 Steve Craig

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:

[WebDNA] Any way within WebDNA to tell if a file can be modified by current user? (2010) Re:Virtual hosting and webcatNT (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997) Pricing based on quantity (2000) emailer (1997) WebCatalog NT (1996) Math (1997) First time Installation problems (1999) Show if time tags (1997) syntax question, not in online refernce (1997) Using Plug-In while running 1.6.1 (1997) Caching [include] files ... (1997) 2.0 Info (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Parameter Problem (1998) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) SiteEdit Pro Update Announcement (1997) SHOWIF/HIDEIF empty fields (2005) emailer (1997) [WebDNA] High-profile WebDNA sites? (2008)