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 = HiYou 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] =20Maybe 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=3DSteve Craig - Asylum InteractiveTel +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=3Dhttp://www.asylumweb.comEmail: steve@asylumweb.comSkype: 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=3DOn 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:
HiYou 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] =20Maybe 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=3DSteve Craig - Asylum InteractiveTel +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=3Dhttp://www.asylumweb.comEmail: steve@asylumweb.comSkype: 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=3DOn 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:
Banner Ad example (Typhoon) and WebCatalog (1997)
How bad an idea is it to put cart=[cart] on all links? (2000)
WebCatalog for Postcards ? (1997)
Database Not Found Problem (2004)
shipcost (1997)
NT or Mac (1998)
emailer (1997)
WebDNA to Apache RewriteMap (2005)
RE: automatic reload of frameset (1997)
WebCat for Site Search? (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Running _every_ page through WebCat ? (1997)
two forms of delivery (1998)
Trouble with [Math] (1998)
Cut off from the list and can't get an answer to the confused re:QTY price updating question (1998)
question: back button prevention (1997)
Spiders (1998)
WebCat, The Trend, & Consolidating... (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
wish list (2002)