[WebDNA] random blank results? how come?

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111586
interpreted = N
texte = --089e0158b0d837812f050343cf8e Content-Type: text/plain; charset=UTF-8 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. --089e0158b0d837812f050343cf8e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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.= =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&= lt;/td>
<td>Q1</td>
<td>Q2</td>
<td&= gt;Q3</td>
<td>Q4</td>
<td>FG</td>
&= lt;/tr>
[search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSo= rt=3D1]
[founditems]
<tr><td>[search db=3Ddata/subjects.d= b&eqCodeData=3D[k2]][founditems][subject][/founditems][/search]
<= /td>[search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubC= odeDatarq=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 <= br>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
Penm= anship=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 <= br>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 he= lp is appreciated.

Jess V.

--089e0158b0d837812f050343cf8e-- 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)
--089e0158b0d837812f050343cf8e Content-Type: text/plain; charset=UTF-8 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. --089e0158b0d837812f050343cf8e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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.= =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&= lt;/td>
<td>Q1</td>
<td>Q2</td>
<td&= gt;Q3</td>
<td>Q4</td>
<td>FG</td>
&= lt;/tr>
[search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSo= rt=3D1]
[founditems]
<tr><td>[search db=3Ddata/subjects.d= b&eqCodeData=3D[k2]][founditems][subject][/founditems][/search]
<= /td>[search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubC= odeDatarq=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 <= br>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
Penm= anship=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 <= br>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 he= lp is appreciated.

Jess V.

--089e0158b0d837812f050343cf8e-- 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:

PROBLEM (1997) Database Security Rev., (2002) Typhoon Rev. and PCS store problems (1999) catagories (1997) using showpage and showcart commands (1996) Can you specify encoding=multiline? (2000) Updating a database once per day - An example (1998) How To question on setting up downloads (1997) Help name our technology! I found it (1997) Resume Catalog ? (1997) Getting Values into Cart the easy way?* (1998) japanese characters (1997) Variable Prices (1998) Shop till you drop dead on the avenue ... (1997) Possible Bug in 2.0b15.acgi (1997) WebDNA creates DUPLICATE SHOPPING CART NUMBERS (2004) Snake Bites (1997) Multiple prices (1997) same product in cart (1997) WIDGET: random image generator (2007)