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:

Re: [WebDNA] Replace / Append only unique data (Stephen Braun 2013) Re: [WebDNA] Replace / Append only unique data (Steve Craig 2013) Re: [WebDNA] Replace / Append only unique data (Steve Craig 2013) Re: [WebDNA] Replace / Append only unique data ("Dan Strong" 2013) Re: [WebDNA] Replace / Append only unique data (Stephen Braun 2013) Re: [WebDNA] Replace / Append only unique data (Lawrence Banahan 2013) [WebDNA] Replace / Append only unique data (Stephen Braun 2013)

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:

WebCatalog for guestbook ? (1997) Supressing Error Messages (1998) [WebDNA] OS X mail server (2009) [isfolder] and [filename] (1997) Another IfThenElse question.. (2003) Not really WebCat (1997) Searching multiple fields from one form field (1997) Separate SSL Server (1997) carriage returns in data (1997) [OT] Certs (2002) WebCat2.0 [format thousands .0f] no go (1997) [WebDNA] SweepCartFrequency (2010) PhotoMill -> PhotoMaster (1997) Viewing/Editing Databases Online (1999) Access Denied! But why? (1997) [TaxableTotal] - not working with AOL and IE (1997) Trouble with formula.db (1997) authorizenet and netscape (2002) popups, netscape vs explorer (1997) Reversed words (1997)