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:

Not really WebCat (1997) MacAuthorize hub, no modal password dialog? (1997) New Guestbook Source (1997) RE: [WebDNA] webdna.us (2008) pull downs (1997) Multiple catalog databases and showcart (1997) Replace/Commit not Replacing/Commiting (2000) Resetting a Formvariable (2000) [WebDNA] proxy server domains mysteriously appear in webdna's domain list (2010) ANother SHOWIF problem (1997) MacWEEK article help needed (1996) ACGI processing for .html (1997) EIMS Problems (1997) PayFlowPro (2003) [ot] Raid Cards for RH ES (2004) WebCat2 - [SendNews] (1997) Generating unique SKU from [cart] (1997) Sendmail - Attachment / My First Post (2001) Orderfile Question (2003) I'm having trouble using [url][interpret][math] together inlookup (1997)