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

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111592
interpreted = N
texte = Why aren't you [url]ing your search parameters like this?: [search db=data/grades.db&eqPupilDatarq=[url][MyGrade][/url]&eqSubCodeDatarq=[url][k2][/url]&allBLNK=T] Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Management On 09/18/2014 07:56 AM, Toby Cox wrote: > This tells us that teh condition > > [search > db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T] > > is returning no results for those records. > > Sometimes a further sanity check is to get webdna to output this > search so you can see it > > i.e. just write > > search > db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T > > somewhere > > > Then check this against your DB and what you are expecting to see > > > > TC > > > > On 18 Sep 2014, at 13:43, sgbc cebu > wrote: > >> I used to plot my datas in excel, and it always works fine with >> webDna (snapshot).. >> >> I purported the zeroes into blank cells for this test, and have >> the data grid reduced from 1467 x 44 cells to 18 x 44 cells. >> Also, code below was isolated to make sure no conflicts will >> happen. >> >> >> [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]
>> >> The code above produced this html below: >> >> >> 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 >> >> With borders revealed, note that actually some from >> the [founditems]...[/founditems] has been dropped. >> >> This is the result that we intend to be: >> >> >> 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 >> >> Thanks, >> >> Jess V. >> >> >> On Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain >> > wrote: >> >> try adding rq to your queries. >> >> ie: &neK2Datarq=0 >> >> >> 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. >>> >>> 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. >>> >>> --------------------------------------------------------- >>> 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 ____ >> >> --------------------------------------------------------- >> 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 >> >> >> --------------------------------------------------------- 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 > > --------------------------------------------------------- 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:

    
  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)
Why aren't you [url]ing your search parameters like this?: [search db=data/grades.db&eqPupilDatarq=[url][MyGrade][/url]&eqSubCodeDatarq=[url][k2][/url]&allBLNK=T] Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Management On 09/18/2014 07:56 AM, Toby Cox wrote: > This tells us that teh condition > > [search > db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T] > > is returning no results for those records. > > Sometimes a further sanity check is to get webdna to output this > search so you can see it > > i.e. just write > > search > db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T > > somewhere > > > Then check this against your DB and what you are expecting to see > > > > TC > > > > On 18 Sep 2014, at 13:43, sgbc cebu > wrote: > >> I used to plot my datas in excel, and it always works fine with >> webDna (snapshot).. >> >> I purported the zeroes into blank cells for this test, and have >> the data grid reduced from 1467 x 44 cells to 18 x 44 cells. >> Also, code below was isolated to make sure no conflicts will >> happen. >> >> >> [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]
>> >> The code above produced this html below: >> >> >> 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 >> >> With borders revealed, note that actually some from >> the [founditems]...[/founditems] has been dropped. >> >> This is the result that we intend to be: >> >> >> 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 >> >> Thanks, >> >> Jess V. >> >> >> On Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain >> > wrote: >> >> try adding rq to your queries. >> >> ie: &neK2Datarq=0 >> >> >> 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. >>> >>> 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. >>> >>> --------------------------------------------------------- >>> 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 ____ >> >> --------------------------------------------------------- >> 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 >> >> >> --------------------------------------------------------- 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 > > --------------------------------------------------------- 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 Kenneth Grome

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:

Re:Password Authentication - request example (1998) Weird problems with [SHOWIF]s (1997) Re: (1997) [LOOKUP] (1997) WebCat2 beta FTP site (1997) [WebDNA] Has [middle] always worked this way? (2014) Protect (1997) SFTP (2004) expired beta (1997) Transfering [text] variables (2000) Wanted: More Math Functions (or, Can You Solve This?) (1997) Table Loop Hoops (2000) Round up prices (2000) thread discussion solution (2000) Great product and great job ! (1997) Strange Search Results (2004) WebDNA Grep help wanted (2004) Problem displaying search result (1997) problems with 2 tags (1997) Upgrading old WebCat Database Files (1997)