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-CABC5F016E79Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=iso-8859-1Hi 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] =20sfbOn 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-CABC5F016E79Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=iso-8859-1Hi =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>
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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us
=--Apple-Mail=_66E196B5-0708-4F66-9A62-CABC5F016E79--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_66E196B5-0708-4F66-9A62-CABC5F016E79Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=iso-8859-1Hi 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] =20sfbOn 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-CABC5F016E79Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=iso-8859-1Hi =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:
=[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>
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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug 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)