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 ?-DanOn 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 wantthe unique ones. Here's the whole code: [search db=/reservations.db&geSKUdata=1][founditems] [replacedb=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:
summ=T ?-DanOn 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 wantthe unique ones. Here's the whole code: [search db=/reservations.db&geSKUdata=1][founditems] [replacedb=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)