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

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111593
interpreted = N
texte = --001a1133e0e4380ec4050356d45c Content-Type: text/plain; charset=UTF-8 Changed parameters and it will show... Subject Q1 Q2 Q3 Q4 FG English 81 83 74 84 81 Mathematics 75 85 83 83 82 Science 77 85 77 86 81 Social Studies 83 85 84 86 85 M.A.P.E. 91 89 91 92 91 Values Education 92 93 91 89 91 HELE 93 92 92 92 92 General Average 83 85.8 82.5 86.3 84.5 But when I add up all the other blank (or w/ zeroes) fields, then this problem comes up. I tried a quick run with [url], & seems nothing happened... but will check on this further.. BTW, this is my first attempt to implement "allBLNK=T" after I found this when searching in the archives in connection to this subject matter. And I think this might not be necessary for now, as I have zeroes in place of blank fields. Is my thinking right? On Thu, Sep 18, 2014 at 8:56 PM, Toby Cox wrote: > This tells us that teh condition > > [search > db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T] > > is returning no results for those records. > > Sometimes a further sanity check is to get webdna to output this search so > you can see it > > i.e. just write > > search > db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T > > somewhere > > > Then check this against your DB and what you are expecting to see > > > > TC > > > > On 18 Sep 2014, at 13:43, 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 > > > > --------------------------------------------------------- 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 > --001a1133e0e4380ec4050356d45c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Changed parameters and it will show...
<= br> =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09
SubjectQ1Q2Q3Q4FG
English 8183748481
Mathematics 7585838382
Science 7785778681
Social Studies 8385848685
M.A.P.E. 9189919291
Values Education 9293918991
HELE 9392929292
General Average 8385.882.586.384.5

But when I add up all the other blank (or w/ zero= es) fields, then this problem comes up.

I tried a quick run wi= th [url], & seems nothing happened... but will check on this further..<= br>
BTW, this is my first attempt to implement = "allBLNK=3DT" after I found this when searching in the archives i= n connection to this subject matter. And I think this might not be necessar= y for now, as I have zeroes in place of blank fields.=C2=A0 Is my thinking = right?





On Thu, Sep 18, 2014 at 8:56 PM, Toby Cox <toby= .cox@netro42.com> wrote:
This tells us that teh condition=C2=A0
[search db=3Ddata/grades.db&eqPu= pilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT]

is returning no results for those records.

Sometimes a further sanity check is to get webdna to output= this search so you can see it

i.e. just write

search db=3Ddata/grades.db&eqPup= ilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT
<= br>
somewhere


Then= check this against your DB and what you are expecting to see


TC


<= /div>

On 18 Sep 2014, at 13:43, sg= bc cebu <sgbcceb= u@gmail.com> wrote:

<= div>
I used to plot my datas in excel, an= d it always works fine with webDna (snapshot)..

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


    [text]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:


=09 =09 =09      =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09      =09 =09
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 t= he=20 [founditems]...[/founditems] has been dropped.

This is the result that we intend to be:


                             =09          
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&neK2= Datarq=3D0


Regar= ds

Stuart Tremain
IDFK Web Developments
AUSTRALIA
<= br>



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

I'm wondering whats going on for this search.

I ev= en reduce the database, and filled blank fields with "0" (zero) t= o ensure that there's a character within.

But still the result i= s 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&SeqSort=3D1][founditems]
<tr><td>[search db=3Ddata/subjects.db&eqCo= deData=3D[k2]][founditems][subject][/founditems][/search]
</td>[se= arch 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]&l= t;/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]&l= t;/td>
=C2=A0=C2=A0=C2=A0 [/founditems]
=C2=A0=C2=A0=C2=A0 [/searc= h]
</tr>[/founditems]
[/search]</table>


Instea= d 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
Mathem= atics =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 0Filipino=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
Pen= manship=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
Genera= l 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
<= span style=3D"font-family:courier new,monospace">

I get this<= br>

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
Mathematic= s =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 app= reciated.

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: suppo= rt@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: suppo= rt@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: suppo= rt@webdna.us<exceldata.jpg>

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

--001a1133e0e4380ec4050356d45c-- 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)
--001a1133e0e4380ec4050356d45c Content-Type: text/plain; charset=UTF-8 Changed parameters and it will show... Subject Q1 Q2 Q3 Q4 FG English 81 83 74 84 81 Mathematics 75 85 83 83 82 Science 77 85 77 86 81 Social Studies 83 85 84 86 85 M.A.P.E. 91 89 91 92 91 Values Education 92 93 91 89 91 HELE 93 92 92 92 92 General Average 83 85.8 82.5 86.3 84.5 But when I add up all the other blank (or w/ zeroes) fields, then this problem comes up. I tried a quick run with [url], & seems nothing happened... but will check on this further.. BTW, this is my first attempt to implement "allBLNK=T" after I found this when searching in the archives in connection to this subject matter. And I think this might not be necessary for now, as I have zeroes in place of blank fields. Is my thinking right? On Thu, Sep 18, 2014 at 8:56 PM, Toby Cox wrote: > This tells us that teh condition > > [search > db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T] > > is returning no results for those records. > > Sometimes a further sanity check is to get webdna to output this search so > you can see it > > i.e. just write > > search > db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T > > somewhere > > > Then check this against your DB and what you are expecting to see > > > > TC > > > > On 18 Sep 2014, at 13:43, 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 > > > > --------------------------------------------------------- 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 > --001a1133e0e4380ec4050356d45c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Changed parameters and it will show...
<= br> =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09 =09      =09 =09
SubjectQ1Q2Q3Q4FG
English 8183748481
Mathematics 7585838382
Science 7785778681
Social Studies 8385848685
M.A.P.E. 9189919291
Values Education 9293918991
HELE 9392929292
General Average 8385.882.586.384.5

But when I add up all the other blank (or w/ zero= es) fields, then this problem comes up.

I tried a quick run wi= th [url], & seems nothing happened... but will check on this further..<= br>
BTW, this is my first attempt to implement = "allBLNK=3DT" after I found this when searching in the archives i= n connection to this subject matter. And I think this might not be necessar= y for now, as I have zeroes in place of blank fields.=C2=A0 Is my thinking = right?





On Thu, Sep 18, 2014 at 8:56 PM, Toby Cox <toby= .cox@netro42.com> wrote:
This tells us that teh condition=C2=A0
[search db=3Ddata/grades.db&eqPu= pilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT]

is returning no results for those records.

Sometimes a further sanity check is to get webdna to output= this search so you can see it

i.e. just write

search db=3Ddata/grades.db&eqPup= ilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT
<= br>
somewhere


Then= check this against your DB and what you are expecting to see


TC


<= /div>

On 18 Sep 2014, at 13:43, sg= bc cebu <sgbcceb= u@gmail.com> wrote:

<= div>
I used to plot my datas in excel, an= d it always works fine with webDna (snapshot)..

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


    [text]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:


=09 =09 =09      =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09      =09 =09
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 t= he=20 [founditems]...[/founditems] has been dropped.

This is the result that we intend to be:


                             =09          
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&neK2= Datarq=3D0


Regar= ds

Stuart Tremain
IDFK Web Developments
AUSTRALIA
<= br>



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

I'm wondering whats going on for this search.

I ev= en reduce the database, and filled blank fields with "0" (zero) t= o ensure that there's a character within.

But still the result i= s 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&SeqSort=3D1][founditems]
<tr><td>[search db=3Ddata/subjects.db&eqCo= deData=3D[k2]][founditems][subject][/founditems][/search]
</td>[se= arch 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]&l= t;/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]&l= t;/td>
=C2=A0=C2=A0=C2=A0 [/founditems]
=C2=A0=C2=A0=C2=A0 [/searc= h]
</tr>[/founditems]
[/search]</table>


Instea= d 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
Mathem= atics =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 0Filipino=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
Pen= manship=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
Genera= l 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
<= span style=3D"font-family:courier new,monospace">

I get this<= br>

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
Mathematic= s =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 app= reciated.

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: suppo= rt@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: suppo= rt@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: suppo= rt@webdna.us<exceldata.jpg>

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

--001a1133e0e4380ec4050356d45c-- 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:

[WebDNA] Mac Question (2018) IIS Brain Dead (1998) Post arguments problem mac? (1997) Part Html part WebDNA (1997) This [search] worked before update to 4.5.1 (2003) Error Msg (1998) TCP Connect (2000) Founditems context returning only 1 item (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Can someone look at this (2003) Show items based on login Password (2003) Dang... Sorry, WebDNA server not running (again)? (2003) SKU Question (1999) typhoon... (1997) Non WebDNA forms and timed popups... (2002) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Mac Lockup Problems (1998) Search in 2 or more catalogs (1997) [TaxableTotal] - not working with AOL and IE (1997) PCS Emailer's role ? (1997)