What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.

WebDNA

Software Corporation

Search WebDNA Site

HOME

DOWNLOADS

LEARN

EDUCATION

NEWS

COMMUNITY

STORE

SUPPORT

CONTACT

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>>>

>> padding-top: 10px;">>> task=3Dthread&query=3D[db3_sku]">[db3_topic_text]>>> ([db3_thread_read])

[/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:

Re: [WebDNA] Searching using variable or numeric number (Hetzner Powerpalle 2019)
Re: [WebDNA] Searching using variable or numeric number (Brian Fries 2019)
Re: [WebDNA] Searching using variable or numeric number (Hetzner Powerpalle 2019)
Re: [WebDNA] Searching using variable or numeric number (WebDNA Solutions 2019)
Re: [WebDNA] Searching using variable or numeric number (Hetzner Powerpalle 2019)
Re: [WebDNA] Searching using variable or numeric number (Brian Fries 2019)
[WebDNA] Searching using variable or numeric number (Hetzner Powerpalle 2019)

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>>>

>> padding-top: 10px;">>> task=3Dthread&query=3D[db3_sku]">[db3_topic_text]>>> ([db3_thread_read])

DOWNLOAD WEBDNA NOW!

Re: [WebDNA] Searching using variable or numeric number

2019

Top Articles:

Related Readings: