Re: [WebDNA] Searching using variable or numeric number
This WebDNA talk-list message is from 2019
It keeps the original formatting.
numero = 114505
interpreted = N
texte = 2124It's because [cart] creates a string of characters, not a number.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comUrgent/Emergency Phone: (228) 222-2917Web Database Systems and Linux Server Administration>Hi Brian>>I found the solution as described in my previous mail =E2=80=A6 but than=ks 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 calcul=ating>> 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_indexty=pe=3Dnum&AllReqd=3DT&max=3D5&dedb3_thread_readsort=3D1&db3_thread_readtyp=e=3Dnum]=20>>> [founditems]>>>=20>>> [/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 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:
2124It's because [cart] creates a string of characters, not a number.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comUrgent/Emergency Phone: (228) 222-2917Web Database Systems and Linux Server Administration>Hi Brian>>I found the solution as described in my previous mail =E2=80=A6 but than=ks 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 calcul=ating>> 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_indexty=pe=3Dnum&AllReqd=3DT&max=3D5&dedb3_thread_readsort=3D1&db3_thread_readtyp=e=3Dnum]=20>>> [founditems]>>>=20>>> [/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 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.
WebDNA Solutions
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:
Spaces inside [AppendFile] (1998)
Any Newsletters out there (1998)
Graphing Modules (2004)
Grant, please help me ... (1997)
POST (1997)
Limit picture size on upload (2005)
Rhapsody? (1997)
formatting dates from a field ... (1997)
converting characters in form (1997)
Re(2): grep matching (2003)
Text limits in NT version? (1997)
Running _every_ page through WebCat-error.html (1997)
cr/cr/lf under WebSite ($WebCat.exe) confirmed (2000)
displaying New products (using [date]) (1997)
WebDNA Threaded Discussions? (2004)
Associative lookup style? + bit more (1997)
Webcatalog/NT dbserver crashing. (2000)
Blog Software (2006)
WebCatalog/Mac 2.1b2 New Features (1997)
Can't access [OrderFile] OSXS WC4 (2000)