> 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]>>>>>> >>> >>> Subject | >>> Q1 | >>> Q2 | >>> Q3 | >>> Q4 | >>> FG | >>> >>> [search db=data/classsubjects.db&neK2Data=0&SeqSort=1]>>> [founditems]>>> [search>>> db=data/subjects.db&eqCodeData=[k2]][founditems][subject][/founditems][/search]>>> | [search>>> db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T]>>> [founditems]>>> [K2Q1] | >>> [K2Q2] | >>> [K2Q3] | >>> [K2Q4] | >>> [K2FG] | >>> [/founditems]>>> [/search]>>> [/founditems]>>> [/search] >>>>>>>>> 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:
Why aren't you [url]ing your search parameters like this?:[searchdb=data/grades.db&eqPupilDatarq=[url][MyGrade][/url]&eqSubCodeDatarq=[url][k2][/url]&allBLNK=T]Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server ManagementOn 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]>>>> >>>> >> Subject | >> Q1 | >> Q2 | >> Q3 | >> Q4 | >> FG | >> >> [search db=data/classsubjects.db&neK2Data=0&SeqSort=1]>> [founditems]>> [search db=data/subjects.db&eqCodeData=[k2]]>> [founditems][subject][/founditems][/search]>> | [search db=data/grades.db&eqPupilDatarq=[MyGrade][!]>> [/!]&eqSubCodeDatarq=[k2]&allBLNK=T]>> [founditems]>> [K2Q1] | >> [K2Q2] | >> [K2Q3] | >> [K2Q4] | >> [K2FG] | >> [/founditems]>> [/search]>> [/founditems]>> [/search] >>>> 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]>>>>>> >>> >>> Subject | >>> Q1 | >>> Q2 | >>> Q3 | >>> Q4 | >>> FG | >>> >>> [search db=data/classsubjects.db&neK2Data=0&SeqSort=1]>>> [founditems]>>> [search>>> db=data/subjects.db&eqCodeData=[k2]][founditems][subject][/founditems][/search]>>> | [search>>> db=data/grades.db&eqPupilDatarq=[MyGrade]&eqSubCodeDatarq=[k2]&allBLNK=T]>>> [founditems]>>> [K2Q1] | >>> [K2Q2] | >>> [K2Q3] | >>> [K2Q4] | >>> [K2FG] | >>> [/founditems]>>> [/search]>>> [/founditems]>>> [/search] >>>>>>>>> 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)
| |