Re: [WebDNA] Searching for multiple value [search .... 1,2,3]
This WebDNA talk-list message is from
2015
It keeps the original formatting.
numero = 112513
interpreted = N
texte = 23 --Apple-Mail=_75ED02F2-8509-49D3-A359-53D6ED3CEC98 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Thanks Tom, that solved the issue. But when assigned the field name as a num value every thing went crazy. db_progressdatatype=3Dnum << made is go bunkers. /Palle > On 29/09/2015, at 16.31, Palle Bo Nielsen = wrote: >=20 > That might just be the solution, but do you think it will work on a = numeric value.=20 >=20 > wn word not equal - none of the words match text in the specified = field >=20 > It seem to be invented for words. >=20 > I will try it later when I am back in front of the screen :) >=20 > /Palle >=20 >=20 >> On 29/09/2015, at 16.09, Palle Bo Nielsen > wrote: >>=20 >> Like this? >>=20 >> [search = db=3D/databases/issuetracker.db&eqdb_categorydatarq=3D[index]&[!] >>=20 >> [/!]nedb_publishdatarq=3D3&[!] >> [/!]nedb_progressdatarq=3D8,9,10&[!] >> [/!]db_progresswbrk=3D,] >>=20 >>=20 >> Does to work either >>=20 >> /Palle >>=20 >>=20 >>=20 >>> On 29/09/2015, at 15.58, Tom Duke > wrote: >>>=20 >>> Palle, >>>=20 >>> Hi try including: >>>=20 >>> &nedb_progresswbrk=3D, >>>=20 >>> I don't think you can jus include a global 'wbrk' >>>=20 >>> - Tom >>>=20 >>>=20 >>>=20 >>>=20 >>> On 29 September 2015 at 14:23, Palle Bo Nielsen = > wrote: >>> Hi all >>>=20 >>> Help is appreciated >>>=20 >>>=20 >>> ### code start ### >>>=20 >>> [search = db=3D/databases/issuetracker.db&eqdb_categorydatarq=3D[index]&wbrk=3D,&[!]= >>>=20 >>> [/!]nedb_publishdatarq=3D3&[!] >>> [/!]nedb_progressdatarq=3D8,9,10] >>>=20 >>>=20 >>> ### code end ### >>>=20 >>> Why am I not able to =E2=80=9Cnot include any results containing the = numbers 8, 9 and 10 from the Field db_progress=E2=80=9D ?? >>>=20 >>> So I thought that wbrk (assigning comma as the separator) would do = the trick >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> Digital Revolutionaries >>> 1st Floor, Castleriver House >>> 14-15 Parliament Street >>> Temple Bar,Dublin 2 >>> Ireland >>> ---------------------------------------------- >>> [t]: + 353 1 4403907 >>> [e]: > >>> [w]: > >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> --------------------------------------------------------- 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 > --------------------------------------------------------- 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=_75ED02F2-8509-49D3-A359-53D6ED3CEC98 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
Thanks Tom, that solved the issue.
But when assigned the = field name as a num value every thing went crazy.
db_progressdatatype=3Dnum << = made is go bunkers.
Why am I not able to =E2=80=9Cnot include any results = containing the numbers 8, 9 and 10 from the Field db_progress=E2=80=9D = ??
So I thought that wbrk (assigning comma = as the separator) would do the trick
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D Digital Revolutionaries 1st Floor, = Castleriver House 14-15 Parliament Street Temple Bar,Dublin 2 Ireland ---------------------------------------------- [t]: + 353 1 4403907 [e]: <mailto:tom@revolutionaries.ie> [w]: <http://www.revolutionaries.ie/> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
--------------------------------------------------------- = 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.usBug 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 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=_75ED02F2-8509-49D3-A359-53D6ED3CEC98-- .
Associated Messages, from the most recent to the oldest:
23 --Apple-Mail=_75ED02F2-8509-49D3-A359-53D6ED3CEC98 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Thanks Tom, that solved the issue. But when assigned the field name as a num value every thing went crazy. db_progressdatatype=3Dnum << made is go bunkers. /Palle > On 29/09/2015, at 16.31, Palle Bo Nielsen = wrote: >=20 > That might just be the solution, but do you think it will work on a = numeric value.=20 >=20 > wn word not equal - none of the words match text in the specified = field >=20 > It seem to be invented for words. >=20 > I will try it later when I am back in front of the screen :) >=20 > /Palle >=20 >=20 >> On 29/09/2015, at 16.09, Palle Bo Nielsen > wrote: >>=20 >> Like this? >>=20 >> [search = db=3D/databases/issuetracker.db&eqdb_categorydatarq=3D[index]&[!] >>=20 >> [/!]nedb_publishdatarq=3D3&[!] >> [/!]nedb_progressdatarq=3D8,9,10&[!] >> [/!]db_progresswbrk=3D,] >>=20 >>=20 >> Does to work either >>=20 >> /Palle >>=20 >>=20 >>=20 >>> On 29/09/2015, at 15.58, Tom Duke > wrote: >>>=20 >>> Palle, >>>=20 >>> Hi try including: >>>=20 >>> &nedb_progresswbrk=3D, >>>=20 >>> I don't think you can jus include a global 'wbrk' >>>=20 >>> - Tom >>>=20 >>>=20 >>>=20 >>>=20 >>> On 29 September 2015 at 14:23, Palle Bo Nielsen = > wrote: >>> Hi all >>>=20 >>> Help is appreciated >>>=20 >>>=20 >>> ### code start ### >>>=20 >>> [search = db=3D/databases/issuetracker.db&eqdb_categorydatarq=3D[index]&wbrk=3D,&[!]= >>>=20 >>> [/!]nedb_publishdatarq=3D3&[!] >>> [/!]nedb_progressdatarq=3D8,9,10] >>>=20 >>>=20 >>> ### code end ### >>>=20 >>> Why am I not able to =E2=80=9Cnot include any results containing the = numbers 8, 9 and 10 from the Field db_progress=E2=80=9D ?? >>>=20 >>> So I thought that wbrk (assigning comma as the separator) would do = the trick >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> Digital Revolutionaries >>> 1st Floor, Castleriver House >>> 14-15 Parliament Street >>> Temple Bar,Dublin 2 >>> Ireland >>> ---------------------------------------------- >>> [t]: + 353 1 4403907 >>> [e]: > >>> [w]: > >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> --------------------------------------------------------- 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 > --------------------------------------------------------- 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=_75ED02F2-8509-49D3-A359-53D6ED3CEC98 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
Thanks Tom, that solved the issue.
But when assigned the = field name as a num value every thing went crazy.
db_progressdatatype=3Dnum << = made is go bunkers.
Why am I not able to =E2=80=9Cnot include any results = containing the numbers 8, 9 and 10 from the Field db_progress=E2=80=9D = ??
So I thought that wbrk (assigning comma = as the separator) would do the trick
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D Digital Revolutionaries 1st Floor, = Castleriver House 14-15 Parliament Street Temple Bar,Dublin 2 Ireland ---------------------------------------------- [t]: + 353 1 4403907 [e]: <mailto:tom@revolutionaries.ie> [w]: <http://www.revolutionaries.ie/> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
--------------------------------------------------------- = 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.usBug 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 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=_75ED02F2-8509-49D3-A359-53D6ED3CEC98-- .
Palle Bo Nielsen
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...