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:

Silly Question (1997) OrderFile (2000) Webstar 1.3.1 PPC (1997) help with grep (2008) Cookies and webcat (1997) Removing [showif] makes a big difference in speed (1997) RE: New WebCatalog Version !!! (1997) What am I missing (1997) Using Applescript to process WebCatalog functions (1998) [WebDNA] TCP HTTP/1.1 questions (2011) log out (2001) [WebDNA] EMailer timezone bug? (2015) Max Record length restated as maybe bug (1997) Need relative path explanation (1997) Bad cookie (1998) New Web Site Developers Database (1996) Trouble with Netscape (1998) [WebDNA] PDF creation (2013) Fulfillment emails not emailing after upgrade (2002) WebCat2b15MacPlugin - showing [math] (1997)