Re: [WebDNA] random blank results? how come?
This WebDNA talk-list message is from 2014
It keeps the original formatting.
numero = 111587
interpreted = N
texte = without seeing data it=92s difficult to know As a sanity check, I=92d do the following: 1. make table border=3D1, so empty squares will turn up 2. try and display a [numfound] in your subjects.db query results Also, the line [search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems]= [/search] would be quicker as [lookup = db=3Ddata/subjects.db&lookinfield=3DCodeData&value=3D[k2]&returnfield=3Dsu= bject] but that doesn=92t fix what the problem is TC On 17 Sep 2014, at 15:37, 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 > > > | Subject | > Q1 | > Q2 | > Q3 | > Q4 | > FG | > > [search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1] > [founditems] > | [search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems]= [/search] > | [search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT] > [founditems] > [K2Q1] | > [K2Q2] | > [K2Q3] | > [K2Q4] | > [K2FG] | > [/founditems] > [/search] > [/founditems] > [/search] >=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
Associated Messages, from the most recent to the oldest:
without seeing data it=92s difficult to know As a sanity check, I=92d do the following: 1. make table border=3D1, so empty squares will turn up 2. try and display a [numfound] in your subjects.db query results Also, the line [search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems]= [/search] would be quicker as [lookup = db=3Ddata/subjects.db&lookinfield=3DCodeData&value=3D[k2]&returnfield=3Dsu= bject] but that doesn=92t fix what the problem is TC On 17 Sep 2014, at 15:37, 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 > > > | Subject | > Q1 | > Q2 | > Q3 | > Q4 | > FG | > > [search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1] > [founditems] > | [search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems]= [/search] > | [search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT] > [founditems] > [K2Q1] | > [K2Q2] | > [K2Q3] | > [K2Q4] | > [K2FG] | > [/founditems] > [/search] > [/founditems] > [/search] >=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
Toby Cox
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:
WebCat2 - Getting to the browser's username/password data (1997)
[include] affect on filepaths for links? (1997)
Fwd: more ! testing (1997)
Thanks ! (1997)
Looking for a Manual (1997)
Caching [include] files ... (1997)
Bug or syntax error on my part? (1997)
writing db to disk (1997)
Error Lob.db records error message not name (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
FYI: virus alert (1996)
[WebDNA] Search on a database (2012)
There's a bug in the math context ... (1997)
Help HTML reader (1999)
Re[2]: OT: Amazon Patents (2000)
Sendmail strangie (2002)
Tab Delimited Files / FM Pro (1997)
MacAuthorize order data fields WAS:How To question... (1997)
Add to a field (1998)
W* 3.x & WebCat + WebMerchant (1998)
| |