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:

Ruby on Rails (was Looping Search) (2006) Problem using # in my field names ... (1998) [/application] error? (1997) MacAuthorize hub, no modal password dialog? (1997) [OT] - Block Traffic to DevBox (2003) Check for OS (2003) shownext (1997) forms and variables (1998) weird happenings (1997) unable to launch acgi in WebCat (1997) Interesting speed comparison .. (2003) Conveting Characters to Graphics (1997) Date or time comparisons have bugs ... (1998) problems with 2 tags (1997) Secure server question (1997) Webdna sends your serial number on Internet (2003) [tcpconnect] doing nothing (2001) [createfolder] & [deletefolder] (1997) WebDNA equivalent for $REQUEST_URI (2004) Training Announcement (2004)