Re: [WebDNA] Can't see were it's wrong....
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113380
interpreted = N
texte = 973[replacefounditems] works on the same db, not on a different db.Weren't you trying to replace in a different db? Or was that amistake from the beginning?Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 01/17/2017 11:55 AM, Lawrence Banahan wrote:> I have found out an other way... Not very nice but it works>=20> [ReplaceFoundItems]Boat_length=3D[LOOKUP> db=3DTable_HN.txt&value=3D[MATRICULE].0&lookInField=3DMATRICULE&returnF=ield=3DLONG¬Found=3DTextIfNotFound][!]> [/!]&Boat_width=3D[url][LOOKUP> db=3DTable_HN.txt&value=3D[MATRICULE].0&lookInField=3DMATRICULE&returnF=ield=3Dbau¬Found=3DTextIfNotFound][/url][!]> [/!]&Boat_deep=3D[url][Grep search=3D &replace=3D][LOOKUP> db=3DTable_HN.txt&value=3D[MATRICULE].0&lookInField=3DMATRICULE&returnF=ield=3DTirant¬Found=3DTextIfNotFound][/Grep][/url][/ReplaceFoundItems]>=20> and doing that I understood what went on...> in one db I have "[MATRICULE] " ex:145> and in the other one "[MATRICULE] .0" ex:145.0> It's not my db, i'm downloading them from an other server, I'm> feel so silly....>=20> Sorry for bothering you falks!!!and thaks a lot for tying to help me>> Toby Cox
>> 17 janvier 2017 18:45>> right>>>> I see what you=E2=80=99re doing here and what you want to do (sorry fo=r>> not reading original thread)>>>> Can you add>>>> [search>> db=3Dcar_glob.txt&nematriculedatarq=3D[blank]][founditems]matricule=3D=[matricule]
> />[/founditems][/search]>>>> so we can see what=E2=80=99s what?>>>> And also, I often found that something like this is helpful (to>> your main query)=E2=80=A6>>>> [search db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]=20>> [FoundItems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boat_deep=3D[Tiran=t]
=20>> [Replace>> db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&B=oat_width=3D[bau]&Boat_deep=3D[Tirant][/Replace]=20>>>> [raw][[/raw]Replace>> db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&B=oat_width=3D[bau]&Boat_deep=3D[Tirant][raw][[/raw]/Replace]
> />>>>> [/FoundItems]=20>> [/search]=20>>>> so you can see what webdna is really trying to do with your data=E2=80==A6>>>>>>>>>> --------------------------------------------------------- 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>> Toby Cox >> 17 janvier 2017 18:31>> sorry - misread>>>> you don=E2=80=99t do a replace within search>>>> do this>>>> [search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]>> [replacefounditems][/replacefounditems]>> [/search]>>>>>> --------------------------------------------------------- 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>> Lawrence Banahan >> 17 janvier 2017 18:13>> Thanks toby, it doesn't change anything...>>>> The exemple is>> [Replace>> db=3DSomeDatabase.db&eqNAMEdata=3DGrant]name=3DJohn&address=3D1492>> Somewhere Lane&zip=3D90000&date=3D[date][/Replace]>>>>>> Toby Cox >> 17 janvier 2017 18:04>> think>>>> db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]boat_leng=th=3D[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][ti=rant][/url][/replace]>>>> should be>>>> db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]&boat_len=gth=3D[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][t=irant][/url]>>>> you=E2=80=99re missing an ampersand before boat_length>>>>>>>> On 17 Jan 2017, at 16:54, Lawrence Banahan >> > wrote:>>>>>> Even more strange Kenneth...>>> With you code>>> http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna>>>>>>> Kenneth Grome17 janvier 2017 17:47>>>> Try this:>>>>>>>> [flushdatabases]>>>>>>>> [search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]>>>> [founditems]>>>>>>>> boat_length=3D[long]&boat_width=3D[bau]&boat_deep=3D[tirant]
>>>>>>>> [replace>>>> db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]boat_le=ngth=3D[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][=tirant][/url][/replace]>>>>>>>> [/founditems]>>>> [/search]>>>>>>>> [flushdatabases]>>>>>>>> Regards,>>>> Kenneth Grome>>>> WebDNA Solutions>>>> http://www.webdnasolutions.com>>>> Web Database Systems and Linux Server Administration>>>>>>>>>>>> --------------------------------------------------------->>>> 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>>>> Lawrence Banahan17 janvier 2017 17:24>>>> Hi,=20>>>>>>>> I have this simple search.=20>>>>>>>> [search db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]=20>>>> [FoundItems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boat_deep=3D[Tir=ant]
=20>>>> [Replace db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length==3D[LONG]&Boat_width=3D[bau]&Boat_deep=3D[Tirant][/Replace]=20>>>> [/FoundItems]=20>>>> [/search]=20>>>>>>>>>>>> The search is going on well as it is displaying in the html,>>>> but not replacinf in the DB=20>>>> http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna=20>>>>>>>> I have allowed in the preference : database extension as .db,>>>> .txt=20>>>>>>>> If any one could open my eyes...=20>>>>>>>> Thanks=20>>>> Lawrence=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>> Lawrence Banahan >> 17 janvier 2017 17:54>> Even more strange Kenneth...>> With you code>> http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna>>> --------------------------------------------------------- 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
973[replacefounditems] works on the same db, not on a different db.Weren't you trying to replace in a different db? Or was that amistake from the beginning?Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 01/17/2017 11:55 AM, Lawrence Banahan wrote:> I have found out an other way... Not very nice but it works>=20> [replacefounditems]Boat_length=3D[LOOKUP> db=3DTable_HN.txt&value=3D[MATRICULE].0&lookInField=3DMATRICULE&returnF=ield=3DLONG¬Found=3DTextIfNotFound][!]> [/!]&Boat_width=3D[url][LOOKUP> db=3DTable_HN.txt&value=3D[MATRICULE].0&lookInField=3DMATRICULE&returnF=ield=3Dbau¬Found=3DTextIfNotFound][/url][!]> [/!]&Boat_deep=3D[url][Grep search=3D &replace=3D][LOOKUP> db=3DTable_HN.txt&value=3D[MATRICULE].0&lookInField=3DMATRICULE&returnF=ield=3DTirant¬Found=3DTextIfNotFound][/Grep][/url][/ReplaceFoundItems]>=20> and doing that I understood what went on...> in one db I have "[MATRICULE] " ex:145> and in the other one "[MATRICULE] .0" ex:145.0> It's not my db, i'm downloading them from an other server, I'm> feel so silly....>=20> Sorry for bothering you falks!!!and thaks a lot for tying to help me>> Toby Cox >> 17 janvier 2017 18:45>> right>>>> I see what you=E2=80=99re doing here and what you want to do (sorry fo=r>> not reading original thread)>>>> Can you add>>>> [search>> db=3Dcar_glob.txt&nematriculedatarq=3D[blank]][founditems]matricule=3D=[matricule]
> />[/founditems][/search]>>>> so we can see what=E2=80=99s what?>>>> And also, I often found that something like this is helpful (to>> your main query)=E2=80=A6>>>> [search db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]=20>> [founditems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boat_deep=3D[Tiran=t]
=20>> [Replace>> db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&B=oat_width=3D[bau]&Boat_deep=3D[Tirant][/Replace]=20>>>> [raw][[/raw]Replace>> db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&B=oat_width=3D[bau]&Boat_deep=3D[Tirant][raw][[/raw]/Replace]
> />>>>> [/FoundItems]=20>> [/search]=20>>>> so you can see what webdna is really trying to do with your data=E2=80==A6>>>>>>>>>> --------------------------------------------------------- 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>> Toby Cox >> 17 janvier 2017 18:31>> sorry - misread>>>> you don=E2=80=99t do a replace within search>>>> do this>>>> [search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]>> [replacefounditems][/replacefounditems]>> [/search]>>>>>> --------------------------------------------------------- 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>> Lawrence Banahan >> 17 janvier 2017 18:13>> Thanks toby, it doesn't change anything...>>>> The exemple is>> [Replace>> db=3DSomeDatabase.db&eqNAMEdata=3DGrant]name=3DJohn&address=3D1492>> Somewhere Lane&zip=3D90000&date=3D[date][/Replace]>>>>>> Toby Cox >> 17 janvier 2017 18:04>> think>>>> db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]boat_leng=th=3D[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][ti=rant][/url][/replace]>>>> should be>>>> db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]&boat_len=gth=3D[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][t=irant][/url]>>>> you=E2=80=99re missing an ampersand before boat_length>>>>>>>> On 17 Jan 2017, at 16:54, Lawrence Banahan >> > wrote:>>>>>> Even more strange Kenneth...>>> With you code>>> http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna>>>>>>> Kenneth Grome17 janvier 2017 17:47>>>> Try this:>>>>>>>> [flushdatabases]>>>>>>>> [search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]>>>> [founditems]>>>>>>>> boat_length=3D[long]&boat_width=3D[bau]&boat_deep=3D[tirant]
>>>>>>>> [replace>>>> db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]boat_le=ngth=3D[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][=tirant][/url][/replace]>>>>>>>> [/founditems]>>>> [/search]>>>>>>>> [flushdatabases]>>>>>>>> Regards,>>>> Kenneth Grome>>>> WebDNA Solutions>>>> http://www.webdnasolutions.com>>>> Web Database Systems and Linux Server Administration>>>>>>>>>>>> --------------------------------------------------------->>>> 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>>>> Lawrence Banahan17 janvier 2017 17:24>>>> Hi,=20>>>>>>>> I have this simple search.=20>>>>>>>> [search db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]=20>>>> [founditems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boat_deep=3D[Tir=ant]
=20>>>> [Replace db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length==3D[LONG]&Boat_width=3D[bau]&Boat_deep=3D[Tirant][/Replace]=20>>>> [/FoundItems]=20>>>> [/search]=20>>>>>>>>>>>> The search is going on well as it is displaying in the html,>>>> but not replacinf in the DB=20>>>> http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna=20>>>>>>>> I have allowed in the preference : database extension as .db,>>>> .txt=20>>>>>>>> If any one could open my eyes...=20>>>>>>>> Thanks=20>>>> Lawrence=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>> Lawrence Banahan >> 17 janvier 2017 17:54>> Even more strange Kenneth...>> With you code>> http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna>>> --------------------------------------------------------- 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Kenneth Grome
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:
Webcat/Webmerchant (1998)
Bug Report, maybe (1997)
Field name-subcategory (1997)
How to Display text in empty fields (1997)
Transferring textareas (1997)
WebCat/CyberStudio Compatibility (1998)
Email Problem (2006)
Multi shift click (1999)
FileMaker and WebCat - .hdr OK Merge not OK (1999)
Gems (2006)
[WebDNA] PDF creation (2013)
Custom formulas.db (1998)
checksum for credit cards? (1997)
[WebDNA] Date: header on emails - timezone problem perhaps (emai)
select multiple 2 more cents (1997)
Email Formatting (1998)
Re:Emailer and encryption (1997)
pc (1997)
Keeping text formatting (like hard returns) (2002)
New Plug-in and Type 11 errors (1997)