Re: [WebDNA] random blank results? how come?

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111595
interpreted = N
texte = --089e0158b0d8467f330503580ff0 Content-Type: text/plain; charset=UTF-8 I will follow through what Matt is suggesting. I remembered to even used [countchars] to no avail.. At least, this rules out issues from WedDNA Developer Limitation (& increasing the # of results), something related to WaitFile, too much active db's, tabbed or comma formatted db's, even RAM. On Thu, Sep 18, 2014 at 9:26 PM, Psi Prime Inc, Matthew A Perosi < matt@psiprime.com> wrote: > Somewhere in the talk list archives is a long discussion I posted about > my experiences with blank fields and fields with the number zero (0) in > them. > > If I'm remembering correctly, you'll have strange results when searching > for blank records unless you search for [blank], > as in neK2datarq=[blank] > > Normally if I want to search for something that's "not equal" I will use > this old trick from the WebDNA docks: > neK2datarq=find_all > Naturally you won't have a character string "find_all" in your db, but > this is a sanity check to quickly explain what you are doing. > > But again, it looks like you want to compare for a zero, not characters. > What I've found is that zero always seems to be a zero, and not a > character. You can't compare for it unless you designate to specifically > do the query with the type, as in: > &neK2data=0&K2type=num&SEQsort=1 > > Give that a try. > > > -Matt > > > > > On 9/18/2014 8:43 AM, sgbc cebu wrote: > > I used to plot my datas in excel, and it always works fine with webDna > (snapshot).. > > > I purported the zeroes into blank cells for this test, and have the data > grid reduced from 1467 x 44 cells to 18 x 44 cells. Also, code below was > isolated to make sure no conflicts will happen. > > > [text]MyGrade=22176[/text] > > > > > > > > > > > > [search db=data/classsubjects.db&neK2Data=0&SeqSort=1] > [founditems] > [search db=data/grades.db&eqPupilDatarq=[MyGrade][!] > [/!]&eqSubCodeDatarq=[k2]&allBLNK=T] > [founditems] >  >  >  >  >  > [/founditems] > [/search] > [/founditems] > [/search]
SubjectQ1Q2Q3Q4FG
[search db=data/subjects.db&eqCodeData=[k2]] > [founditems][subject][/founditems][/search] > [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
> > > The code above produced this html below: > > Subject Q1 Q2 Q3 Q4 FG Phonetics Mathematics 0 0 0 0 0 Environmental > Science Filipino Penmanship Music-Eurytmics Visual Arts General > Average 0 0 0 0 0 > > With borders revealed, note that actually some from the > [founditems]...[/founditems] has been dropped. > > This is the result that we intend to be: > > Subject Q1 Q2 Q3 Q4 FG Phonetics 0 0 0 0 0 Mathematics 0 0 0 0 0 Environmental > Science 0 0 0 0 0 Filipino 0 0 0 0 0 Penmanship 0 0 0 0 0 > Music-Eurytmics 0 0 0 0 0 Visual Arts 0 0 0 0 0 General Average 0 0 0 0 > 0 > > Thanks, > > Jess V. > > On Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain > wrote: > >> try adding rq to your queries. >> >> ie: &neK2Datarq=0 >> >> >> Regards >> >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >> >> >> >> >> On 18 Sep 2014, at 12:37 am, sgbc cebu wrote: >> >> I'm wondering whats going on for this search. >> >> I even reduce the database, and filled blank fields with "0" (zero) to >> ensure that there's a character within. >> >> But still the result is the same. >> >> The resulting search will display blank areas. In this case even >> dropping the 's that'd represent a cell. >> >> To illustrate, heres the code: >> >> [text]MyGrade=22176[/text] >> >> >> >> >> >> >> >> >> >> >> [search db=data/classsubjects.db&neK2Data=0&SeqSort=1] >> [founditems] >> [search >> db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T] >> [founditems] >> >> >> >> >> >> [/founditems] >> [/search] >> [/founditems] >> [/search]
SubjectQ1Q2Q3Q4FG
[search >> db=data/subjects.db&eqCodeData=[k2]][founditems][subject][/founditems][/search] >> [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
>> >> >> Instead of: >> >> Subject Q1 Q2 Q3 Q4 FG >> Phonetics 0 0 0 0 0 >> Mathematics 0 0 0 0 0 >> Environmental Science 0 0 0 0 0 >> Filipino 0 0 0 0 0 >> Penmanship 0 0 0 0 0 >> Music-Eurytmics 0 0 0 0 0 >> Visual Arts 0 0 0 0 0 >> General Average 0 0 0 0 0 >> >> >> I get this >> >> >> Subject Q1 Q2 Q3 Q4 FG >> Phonetics >> Mathematics 0 0 0 0 0 >> Environmental Science >> Filipino >> Penmanship >> Music-Eurytmics >> Visual Arts >> General Average 0 0 0 0 0 >> >> >> Any help is appreciated. >> >> Jess V. >> >> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the mailing list . To >> unsubscribe, E-mail to: archives: >> http://mail.webdna.us/list/talk@webdna.us Bug Reporting: >> support@webdna.us >> >> >> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the mailing list . To >> unsubscribe, E-mail to: archives: >> http://mail.webdna.us/list/talk@webdna.us Bug Reporting: >> support@webdna.us >> > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us > > > > -- > Matthew A Perosi > Corporate Consultant > Mobile Marketing Expert > Senior Web Developer > SEO Analyst & Educatormatt@psiprime.com > > 323 Union Blvd. > Totowa, NJ 07512 > > Direct: 888.872.0274 > Fax: 888.488.5924 > http://www.perosi.com > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us > --089e0158b0d8467f330503580ff0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I will follow through what Matt is suggesting.=C2=A0 = I remembered to even used [countchars] to no avail..

At least,= this rules out issues from WedDNA Developer Limitation (& increasing t= he # of results), something related to WaitFile, too much active db's, = tabbed or comma formatted db's, even RAM.

On Thu, Sep 18, 2014 at 9:26 PM, Psi = Prime Inc, Matthew A Perosi <matt@psiprime.com> wrote:
=20 =20 =20
Somewhere in the talk list archives is a long discussion I posted about my experiences with blank fields and fields with the number zero (0) in them.

If I'm remembering correctly, you'll have strange results whe= n searching for blank records unless you search for [blank],
as in neK2datarq=3D[blank]

Normally if I want to search for something that's "not equal= " I will use this old trick from the WebDNA docks:
neK2datarq=3Dfind_all
Naturally you won't have a character string "find_all" = in your db, but this is a sanity check to quickly explain what you are doing.

But again, it looks like you want to compare for a zero, not characters.=C2=A0 What I've found is that zero always seems to be= a zero, and not a character.=C2=A0 You can't compare for it unless = you designate to specifically do the query with the type, as in:
&neK2data=3D0&K2type=3Dnum&SEQsort=3D1

Give that a try.


-Matt




On 9/18/2014 8:43 AM, sgbc cebu wrote:
I used to plot my datas in excel, a= nd it always works fine with webDna (snapshot)..


I purported the zeroes into blank cells for this test, and have the data grid reduced from 1467 x 44 cells to 18 x 44 cells. Also, code below was isolated to make sure no conflicts will happen. 

    [t=ext]MyGrade=3D22176[/text]<table border=3D1><tr><td>Subject</td><td>Q1</td><td>Q2</td><td>Q3</td><td>Q4</td><td>FG</td></tr>[search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1][founditems]<tr><td>[search db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems][/search]</td>[search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade][!][/!]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT][founditems]<td>[K2Q1]</td><td>[K2Q2]</td><td>[K2Q3]</td><td>[K2Q4]</td><td>[K2FG]</td>[/founditems][/search]</tr>[/founditems][/search]</table>

The code above produced this html below:

SubjectQ1Q2Q3Q4FG
Phonetics
Mathematics 00000
Environmental Science
Filipino
Penmanship
Music-Eurytmics
Visual Arts
General Average 00000

With borders revealed, note that actually some <td></td> from the [founditems]...[/founditems] has been dropped.

This is the result that we intend to be:

SubjectQ1Q2Q3Q4FG
Phonetics00000
Mathematics00000
Environmental Science00000
Filipino00000
Penmanship00000
Music-Eurytmics00000
Visual Arts00000
General Average00000

Thanks,

Jess V.


On Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain <webdna@idfk.com.au> wrote:
try adding rq to your queries.

ie: =C2=A0&neK2Datarq=3D0


Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA




On 18 Sep 2014, at 12:37 am, sgbc cebu <sgbccebu@gmail.com= > wrote:

I'm wondering whats going on for this search.

I even reduce the database, and filled blank fields with "0" (zero) to ens= ure that there's a character within.

But still the result is the same.

The resulting search will display blank areas.=C2=A0 In this case even dropping the <td>'s that'd represent a cell.=

To illustrate, heres the code:

[text]MyGrade=3D22176[/text]

<table border=3D0>
<tr>
<td>Subject</td>
<td>Q1</td>
<td>Q2</td>
<td>Q3</td>
<td>Q4</td>
<td>FG</td>
</tr>
[search db=3Ddata/classsubjects.db&neK2Data=3D0&a= mp;SeqSort=3D1]
[founditems]
<tr><td>[search db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/foundite= ms][/search]
</td>[search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2= ]&allBLNK=3DT]
=C2=A0=C2=A0=C2=A0 [founditems]
=C2=A0=C2=A0=C2=A0 <td>[K2Q1]</td>= ;
=C2=A0=C2=A0=C2=A0 <td>[K2Q2]</td>= ;
=C2=A0=C2=A0=C2=A0 <td>[K2Q3]</td>= ;
=C2=A0=C2=A0=C2=A0 <td>[K2Q4]</td>= ;
=C2=A0=C2=A0=C2=A0 <td>[K2FG]</td>= ;
=C2=A0=C2=A0=C2=A0 [/founditems]
=C2=A0=C2=A0=C2=A0 [/search]
</tr>[/founditems]
[/search]</table>


Instead of:

Subject =C2=A0=C2=A0=C2=A0 Q1 =C2=A0= =C2=A0=C2=A0 Q2 =C2=A0=C2=A0=C2=A0 Q3 =C2=A0=C2=A0=C2=A0 = Q4 =C2=A0=C2=A0=C2=A0 FG
Phonetics=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=
Mathematics =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0
Environmental Science=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0= =C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=
Filipino=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=
Penmanship=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=
Music-Eurytmics=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0
Visual Arts=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0
General Average =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0


I get this


Subject =C2=A0=C2=A0=C2=A0 Q1 =C2=A0= =C2=A0=C2=A0 Q2 =C2=A0=C2=A0=C2=A0 Q3 =C2=A0=C2=A0=C2=A0 = Q4 =C2=A0=C2=A0=C2=A0 FG
Phonetics=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
Mathematics =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0
Environmental Science=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2= =A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
Filipino=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2= =A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
Penmanship=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
Music-Eurytmics=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2= =A0=C2=A0=C2=A0
Visual Arts=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
General Average =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0
=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0= =C2=A0 =C2=A0=C2=A0=C2=A0

Any help is appreciated.

Jess V.

---------------------------------------------------= ------ This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdn= a.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/lis= t/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us 


--=20Matthew A PerosiCorporate ConsultantMobile Marketing ExpertSenior Web DeveloperSEO Analyst & Educatormatt@psiprime.com323 Union Blvd.Totowa, NJ 07512Direct:  888.872.0274Fax:     888.488.5924http://www.perosi.com
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: suppo= rt@webdna.us

--089e0158b0d8467f330503580ff0-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  2. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  3. Re: [WebDNA] random blank results? how come? ("Psi Prime Inc, Matthew A Perosi " 2014)
  4. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  5. Re: [WebDNA] random blank results? how come? (Kenneth Grome 2014)
  6. Re: [WebDNA] random blank results? how come? (Toby Cox 2014)
  7. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  8. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  9. Re: [WebDNA] random blank results? how come? (Stuart Tremain 2014)
  10. Re: [WebDNA] random blank results? how come? (Toby Cox 2014)
  11. [WebDNA] random blank results? how come? (sgbc cebu 2014)
--089e0158b0d8467f330503580ff0 Content-Type: text/plain; charset=UTF-8 I will follow through what Matt is suggesting. I remembered to even used [countchars] to no avail.. At least, this rules out issues from WedDNA Developer Limitation (& increasing the # of results), something related to WaitFile, too much active db's, tabbed or comma formatted db's, even RAM. On Thu, Sep 18, 2014 at 9:26 PM, Psi Prime Inc, Matthew A Perosi < matt@psiprime.com> wrote: > Somewhere in the Talk List archives is a long discussion I posted about > my experiences with blank fields and fields with the number zero (0) in > them. > > If I'm remembering correctly, you'll have strange results when searching > for blank records unless you search for [blank], > as in neK2datarq=[blank] > > Normally if I want to search for something that's "not equal" I will use > this old trick from the WebDNA docks: > neK2datarq=find_all > Naturally you won't have a character string "find_all" in your db, but > this is a sanity check to quickly explain what you are doing. > > But again, it looks like you want to compare for a zero, not characters. > What I've found is that zero always seems to be a zero, and not a > character. You can't compare for it unless you designate to specifically > do the query with the type, as in: > &neK2data=0&K2type=num&SEQsort=1 > > Give that a try. > > > -Matt > > > > > On 9/18/2014 8:43 AM, sgbc cebu wrote: > > I used to plot my datas in excel, and it always works fine with webDna > (snapshot).. > > > I purported the zeroes into blank cells for this test, and have the data > grid reduced from 1467 x 44 cells to 18 x 44 cells. Also, code below was > isolated to make sure no conflicts will happen. > > > [text]MyGrade=22176[/text] > > > > > > > > > > > > [search db=data/classsubjects.db&neK2Data=0&SeqSort=1] > [founditems] > [search db=data/grades.db&eqPupilDatarq=[MyGrade][!] > [/!]&eqSubCodeDatarq=[k2]&allBLNK=T] > [founditems] >  >  >  >  >  > [/founditems] > [/search] > [/founditems] > [/search]
SubjectQ1Q2Q3Q4FG
[search db=data/subjects.db&eqCodeData=[k2]] > [founditems][subject][/founditems][/search] > [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
> > > The code above produced this html below: > > Subject Q1 Q2 Q3 Q4 FG Phonetics Mathematics 0 0 0 0 0 Environmental > Science Filipino Penmanship Music-Eurytmics Visual Arts General > Average 0 0 0 0 0 > > With borders revealed, note that actually some from the > [founditems]...[/founditems] has been dropped. > > This is the result that we intend to be: > > Subject Q1 Q2 Q3 Q4 FG Phonetics 0 0 0 0 0 Mathematics 0 0 0 0 0 Environmental > Science 0 0 0 0 0 Filipino 0 0 0 0 0 Penmanship 0 0 0 0 0 > Music-Eurytmics 0 0 0 0 0 Visual Arts 0 0 0 0 0 General Average 0 0 0 0 > 0 > > Thanks, > > Jess V. > > On Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain > wrote: > >> try adding rq to your queries. >> >> ie: &neK2Datarq=0 >> >> >> Regards >> >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >> >> >> >> >> On 18 Sep 2014, at 12:37 am, sgbc cebu wrote: >> >> I'm wondering whats going on for this search. >> >> I even reduce the database, and filled blank fields with "0" (zero) to >> ensure that there's a character within. >> >> But still the result is the same. >> >> The resulting search will display blank areas. In this case even >> dropping the 's that'd represent a cell. >> >> To illustrate, heres the code: >> >> [text]MyGrade=22176[/text] >> >> >> >> >> >> >> >> >> >> >> [search db=data/classsubjects.db&neK2Data=0&SeqSort=1] >> [founditems] >> [search >> db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T] >> [founditems] >> >> >> >> >> >> [/founditems] >> [/search] >> [/founditems] >> [/search]
SubjectQ1Q2Q3Q4FG
[search >> db=data/subjects.db&eqCodeData=[k2]][founditems][subject][/founditems][/search] >> [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
>> >> >> Instead of: >> >> Subject Q1 Q2 Q3 Q4 FG >> Phonetics 0 0 0 0 0 >> Mathematics 0 0 0 0 0 >> Environmental Science 0 0 0 0 0 >> Filipino 0 0 0 0 0 >> Penmanship 0 0 0 0 0 >> Music-Eurytmics 0 0 0 0 0 >> Visual Arts 0 0 0 0 0 >> General Average 0 0 0 0 0 >> >> >> I get this >> >> >> Subject Q1 Q2 Q3 Q4 FG >> Phonetics >> Mathematics 0 0 0 0 0 >> Environmental Science >> Filipino >> Penmanship >> Music-Eurytmics >> Visual Arts >> General Average 0 0 0 0 0 >> >> >> Any help is appreciated. >> >> Jess V. >> >> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the mailing list . To >> unsubscribe, E-mail to: archives: >> http://mail.webdna.us/list/talk@webdna.us Bug Reporting: >> support@webdna.us >> >> >> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the mailing list . To >> unsubscribe, E-mail to: archives: >> http://mail.webdna.us/list/talk@webdna.us Bug Reporting: >> support@webdna.us >> > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us > > > > -- > Matthew A Perosi > Corporate Consultant > Mobile Marketing Expert > Senior Web Developer > SEO Analyst & Educatormatt@psiprime.com > > 323 Union Blvd. > Totowa, NJ 07512 > > Direct: 888.872.0274 > Fax: 888.488.5924 > http://www.perosi.com > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us > --089e0158b0d8467f330503580ff0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I will follow through what Matt is suggesting.=C2=A0 = I remembered to even used [countchars] to no avail..

At least,= this rules out issues from WedDNA Developer Limitation (& increasing t= he # of results), something related to WaitFile, too much active db's, = tabbed or comma formatted db's, even RAM.

On Thu, Sep 18, 2014 at 9:26 PM, Psi = Prime Inc, Matthew A Perosi <matt@psiprime.com> wrote:
=20 =20 =20
Somewhere in the Talk List archives is a long discussion I posted about my experiences with blank fields and fields with the number zero (0) in them.

If I'm remembering correctly, you'll have strange results whe= n searching for blank records unless you search for [blank],
as in neK2datarq=3D[blank]

Normally if I want to search for something that's "not equal= " I will use this old trick from the WebDNA docks:
neK2datarq=3Dfind_all
Naturally you won't have a character string "find_all" = in your db, but this is a sanity check to quickly explain what you are doing.

But again, it looks like you want to compare for a zero, not characters.=C2=A0 What I've found is that zero always seems to be= a zero, and not a character.=C2=A0 You can't compare for it unless = you designate to specifically do the query with the type, as in:
&neK2data=3D0&K2type=3Dnum&SEQsort=3D1

Give that a try.


-Matt




On 9/18/2014 8:43 AM, sgbc cebu wrote:
I used to plot my datas in excel, a= nd it always works fine with webDna (snapshot)..


I purported the zeroes into blank cells for this test, and have the data grid reduced from 1467 x 44 cells to 18 x 44 cells. Also, code below was isolated to make sure no conflicts will happen. 

    [t=ext]MyGrade=3D22176[/text]<table border=3D1><tr><td>Subject</td><td>Q1</td><td>Q2</td><td>Q3</td><td>Q4</td><td>FG</td></tr>[search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1][founditems]<tr><td>[search db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems][/search]</td>[search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade][!][/!]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT][founditems]<td>[K2Q1]</td><td>[K2Q2]</td><td>[K2Q3]</td><td>[K2Q4]</td><td>[K2FG]</td>[/founditems][/search]</tr>[/founditems][/search]</table>

The code above produced this html below:

SubjectQ1Q2Q3Q4FG
Phonetics
Mathematics 00000
Environmental Science
Filipino
Penmanship
Music-Eurytmics
Visual Arts
General Average 00000

With borders revealed, note that actually some <td></td> from the [founditems]...[/founditems] has been dropped.

This is the result that we intend to be:

SubjectQ1Q2Q3Q4FG
Phonetics00000
Mathematics00000
Environmental Science00000
Filipino00000
Penmanship00000
Music-Eurytmics00000
Visual Arts00000
General Average00000

Thanks,

Jess V.


On Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain <webdna@idfk.com.au> wrote:
try adding rq to your queries.

ie: =C2=A0&neK2Datarq=3D0


Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA




On 18 Sep 2014, at 12:37 am, sgbc cebu <sgbccebu@gmail.com= > wrote:

I'm wondering whats going on for this search.

I even reduce the database, and filled blank fields with "0" (zero) to ens= ure that there's a character within.

But still the result is the same.

The resulting search will display blank areas.=C2=A0 In this case even dropping the <td>'s that'd represent a cell.=

To illustrate, heres the code:

[text]MyGrade=3D22176[/text]

<table border=3D0>
<tr>
<td>Subject</td>
<td>Q1</td>
<td>Q2</td>
<td>Q3</td>
<td>Q4</td>
<td>FG</td>
</tr>
[search db=3Ddata/classsubjects.db&neK2Data=3D0&a= mp;SeqSort=3D1]
[founditems]
<tr><td>[search db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/foundite= ms][/search]
</td>[search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2= ]&allBLNK=3DT]
=C2=A0=C2=A0=C2=A0 [founditems]
=C2=A0=C2=A0=C2=A0 <td>[K2Q1]</td>= ;
=C2=A0=C2=A0=C2=A0 <td>[K2Q2]</td>= ;
=C2=A0=C2=A0=C2=A0 <td>[K2Q3]</td>= ;
=C2=A0=C2=A0=C2=A0 <td>[K2Q4]</td>= ;
=C2=A0=C2=A0=C2=A0 <td>[K2FG]</td>= ;
=C2=A0=C2=A0=C2=A0 [/founditems]
=C2=A0=C2=A0=C2=A0 [/search]
</tr>[/founditems]
[/search]</table>


Instead of:

Subject =C2=A0=C2=A0=C2=A0 Q1 =C2=A0= =C2=A0=C2=A0 Q2 =C2=A0=C2=A0=C2=A0 Q3 =C2=A0=C2=A0=C2=A0 = Q4 =C2=A0=C2=A0=C2=A0 FG
Phonetics=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=
Mathematics =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0
Environmental Science=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0= =C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=
Filipino=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=
Penmanship=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=
Music-Eurytmics=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0
Visual Arts=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0
General Average =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0


I get this


Subject =C2=A0=C2=A0=C2=A0 Q1 =C2=A0= =C2=A0=C2=A0 Q2 =C2=A0=C2=A0=C2=A0 Q3 =C2=A0=C2=A0=C2=A0 = Q4 =C2=A0=C2=A0=C2=A0 FG
Phonetics=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
Mathematics =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0
Environmental Science=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2= =A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
Filipino=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2= =A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
Penmanship=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
Music-Eurytmics=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2= =A0=C2=A0=C2=A0
Visual Arts=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0
General Average =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0 0
=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0= =C2=A0 =C2=A0=C2=A0=C2=A0

Any help is appreciated.

Jess V.

---------------------------------------------------= ------ This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdn= a.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/lis= t/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us 


--=20Matthew A PerosiCorporate ConsultantMobile Marketing ExpertSenior Web DeveloperSEO Analyst & Educatormatt@psiprime.com323 Union Blvd.Totowa, NJ 07512Direct:  888.872.0274Fax:     888.488.5924http://www.perosi.com
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: suppo= rt@webdna.us

--089e0158b0d8467f330503580ff0-- sgbc cebu

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:

Quickie question on the email templates (1997) Full text search (1999) Bug Report, maybe (1997) Help name our technology! (1997) HideIf ip= OR ip (1998) Looking for WebCat developer/contractor (2000) Lost and Recovered. (1998) Server Load (2000) [WebDNA] WebDNA with Webmin (2017) OT - good CC processor(s)? (1999) test - ignore please (2003) addlineitems within formvariable loop (1998) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) Y2k compliance (1998) Form Problem with ! (2000) WC2.0 Memory Requirements (1997) orders being printed (1998) Templates for Customer Database? (1997) docs for WebCatalog2 (1997) More on the email templates (I like it) (1997)