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:
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:
Firesite cache vs webcat cache (1997)
Squares instead of spaces (2001)
Sendmail doesn't (was Queertrons?) (1997)
Showif, Hideif reverse logic ? (1997)
Is this possible, WebCat2.0 and checkboxes (1997)
Running a store on BOTH http and https (1998)
emailer (1997)
WebCat2 several catalogs? (1997)
dos performance (1998)
Sort Order on a page search (1997)
NT vs Mac (1997)
SKU (1997)
Windows version Trouble Shooting (2007)
WC1.6 to WC2 date formatting (1997)
[Price] (1997)
I'm new be kind (1997)
ReturnRaw Returns (2000)
Max Include levels (2000)
[OT] Internet connection problem (2003)
problems with 2 tags (1997)