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:

SiteEdit Pro Update Announcement (1997) E-mailer error codes (1997) Search in 2 or more catalogs (1997) Webcat 2.0.1 date math bug -> Crash! (1997) running WebCatalog under Apache on NT? (2000) Errata: WCS Newbie question (1997) problems with 2 tags (1997) Location of Browser Info.txt file (1997) Help! WebCat2 bug (1997) Dates - Search and Sorting (1999) Ampersand in XHTML Code - Not Valid (2005) PayFlow Pro (2003) Pithy questions on webcommerce & siteedit (1997) Error Lob.db records error message not name (1997) Share cost of training videos! (1998) [WebDNA] Problem with Cookies in IE and Safari (2009) Problems with [Applescript] (1997) WCS Newbie question (1997) Secure Server (1999) Coding Standards - are there any ? (2003)