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:
Loop into field (1998)
Multiple security dbs (1997)
Generating unique SKU from [cart] (1997)
Cancel Subscription (1996)
encripted storage (1998)
problems with 2 tags (1997)
San Diego WebCat/Network Position (2000)
Server IP address? (1998)
File not found error message (1998)
[OrderFile] error (help) (1999)
PIXO support (1997)
[sendmail] ampersand issue (2001)
ExpireDate Zero or Greater than Today (2006)
Serving images from databases (1998)
Problems w/ heavy use of cart header fields? (1998)
[WebDNA] Active Directory (2013)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
UPPERCASE (1997)
$append (1998)
MacActivity and PCS (1997)