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:

HMAC-MD5 hash -- what the... (2003) Postdata expired from cache (2004) WebCatalog [FoundItems] Problem - AGAIN - (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Bug - 4.5 (2002) WebCat2_Mac RETURNs in .db (1997) Is this possible, WebCat2.0 and checkboxes (1997) many-to-one problem (1998) select multiple (1997) [protect admin] (1997) Hiding HTML and breaking the page (1997) Multiple SSL Keys (1998) webcat 2.1 new cart fields - please explain more (1998) Need help with emailer- 2 issues (1997) setting cookies for another domain? (2002) Authenticate (1997) Error Log.db --however (1997) WC Database Format (1997) attn: smitmicro - cart limitation (2002) About WebDNA (2006)