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:

Lookup Notfound (1998) unable to launch acgi in WebCat (1997) latest version? (1998) More on the email templates (1997) webcat (2000) all records returned. (1997) Dummy Credit Card Number for debug? (1997) Bug or syntax error on my part? (1997) [TaxableTotal] - not working with AOL and IE (1997) range vs greater than/less than (2003) Can't use old cart file (was One more try) (1997) FM PRO Compatibility Issue - Single Database w/oConversions (1997) Resume Catalog ? (1997) old cart file deletion (2000) [switch][case] (2004) Quiz question: Return all green and blank records? (2001) command=purchase (2000) [taxRate] [TaxTotal] ? (1997) request for string functions (1998) system crashes, event log (1997)