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:
creating a ShipCosts database (1997)
searching illegal HTML (2002)
Error handling for accountNum (1997)
[ot] iBook vs. 12" PB (2004)
Introduction/Tutorial/QuickStart (1997)
Apache/Mod-SSL & WebCatalog (UNIX)! module bug? (2000)
Mozilla/4. and Browser Info.txt (1997)
Review comparison by PC Magazine: Open for On-line Business (1997)
can WC render sites out? (1997)
Emailer... DOA but still twitching (2007)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
bypassing typo's (1998)
WebCatalog for Postcards ? (1997)
Latest beta slow on [order] and [purchase] (1997)
Separate SSL Server (1997)
[BULK] [WebDNA] abstraction code can be tricky... (2012)
emailer (1997)
[tcpsend] (2001)
emailer w/F2 (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
| |