Re: [WebDNA] Replace / Append only unique data

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110658
interpreted = N
texte = --Apple-Mail=_66E196B5-0708-4F66-9A62-CABC5F016E79 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 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. 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 sfb On Sep 10, 2013, at 12:11 PM, Lawrence Banahan = wrote: > 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 --Apple-Mail=_66E196B5-0708-4F66-9A62-CABC5F016E79 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 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.


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]
[/foun= ditems][/search] =   

sfb

<= br>
On Sep 10, 2013, at 12:11 PM, Lawrence Banahan <banahan.l@gmail.com> = wrote:

You should try a replacefounditems

Lawrence

Le 10 sept. 2013 18:09, "Stephen Braun" = <sbraun1@twcny.rr.com> = 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.

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]




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

Desired result in the temp.db
John Doe
Bill Smith
Jane Doe




Thanks for any assistance.
sfb


---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_66E196B5-0708-4F66-9A62-CABC5F016E79-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
  2. Re: [WebDNA] Replace / Append only unique data (Steve Craig 2013)
  3. Re: [WebDNA] Replace / Append only unique data (Steve Craig 2013)
  4. Re: [WebDNA] Replace / Append only unique data ("Dan Strong" 2013)
  5. Re: [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
  6. Re: [WebDNA] Replace / Append only unique data (Lawrence Banahan 2013)
  7. [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
--Apple-Mail=_66E196B5-0708-4F66-9A62-CABC5F016E79 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 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. 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 sfb On Sep 10, 2013, at 12:11 PM, Lawrence Banahan = wrote: > 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 --Apple-Mail=_66E196B5-0708-4F66-9A62-CABC5F016E79 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 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.


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]
[/foun= ditems][/search] =   

sfb

<= br>
On Sep 10, 2013, at 12:11 PM, Lawrence Banahan <banahan.l@gmail.com> = wrote:

You should try a replacefounditems

Lawrence

Le 10 sept. 2013 18:09, "Stephen Braun" = <sbraun1@twcny.rr.com> = 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.

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]




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

Desired result in the temp.db
John Doe
Bill Smith
Jane Doe




Thanks for any assistance.
sfb


---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_66E196B5-0708-4F66-9A62-CABC5F016E79-- Stephen Braun

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:

How big can WebCat go? (1999) A multi-processor savvy WebCatalog? (1997) Webcat causing crashes left and right! (1997) RE: Missing contexts on NT (1997) Exclamation point (1997) _ in front of field name (1998) Shopping Cart - prices? (1997) WebCatalog can't find database (1997) all records returned. (1997) Date search - yes or no (1997) Include file not working on remote directory. (2004) Q: writefile and uploads. (1998) F3 crashing server (1997) AD Error Msg (1997) [WebDNA] Test (2008) WebCat for mass emailings (1997) Customer (1998) [WebDNA] Authorize.net (2014) Limiting user access to .tmpl files (1997) Hiding HTML and breaking the page (1997)