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 a mistake from the beginning? Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 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 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] Can't see were it's wrong.... (Lawrence Banahan 2017)
  2. Re: [WebDNA] Can't see were it's wrong.... (Kenneth Grome 2017)
  3. Re: [WebDNA] Can't see were it's wrong.... (Kenneth Grome 2017)
  4. Re: [WebDNA] Can't see were it's wrong.... (Kenneth Grome 2017)
  5. Re: [WebDNA] Can't see were it's wrong.... (BROOKS WILLIAMS 2017)
  6. Re: [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
  7. Re: [WebDNA] Can't see were it's wrong.... (Toby Cox 2017)
  8. Re: [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
  9. Re: [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
  10. Re: [WebDNA] Can't see were it's wrong.... (Toby Cox 2017)
  11. Re: [WebDNA] Can't see were it's wrong.... (Kenneth Grome 2017)
  12. Re: [WebDNA] Can't see were it's wrong.... (Eddie Z 2017)
  13. Re: [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
  14. Re: [WebDNA] Can't see were it's wrong.... (Kenneth Grome 2017)
  15. Re: [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
  16. Re: [WebDNA] Can't see were it's wrong.... (Toby Cox 2017)
  17. Re: [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
  18. Re: [WebDNA] Can't see were it's wrong.... (Kenneth Grome 2017)
  19. Re: [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
  20. Re: [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
  21. RE: [WebDNA] Can't see were it's wrong.... (Brian Boegershausen 2017)
  22. [WebDNA] Can't see were it's wrong.... (Lawrence Banahan 2017)
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 a mistake from the beginning? Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 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 to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug 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)