Re: [WebDNA] Searching using variable or numeric number
This WebDNA talk-list message is from 2019
It keeps the original formatting.
numero = 114504
interpreted = N
texte = 2123Hi BrianI found the solution as described in my previous mail =E2=80=A6 but =thanks for your input.What I do not undestand is your recommendation to remove the type=3Dnum. =It is my understanding that trying to do a calculation or comparison of =two numbers (in this case something which is numerically greater), it is =best to define the variables as numbers hense, type=3Dnum. Is it because =defining type=3Dnum is only working with a value for 13 characters =and/or less?/Palle> On 14 Mar 2019, at 00.31, Brian Fries
wrote:>=20> 1 - you=E2=80=99ve truncated the cart value to 13 characters in =calculating scope_threshold> 2 - you=E2=80=99re doing a type=3Dnum comparison, when the value in =your database may have more than 13 characters>=20> So, looking for values greater than 1552493728968 will find everything =that has 14 or more digits, because they are numerically greater>=20> Try without the type=3Dnum parameter in your search.>=20> - Brian F>=20>> 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>=20> ---------------------------------------------------------> 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:
2123Hi BrianI found the solution as described in my previous mail =E2=80=A6 but =thanks for your input.What I do not undestand is your recommendation to remove the type=3Dnum. =It is my understanding that trying to do a calculation or comparison of =two numbers (in this case something which is numerically greater), it is =best to define the variables as numbers hense, type=3Dnum. Is it because =defining type=3Dnum is only working with a value for 13 characters =and/or less?/Palle> On 14 Mar 2019, at 00.31, Brian Fries wrote:>=20> 1 - you=E2=80=99ve truncated the cart value to 13 characters in =calculating scope_threshold> 2 - you=E2=80=99re doing a type=3Dnum comparison, when the value in =your database may have more than 13 characters>=20> So, looking for values greater than 1552493728968 will find everything =that has 14 or more digits, because they are numerically greater>=20> Try without the type=3Dnum parameter in your search.>=20> - Brian F>=20>> 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>=20> ---------------------------------------------------------> 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.
Hetzner Powerpalle
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:
NewCart+Search with one click ? (1997)
[OT] Looking for WC web dev help (2003)
XML version of WebDNA docs? (2000)
WebCat 4.51 on Fedora Core 1 (2004)
Date problems-more (1997)
b12 cannot limit records returned and more. (1997)
[format xs] freeze (1997)
[ELSEIF] was hideif [x]=1,2,3..: (2003)
RE: Languages (1997)
Special characters in field names (1998)
[movefile] (1999)
show all problem (1997)
[OT] Wanted - Mail Server - MacOS9.x (2001)
Cart Numbers (1997)
Help w/Multi User Admins (1997)
webcat- multiple selection in input field (1997)
Virtual hosting and webcatNT (1997)
Webcat/Webmerchant part II (1998)
Extended [ConvertChars] (1997)
[Sum] function? (1997)