Re: [WebDNA] Replace / Append only unique data

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110659
interpreted = N
texte = summ=T ? -Dan On Tue, 10 Sep 2013 12:37:51 -0400 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. Here's the whole code: [search db=/reservations.db&geSKUdata=1][founditems] [replace db=temp.db&eqSTAFF_NAMEdata=[STAFF_NAME]&autonumber=SKUT&append=T]STAFF_NAME=[url][real_name][/url][/replace] [/founditems][/search] sfb On Sep 10, 2013, at 12:11 PM, Lawrence Banahan wrote: > You should try a replacefounditems > > Lawrence > > Le 10 sept. 2013 18:09, "Stephen Braun" a écrit : > 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=temp.db&autonumber=SKUT&append=T&eqSTAFF_NAMEdatarq=[STAFF_NAME]]STAFF_NAME=[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 . > 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 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)
summ=T ? -Dan On Tue, 10 Sep 2013 12:37:51 -0400 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. Here's the whole code: [search db=/reservations.db&geSKUdata=1][founditems] [replace db=temp.db&eqSTAFF_NAMEdata=[STAFF_NAME]&autonumber=SKUT&append=T]STAFF_NAME=[url][real_name][/url][/replace] [/founditems][/search] sfb On Sep 10, 2013, at 12:11 PM, Lawrence Banahan wrote: > You should try a replacefounditems > > Lawrence > > Le 10 sept. 2013 18:09, "Stephen Braun" a écrit : > 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=temp.db&autonumber=SKUT&append=T&eqSTAFF_NAMEdatarq=[STAFF_NAME]]STAFF_NAME=[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 . > 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 "Dan Strong"

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:

.. more on sliding discounts... (1997) This is an odd error (2001) [append] vs. [appendfile] delta + question? (1997) Error Messges (1997) Wierd problem with 3.08 WIN Version (2000) triggering an update of two frames (1998) Extended [ConvertChars] (1997) [OT] Internet connection problem (2003) problems with 2 tags shakur (1997) # fields limited? (1997) [shownext max=?] armed (1997) Help name our technology! (1997) Can WC remember people? (1998) POP Mail Server Reseting (1998) Sandboxes & Kitty Litter trays (2003) Sort Order on a page search (1997) cybercash on OSX - was Executing remote AppleScript (2000) truncating email part II (1997) suffix mapping, use of cache, etc. (1997) WebCat2b15MacPlugin - showing [math] (1997)