Re: [WebDNA] Searching using variable or numeric number
This WebDNA talk-list message is from 2019
It keeps the original formatting.
numero = 114503
interpreted = N
texte = 21221 - you=E2=80=99ve truncated the cart value to 13 characters in =calculating scope_threshold2 - you=E2=80=99re doing a type=3Dnum comparison, when the value in your =database may have more than 13 charactersSo, looking for values greater than 1552493728968 will find everything =that has 14 or more digits, because they are numerically greaterTry without the type=3Dnum parameter in your search.- Brian F> On Mar 13, 2019, at 9:42 AM, Hetzner Powerpalle =
wrote:>=20> Why does this NOT provide me with a result, when using>=20> gedb3_indexdata=3D[scope_threshold]>=20> While it gives me a result when this works, just using a plain number =(same value as in the variable)>=20> gedb3_indexdata=3D1552493728968>=20> Purpose is to find all matching records which are newer (has a higher =number/value) than [scope_threshold]>=20> =E2=80=94=E2=80=94 taken from this code =E2=80=94=E2=80=94>=20> [text show=3Dt]scope_days=3D14[/text]> [text show=3Dt]scope_sum=3D[math]86400*[scope_days][/math][/text]> [text show=3Dt]scope_threshold=3D[math][format =13s][cart][/format]-[scope_sum][/math][/text]>=20> =09> [search =db=3D/forum/db/db3.db&gedb3_indexdata=3D[scope_threshold]&db3_indextype=3D=num&AllReqd=3DT&max=3D5&dedb3_thread_readsort=3D1&db3_thread_readtype=3Dnu=m]> =09> [founditems]>=20> > =09> [/founditems]> [/search]>=20> =E2=80=94=E2=80=94 SNIP =E2=80=94=E2=80=94>=20> /Palle---------------------------------------------------------> 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://www.webdna.us/page.dna?numero=3D55> Bug Reporting: support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
21221 - you=E2=80=99ve truncated the cart value to 13 characters in =calculating scope_threshold2 - you=E2=80=99re doing a type=3Dnum comparison, when the value in your =database may have more than 13 charactersSo, looking for values greater than 1552493728968 will find everything =that has 14 or more digits, because they are numerically greaterTry without the type=3Dnum parameter in your search.- Brian F> On Mar 13, 2019, at 9:42 AM, Hetzner Powerpalle = wrote:>=20> Why does this NOT provide me with a result, when using>=20> gedb3_indexdata=3D[scope_threshold]>=20> While it gives me a result when this works, just using a plain number =(same value as in the variable)>=20> gedb3_indexdata=3D1552493728968>=20> Purpose is to find all matching records which are newer (has a higher =number/value) than [scope_threshold]>=20> =E2=80=94=E2=80=94 taken from this code =E2=80=94=E2=80=94>=20> [text show=3Dt]scope_days=3D14[/text]> [text show=3Dt]scope_sum=3D[math]86400*[scope_days][/math][/text]> [text show=3Dt]scope_threshold=3D[math][format =13s][cart][/format]-[scope_sum][/math][/text]>=20> =09> [search =db=3D/forum/db/db3.db&gedb3_indexdata=3D[scope_threshold]&db3_indextype=3D=num&AllReqd=3DT&max=3D5&dedb3_thread_readsort=3D1&db3_thread_readtype=3Dnu=m]> =09> [founditems]>=20> > =09> [/founditems]> [/search]>=20> =E2=80=94=E2=80=94 SNIP =E2=80=94=E2=80=94>=20> /Palle---------------------------------------------------------> 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://www.webdna.us/page.dna?numero=3D55> Bug Reporting: support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
Brian Fries
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:
Server crash (1997)
calculate age (2003)
Is this google friendly? (2003)
[WebDNA] Why the difference? (2012)
Problems with [Applescript] (1997)
Still Pulling my hair out (2001)
WebCat2b15MacPlugin - [protect] (1997)
[createfolder] & [deletefolder] (1997)
[sendmail] sending twice... (Update) (2003)
DreamWeaver (2002)
Hosts who have upgraded to v5.0? (2003)
Separate SSL Server (1997)
How To question on setting up downloads (1997)
Doing VALIDCARD right? (1998)
Search in 2 or more catalogs (1997)
back button loses cart (2000)
No more misunderstanding ... yay! :) (1997)
can WC render sites out? (1997)
[isfile] ? (1997)
Add more fields to an existent data base (1997)