>> 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=_F95FE6BC-E834-4F80-B352-F4C17EE0A7A2Content-Type: multipart/related;type="text/html";boundary="Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2"--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=windows-1252right
I see what you=92re doing here and what =you want to do (sorry for not reading original thread)
Can you add
[search =db=3Dcar_glob.txt&nematriculedatarq=3D[blank]][founditems]matricule=3D=[matricule]<br />[/founditems][/search]
so we can see what=92s what?
And also, I often found =that something like this is helpful (to your main query)=85
[search =db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]
[FoundItems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boa=t_deep=3D[Tirant]<br>
[Replace =db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&a=mp;Boat_width=3D[bau]&Boat_deep=3D[Tirant][/Replace]
[raw][[/raw]Replace =db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&a=mp;Boat_width=3D[bau]&Boat_deep=3D[Tirant][raw][[/raw]/Replace]<br =/>
[/FoundItems]
[/search]
so you can see what =webdna is really trying to do with your data=85
On 17 Jan 2017, at =17:33, Lawrence Banahan <banahan.l@gmail.com> wrote:
I I use this
[search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]=
=[replacefounditems][/replacefounditems]
[/search]
I can't replace in an other db with =different values each time, it is ussually used when you are doing =[math] on some values
Toby =Cox=17 janvier 2017 18:31
sorry - misread
you don=92t 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=3D=John&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_length=3D[url][long][/url]&boat_width=3D[url][bau][/url]&bo=at_deep=3D[url][tirant][/url][/replace]
should be
db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url=]]&boat_length=3D[url][long][/url]&boat_width=3D[url][bau][/url]&a=mp;boat_deep=3D[url][tirant][/url]
you=92re =missing an ampersand before boat_length
On 17 Jan =2017, at 16:54, Lawrence Banahan =<banahan.l@gmail.com> wrote:
Even =more strange Kenneth...
With you code
http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna
Kenneth =Grome=17 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[ti=rant]<br>
[replace
db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url=]]boat_length=3D[url][long][/url]&boat_width=3D[url][bau][/url]&bo=at_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 <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
Lawrence =Banahan=17 janvier 2017 17:24
Hi,
I have this simple search.
[search db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]&n=bsp;
[FoundItems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boa=t_deep=3D[Tirant]<br>
[Replace =db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&a=mp;Boat_width=3D[bau]&Boat_deep=3D[Tirant][/Replace]
[/FoundItems]
[/search]
The search is going on well as =it is displaying in the html, but not replacinf in the DB
http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna
I have allowed in the preference : =database extension as .db, .txt
If= any one could open my eyes...
Thanks
Lawrence
--------------------------------------------------=------- 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
Kenneth =Grome=17 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[ti=rant]<br>
[replace
db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url=]]boat_length=3D[url][long][/url]&boat_width=3D[url][bau][/url]&bo=at_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 <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 =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--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2Content-Transfer-Encoding: base64Content-Disposition: inline;filename=postbox-contact.jpgContent-Type: image/jpeg;x-apple-mail-type=stationery;name="postbox-contact.jpg"Content-Id: /9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAAZABkDAREAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD7w+G/gv4OeN/DGi3viDwl4O1/xVc6FpuqazJeafa3N+z3MAYTTllL/OVfaW4O0gcDAAOpn+C3wSt4Xnm+EHgoJGpZj/wj1qeB7CPJ+goA+Qv2fv2tv2Pvjj8d/Efwht/hR4S8MmC4SHwjf3OhW9pNqssZIlIbarQTb8GJOHwuch/lAB4f/wANYftDf9FU1b/viL/4igDc/wCCjPxD1f4YfAL9n/xB8O/FWpeF/Gmp6PBbNqGj3ElpeT6athAXheaIgtGJWiIRieTkDrQB8beIrz/gofqfh6S+8VTfHu40W0WPVJJb0aqbeJYSJUnJb5QE2hwx6YB7UAfqf+xF8I/hR8Wvhl8P/wBrTxj8ONBuPilq9vc3V/rkdtsNxdpM9ubkxZ8sTMsCsXVQd7OwwWNAH54/bD60Afovdfs+av8AF/W/2VfiIbPQ77w78NtHkfXrLUvmkMz6fDHEEiKFWeOeLJDFSrJ6igD6X+JOgX/iz4d+KfCultGt5rOi32n27SsVQSzQPGhYgEgZYZODxQB5z+yL8LNf/Z5/Zn8I/DL4gX+m/wBpeGLW7+33FrOWtVD3U02Q7hTgJIMkgdDQB+UH/CAfEX/oQPEn/gquP/iKAO9/ax/5OP8AH/8A2Fj/AOi0oA8moA3/AIf/API/eGP+w1Yf+lCUAfuDQB//2Q==--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2Content-Transfer-Encoding: base64Content-Disposition: inline;filename=postbox-contact.jpgContent-Type: image/jpeg;x-apple-mail-type=stationery;name="postbox-contact.jpg"Content-Id: /9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAAZABkDAREAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD45+H+uan4r13x/wDE7xnb6d4guNI8Kxahv1LSYLt7zWL1IIbcMXQs372ZmC5wAgAAUAA5lBXbsZ1E5OMV1Z9ZWUvgb4I/Cfwf8OP2zP8AhFbHQ9TuIfEtnpel+DLaZnuBlpYpVgKyKVDosjFRkPtDDBA4cJj6WYSmqas1pc7a+Dq4NQlJ3T6f5H2p+zn498GfFP4aaPP8Mvh9p1n4eUNFYyQ6dJYx2MEMihUZJEVkLIdyGMsuOh4oaqTThGV2mik6amp1ItJp+fQT/hbfi3/oMXH5D/Cuq0v6f/AMOWPc+MP+Cbvw0tm/Z7+JfxY1DTEunOqaJHbRPCJPOXTY4Z9gzwuZZEy3baa480k1hZpb2/M3wMFPEw5trnM/Hz9lr4ifHzxT4e8S3mrtoHhlLZgLa+Y3F3AXdSwi+crIJGLMGJUKAAc8KPm8Bm9HLacqNryb36P19D6fNMseMrKcJaJWt/l6n1F+wP8AGXWJ9N8S/APxHpsBg+FqR2t9rovBJbqA5hhsnyqjzgYyWYHYdrbQRg19LgqEaFOVe9lJ3s/Pf5HzeNrOtXjSir2Vr+n6mL/wnfgX/oZdK/8AApf8a0+s0P50Y+yr9mZ/7FHxI174c+ALr9mfxJ8FJtZutJlmfV7jS9Ut91x9qG/bJDP5fzBCqEByfl7HNd1WhCtS9o3pLujzli1hsQsNZ8ytZrbyZ1/xY8Z3vw68JHxHo0F9pGt6Prdi9ppGt6cYRc6clwnmxrM+YGdovlGHOBkjJwR8jgsihHEOrOSlq7L/AD6n1WIzRuiopWVtSt8EPDsXwx/Z68B2t5oI03WPiHf3XivxPcuuJ7xg7zjz29cyW4AP3RketepnNVww8lFauyRx5bTjKtzS6as8U/4Qrxn/ANEt1L/wUy//ABNeP9Uq/wAn4Hd9Zh/N+JT+MX/J63xO/wCv+y/9I4q+xf8ABXzPkqn+9/JfqZXxg/5Ei8/6+LT/ANKI682O7PYw/wASMX4Gf8l+0n/sLn/0bDW8/wDl0Jf8vD9Xq7DiP//Z--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2Content-Transfer-Encoding: base64Content-Disposition: inline;filename=compose-unknown-contact.jpgContent-Type: image/jpeg;x-apple-mail-type=stationery;name="compose-unknown-contact.jpg"Content-Id: /9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQECAQEBAQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAARCAAZABkDAREAAhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUKBwAAAAAAAAACAQMEBQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAAAAAAAAAAAAADAAEEAv/EACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oADAMBAAIRAxEAPwDuEt+gW/ULet6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJVIl7eXLCaZIGwBl3TY8epPx2+jy2ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJEw/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx+a69/JSf9alIlste0VzaNpeFrcT9KKymotyiaZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mRUfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRDnu5azS8miKqjOTVkKqS/psG37fo1Fbabeg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GAcpOwBeN+U8/IkGbsiS8b7ryogmbzhbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH4hPOI0DkjZtaJtFxuVEbIUUiyeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJnYn9dnAQWl722p4ot37yzqnlfp6FrqbwawG8/9k=--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2----Apple-Mail=_F95FE6BC-E834-4F80-B352-F4C17EE0A7A2--.
Associated Messages, from the most recent to the oldest:
969--Apple-Mail=_F95FE6BC-E834-4F80-B352-F4C17EE0A7A2Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=windows-1252rightI see what you=92re doing here and what you want to do (sorry for not =reading original thread)Can you add[search =db=3Dcar_glob.txt&nematriculedatarq=3D[blank]][founditems]matricule=3D[mat=ricule]
[/founditems][/search]so we can see what=92s what?And also, I often found that something like this is helpful (to your =main query)=85[search db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]=20[founditems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boat_deep=3D[Tirant]=20[Replace =db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&Boat_=width=3D[bau]&Boat_deep=3D[Tirant][/Replace]=20[raw][[/raw]Replace =db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&Boat_=width=3D[bau]&Boat_deep=3D[Tirant][raw][[/raw]/Replace]
[/FoundItems]=20[/search]=20so you can see what webdna is really trying to do with your data=85> On 17 Jan 2017, at 17:33, Lawrence Banahan =wrote:>=20> I I use this>=20> [search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]> [replacefounditems][/replacefounditems]> [/search]> =20> I can't replace in an other db with different values each time, it is =ussually used when you are doing [math] on some values>=20>> Toby Cox17 janvier 2017 18:31>> sorry - misread>>=20>> you don=92t do a replace within search>>=20>> do this>>=20>> [search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]>> [replacefounditems][/replacefounditems]>> [/search]>>=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>> Lawrence Banahan17 janvier 2017 18:13>> Thanks toby, it doesn't change anything...>>=20>> The exemple is=20>> [Replace db=3DSomeDatabase.db&eqNAMEdata=3DGrant]name=3DJohn&address=3D=1492 Somewhere Lane&zip=3D90000&date=3D[date][/Replace]>>=20>>=20>> Toby Cox17 janvier 2017 18:04>> think>>=20>> =db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]boat_length=3D=[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][tirant][=/url][/replace]>>=20>> should be>>=20>> =db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]&boat_length=3D=[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][tirant][=/url]>>=20>> you=92re missing an ampersand before boat_length>>=20>>>=20>>> On 17 Jan 2017, at 16:54, Lawrence Banahan =wrote:>>>=20>>> Even more strange Kenneth...>>> With you code>>> http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna>>>=20>>>> Kenneth Grome17 janvier 2017 17:47>>>> Try this:>>>>=20>>>> [flushdatabases]>>>>=20>>>> [search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]>>>> [founditems]>>>>=20>>>> boat_length=3D[long]&boat_width=3D[bau]&boat_deep=3D[tirant]
>>>>=20>>>> [replace>>>> =db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]boat_length=3D=[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][tirant][=/url][/replace]>>>>=20>>>> [/founditems]>>>> [/search]>>>>=20>>>> [flushdatabases]>>>>=20>>>> Regards,>>>> Kenneth Grome>>>> WebDNA Solutions>>>> http://www.webdnasolutions.com>>>> Web Database Systems and Linux Server Administration>>>>=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>>>> Lawrence Banahan17 janvier 2017 17:24>>>> Hi,=20>>>>=20>>>> I have this simple search.=20>>>>=20>>>> [search db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]=20>>>> =[founditems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boat_deep=3D[Tirant]=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>>>>=20>>>>=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>>>>=20>>>> I have allowed in the preference : database extension as .db, .txt=20=>>>>=20>>>> If any one could open my eyes...=20>>>>=20>>>> Thanks=20>>>> Lawrence=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>>=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>> Lawrence Banahan17 janvier 2017 17:54>> Even more strange Kenneth...>> With you code>> http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna>>=20>> Kenneth Grome17 janvier 2017 17:47>> Try this:>>=20>> [flushdatabases]>>=20>> [search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]>> [founditems]>>=20>> boat_length=3D[long]&boat_width=3D[bau]&boat_deep=3D[tirant]
>>=20>> [replace>> =db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url]]boat_length=3D=[url][long][/url]&boat_width=3D[url][bau][/url]&boat_deep=3D[url][tirant][=/url][/replace]>>=20>> [/founditems]>> [/search]>>=20>> [flushdatabases]>>=20>> Regards,>> Kenneth Grome>> WebDNA Solutions>> http://www.webdnasolutions.com>> Web Database Systems and Linux Server Administration>>=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=_F95FE6BC-E834-4F80-B352-F4C17EE0A7A2Content-Type: multipart/related;type="text/html";boundary="Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2"--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=windows-1252right
I see what you=92re doing here and what =you want to do (sorry for not reading original thread)
Can you add
[search =db=3Dcar_glob.txt&nematriculedatarq=3D[blank]]
[founditems]matricule=3D=[matricule]<br />[/founditems][/search]
so we can see what=92s what?
And also, I often found =that something like this is helpful (to your main query)=85
[search =db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]
[founditems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boa=t_deep=3D[Tirant]<br>
[Replace =db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&a=mp;Boat_width=3D[bau]&Boat_deep=3D[Tirant][/Replace]
[raw][[/raw]Replace =db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&a=mp;Boat_width=3D[bau]&Boat_deep=3D[Tirant]
[raw][[/raw]/Replace]<br =/>
[/FoundItems]
[/search]
so you can see what =webdna is really trying to do with your data=85
On 17 Jan 2017, at =17:33, Lawrence Banahan <banahan.l@gmail.com> wrote:
I I use this
[search db=3Dtable_hn.txt&nematriculedatarq=3Dfindall]=
=[replacefounditems][/replacefounditems]
[/search]
I can't replace in an other db with =different values each time, it is ussually used when you are doing =[math] on some values
Toby =Cox=17 janvier 2017 18:31
sorry - misread
you don=92t 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=3D=John&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_length=3D[url][long][/url]&boat_width=3D[url][bau][/url]&bo=at_deep=3D[url][tirant][/url][/replace]
should be
db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url=]]&boat_length=3D[url][long][/url]&boat_width=3D[url][bau][/url]&a=mp;boat_deep=3D[url][tirant][/url]
you=92re =missing an ampersand before boat_length
On 17 Jan =2017, at 16:54, Lawrence Banahan =<banahan.l@gmail.com> wrote:
Even =more strange Kenneth...
With you code
http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna
Kenneth =Grome=17 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[ti=rant]<br>
[replace
db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url=]]boat_length=3D[url][long][/url]&boat_width=3D[url][bau][/url]&bo=at_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 <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
Lawrence =Banahan=17 janvier 2017 17:24
Hi,
I have this simple search.
[search db=3DTable_HN.txt&neMATRICULEdata=3Dfindall]&n=bsp;
[founditems]Boat_length=3D[LONG]&Boat_width=3D[bau]&Boa=t_deep=3D[Tirant]<br>
[Replace =db=3DCAR_GLOB.txt&eqMATRICULEdata=3D[MATRICULE]]Boat_length=3D[LONG]&a=mp;Boat_width=3D[bau]&Boat_deep=3D[Tirant][/Replace]
[/FoundItems]
[/search]
The search is going on well as =it is displaying in the html, but not replacinf in the DB
http://www.cnsr.fr/race2/_admin/dbfs/maj_osiris.dna
I have allowed in the preference : =database extension as .db, .txt
If= any one could open my eyes...
Thanks
Lawrence
--------------------------------------------------=------- 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
Kenneth =Grome=17 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[ti=rant]<br>
[replace
db=3Dcar_glob.txt&eqmatriculedatarq=3D[url][matricule][/url=]]boat_length=3D[url][long][/url]&boat_width=3D[url][bau][/url]&bo=at_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 <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 =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--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2Content-Transfer-Encoding: base64Content-Disposition: inline;filename=postbox-contact.jpgContent-Type: image/jpeg;x-apple-mail-type=stationery;name="postbox-contact.jpg"Content-Id: /9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAAZABkDAREAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD7w+G/gv4OeN/DGi3viDwl4O1/xVc6FpuqazJeafa3N+z3MAYTTllL/OVfaW4O0gcDAAOpn+C3wSt4Xnm+EHgoJGpZj/wj1qeB7CPJ+goA+Qv2fv2tv2Pvjj8d/Efwht/hR4S8MmC4SHwjf3OhW9pNqssZIlIbarQTb8GJOHwuch/lAB4f/wANYftDf9FU1b/viL/4igDc/wCCjPxD1f4YfAL9n/xB8O/FWpeF/Gmp6PBbNqGj3ElpeT6athAXheaIgtGJWiIRieTkDrQB8beIrz/gofqfh6S+8VTfHu40W0WPVJJb0aqbeJYSJUnJb5QE2hwx6YB7UAfqf+xF8I/hR8Wvhl8P/wBrTxj8ONBuPilq9vc3V/rkdtsNxdpM9ubkxZ8sTMsCsXVQd7OwwWNAH54/bD60Afovdfs+av8AF/W/2VfiIbPQ77w78NtHkfXrLUvmkMz6fDHEEiKFWeOeLJDFSrJ6igD6X+JOgX/iz4d+KfCultGt5rOi32n27SsVQSzQPGhYgEgZYZODxQB5z+yL8LNf/Z5/Zn8I/DL4gX+m/wBpeGLW7+33FrOWtVD3U02Q7hTgJIMkgdDQB+UH/CAfEX/oQPEn/gquP/iKAO9/ax/5OP8AH/8A2Fj/AOi0oA8moA3/AIf/API/eGP+w1Yf+lCUAfuDQB//2Q==--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2Content-Transfer-Encoding: base64Content-Disposition: inline;filename=postbox-contact.jpgContent-Type: image/jpeg;x-apple-mail-type=stationery;name="postbox-contact.jpg"Content-Id: /9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAAZABkDAREAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD45+H+uan4r13x/wDE7xnb6d4guNI8Kxahv1LSYLt7zWL1IIbcMXQs372ZmC5wAgAAUAA5lBXbsZ1E5OMV1Z9ZWUvgb4I/Cfwf8OP2zP8AhFbHQ9TuIfEtnpel+DLaZnuBlpYpVgKyKVDosjFRkPtDDBA4cJj6WYSmqas1pc7a+Dq4NQlJ3T6f5H2p+zn498GfFP4aaPP8Mvh9p1n4eUNFYyQ6dJYx2MEMihUZJEVkLIdyGMsuOh4oaqTThGV2mik6amp1ItJp+fQT/hbfi3/oMXH5D/Cuq0v6f/AMOWPc+MP+Cbvw0tm/Z7+JfxY1DTEunOqaJHbRPCJPOXTY4Z9gzwuZZEy3baa480k1hZpb2/M3wMFPEw5trnM/Hz9lr4ifHzxT4e8S3mrtoHhlLZgLa+Y3F3AXdSwi+crIJGLMGJUKAAc8KPm8Bm9HLacqNryb36P19D6fNMseMrKcJaJWt/l6n1F+wP8AGXWJ9N8S/APxHpsBg+FqR2t9rovBJbqA5hhsnyqjzgYyWYHYdrbQRg19LgqEaFOVe9lJ3s/Pf5HzeNrOtXjSir2Vr+n6mL/wnfgX/oZdK/8AApf8a0+s0P50Y+yr9mZ/7FHxI174c+ALr9mfxJ8FJtZutJlmfV7jS9Ut91x9qG/bJDP5fzBCqEByfl7HNd1WhCtS9o3pLujzli1hsQsNZ8ytZrbyZ1/xY8Z3vw68JHxHo0F9pGt6Prdi9ppGt6cYRc6clwnmxrM+YGdovlGHOBkjJwR8jgsihHEOrOSlq7L/AD6n1WIzRuiopWVtSt8EPDsXwx/Z68B2t5oI03WPiHf3XivxPcuuJ7xg7zjz29cyW4AP3RketepnNVww8lFauyRx5bTjKtzS6as8U/4Qrxn/ANEt1L/wUy//ABNeP9Uq/wAn4Hd9Zh/N+JT+MX/J63xO/wCv+y/9I4q+xf8ABXzPkqn+9/JfqZXxg/5Ei8/6+LT/ANKI682O7PYw/wASMX4Gf8l+0n/sLn/0bDW8/wDl0Jf8vD9Xq7DiP//Z--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2Content-Transfer-Encoding: base64Content-Disposition: inline;filename=compose-unknown-contact.jpgContent-Type: image/jpeg;x-apple-mail-type=stationery;name="compose-unknown-contact.jpg"Content-Id: /9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQECAQEBAQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAARCAAZABkDAREAAhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUKBwAAAAAAAAACAQMEBQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAAAAAAAAAAAAADAAEEAv/EACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oADAMBAAIRAxEAPwDuEt+gW/ULet6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJVIl7eXLCaZIGwBl3TY8epPx2+jy2ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJEw/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx+a69/JSf9alIlste0VzaNpeFrcT9KKymotyiaZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mRUfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRDnu5azS8miKqjOTVkKqS/psG37fo1Fbabeg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GAcpOwBeN+U8/IkGbsiS8b7ryogmbzhbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH4hPOI0DkjZtaJtFxuVEbIUUiyeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJnYn9dnAQWl722p4ot37yzqnlfp6FrqbwawG8/9k=--Apple-Mail=_1D94C6E9-5E64-4B55-90C5-7F275DDBE3A2----Apple-Mail=_F95FE6BC-E834-4F80-B352-F4C17EE0A7A2--.
Toby Cox
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:
[ot] g5 xserve drives (2004)
[WebDNA] Access to WDNA_OFS.db (2013)
WebCat and WebTV (1997)
wild question (1998)
Running _every_ page through WebCat-error.html (1997)
upgrading (1997)
Pithy questions on webcommerce & siteedit (1997)
Re:Emailer and encryption (1997)
Internet Explorer and caching (2000)
The word TYPE in search contexts and fields (1998)
autosensing lanague selection (1997)
Still trying to email... (1998)
creator code (1997)
[format 40s]text[/format] doesn't work (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
WebDNA Solutions ... sorry! (1997)
Webcat/Webmerchant part II (1998)
OT - royalty free images (2002)
database size? (1997)
Showing unopened cart (1997)