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

Bulk capture for Authorize.net (2004) email database file (2005) autosensing lanague selection (1997) New WebDNA Forum Solution (in development) (2003) [showif] not working (2003) [SearchString] usage (1997) WebCat2b13 Command Reference Doc error (1997) EMailer - WebSTAR V - OSX - WebDNA (2003) Q: old cart serial problem (2000) [WebDNA] Putting '&search' into URL killing all search contexts (2010) Storefornts (1997) Using the new syntax/scoping methods (2000) did I miss anything (1997) How many Databases can I open? (2003) [Sum] function? (1997) Encrypted Templates Serving as Text (2000) [OT] SSL security in browser (2005) Which GUI HTML editors work with WC ? (1997) HELP WITH DATES (1997) SSI *nix 4.5 build (2002)