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 = 2122 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 So, looking for values greater than 1552493728968 will find everything = that has 14 or more digits, because they are numerically greater Try 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 >
[db3_topic_text] = ([db3_thread_read])
> =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 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 . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Searching using variable or numeric number (Hetzner Powerpalle 2019)
  2. Re: [WebDNA] Searching using variable or numeric number (Brian Fries 2019)
  3. Re: [WebDNA] Searching using variable or numeric number (Hetzner Powerpalle 2019)
  4. Re: [WebDNA] Searching using variable or numeric number (WebDNA Solutions 2019)
  5. Re: [WebDNA] Searching using variable or numeric number (Hetzner Powerpalle 2019)
  6. Re: [WebDNA] Searching using variable or numeric number (Brian Fries 2019)
  7. [WebDNA] Searching using variable or numeric number (Hetzner Powerpalle 2019)
2122 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 So, looking for values greater than 1552493728968 will find everything = that has 14 or more digits, because they are numerically greater Try 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 >
[db3_topic_text] = ([db3_thread_read])
> =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 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 . 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:

List of WebDNA users (2002) Hiding HTML and page breaks (1997) Protect (1997) Payments -> Bank Accounts (2005) Show if time tags (1997) PCS Frames (1997) Associative lookup style? + bit more (1997) OT- AS/400 and Macs (2003) Formulas.db (2003) Re:no template caching (1997) more on my bbs (1997) Multiple prices (1997) AddLineItem Problem (1997) creating a ShipCosts database (1997) Not really WebCat (1997) SUMM=T does not summarize by the sort parameters ... (2003) taxTotal, grandTotal (1997) Multiple catalog databases and showcart (1997) Email within tmpl ? (1997) Navigator 4.01 (1997)