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

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111588
interpreted = N
texte = --Apple-Mail=_8FCCB94E-1988-4F71-8AEB-8EBA2E9BFA79 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii try adding rq to your queries. ie: &neK2Datarq=3D0 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. >=20 > I even reduce the database, and filled blank fields with "0" (zero) to = ensure that there's a character within. >=20 > But still the result is the same. >=20 > The resulting search will display blank areas. In this case even = dropping the 's that'd represent a cell. >=20 > To illustrate, heres the code: >=20 > [text]MyGrade=3D22176[/text] >=20 > > > > > > > > > > [search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1] > [founditems] > [search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT] > [founditems] > > > > > > [/founditems] > [/search] > [/founditems] > [/search]
SubjectQ1Q2Q3Q4FG
[search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems]= [/search] > [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
>=20 >=20 > Instead of: >=20 > 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 >=20 >=20 > I get this >=20 >=20 > Subject Q1 Q2 Q3 Q4 FG > Phonetics =20 > Mathematics 0 0 0 0 0 > Environmental Science =20 > Filipino =20 > Penmanship =20 > Music-Eurytmics =20 > Visual Arts =20 > General Average 0 0 0 0 0 > =20 >=20 > Any help is appreciated. >=20 > Jess V. >=20 > --------------------------------------------------------- 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 --Apple-Mail=_8FCCB94E-1988-4F71-8AEB-8EBA2E9BFA79 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii try = adding rq to your queries.

ie: =  &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 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 <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]
[founditem= s]
<tr><td>[search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/foundit= ems][/search]
</td>[search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k= 2]&allBLNK=3DT]
    = [founditems]
    = <td>[K2Q1]</td>
    = <td>[K2Q2]</td>
    = <td>[K2Q3]</td>
    = <td>[K2Q4]</td>
    = <td>[K2FG]</td>
    = [/founditems]
    = [/search]
</tr>[/founditems]
[/search]</table>

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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_8FCCB94E-1988-4F71-8AEB-8EBA2E9BFA79-- 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)
--Apple-Mail=_8FCCB94E-1988-4F71-8AEB-8EBA2E9BFA79 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii try adding rq to your queries. ie: &neK2Datarq=3D0 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. >=20 > I even reduce the database, and filled blank fields with "0" (zero) to = ensure that there's a character within. >=20 > But still the result is the same. >=20 > The resulting search will display blank areas. In this case even = dropping the 's that'd represent a cell. >=20 > To illustrate, heres the code: >=20 > [text]MyGrade=3D22176[/text] >=20 > > > > > > > > > > [search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1] > [founditems] > [search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT] > [founditems] > > > > > > [/founditems] > [/search] > [/founditems] > [/search]
SubjectQ1Q2Q3Q4FG
[search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems]= [/search] > [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
>=20 >=20 > Instead of: >=20 > 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 >=20 >=20 > I get this >=20 >=20 > Subject Q1 Q2 Q3 Q4 FG > Phonetics =20 > Mathematics 0 0 0 0 0 > Environmental Science =20 > Filipino =20 > Penmanship =20 > Music-Eurytmics =20 > Visual Arts =20 > General Average 0 0 0 0 0 > =20 >=20 > Any help is appreciated. >=20 > Jess V. >=20 > --------------------------------------------------------- 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 --Apple-Mail=_8FCCB94E-1988-4F71-8AEB-8EBA2E9BFA79 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii try = adding rq to your queries.

ie: =  &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 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 <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]
[founditem= s]
<tr><td>[search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/foundit= ems][/search]
</td>[search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k= 2]&allBLNK=3DT]
    = [founditems]
    = <td>[K2Q1]</td>
    = <td>[K2Q2]</td>
    = <td>[K2Q3]</td>
    = <td>[K2Q4]</td>
    = <td>[K2FG]</td>
    = [/founditems]
    = [/search]
</tr>[/founditems]
[/search]</table>

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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_8FCCB94E-1988-4F71-8AEB-8EBA2E9BFA79-- Stuart Tremain

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:

NetCloak as Emailer substitute? (1999) Forcing Paragraph Breaks on Results (1998) WCS Newbie question (1997) NetSplat and WebCat2 (1997) Re:trouble (1997) BadSuffix with 2.1b3 cgi (1997) Show shoppingcart after remove last item (1997) Interfacing a webcat front end registartion to CommunigatePRO (2000) RE: High ASCII inside [LOOKUP] inside [LISTWORDS] (1998) Duplicate emails with bcc (2000) Multiple prices (1997) WCS Newbie question (1997) New WebDNA Solutions ... (1997) serial number dishing (1997) Doctype (2004) RePost: NAT and the CART (1999) summ=T (2003) WC2/Mac -- Forms not submitting correctly with Mac browsers (1997) WebDNA dying or ... ? (2005) Bug Report, maybe (1997)