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:

Searching Multiple DBs (1997) categorys (1998) nesting limits? (1998) [WebDNA] multi [sendmail] inside [search] (2012) setlineiems and UnitShip Cost (2000) admin:admin won't work for login:password ! (1999) Help name our technology! (1997) AE aware WebCatalog.acgi? (1997) form data submission gets truncated (1997) Subtotal Taxabletotal Grandtotal **CART** (2005) Running _every_ page through WebCat ? (1997) WriteFile Command (1998) [WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009) Loosing Quantity (2000) need help with textA field (1998) WebCatalog for Postcards ? (1997) Checkboxes (1998) Date search bug (1998) NT challenges default admin/admin password (2000) quantity minimum problem (1997)