> 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 -- Matthew A Perosi Corporate Consultant Mobile Marketing Expert Senior Web Developer SEO Analyst & Educator matt@psiprime.com 323 Union Blvd. Totowa, NJ 07512 Direct: 888.872.0274 Fax: 888.488.5924 http://www.perosi.com --------------020004070405030103040703 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Somewhere in the talk list archives is a long discussion I posted about my experiences with blank fields and fields with the number zero (0) in them.
If I'm remembering correctly, you'll have strange results when searching for blank records unless you search for [blank],
as in neK2datarq=[blank]
Normally if I want to search for something that's "not equal" I will use this old trick from the WebDNA docks:
neK2datarq=find_all
Naturally you won't have a character string "find_all" in your db, but this is a sanity check to quickly explain what you are doing.
But again, it looks like you want to compare for a zero, not characters. What I've found is that zero always seems to be a zero, and not a character. You can't compare for it unless you designate to specifically do the query with the type, as in:
&neK2data=0&K2type=num&SEQsort=1
Give that a try.
-Matt
On 9/18/2014 8:43 AM, 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] <table border=1> <tr> <td>Subject</td> <td>Q1</td> <td>Q2</td> <td>Q3</td> <td>Q4</td> <td>FG</td> </tr> [search db=data/classsubjects.db&neK2Data=0&SeqSort=1] [founditems] <tr><td>[search db=data/subjects.db&eqCodeData=[k2]] [founditems][subject][/founditems][/search] </td>[search db=data/grades.db&eqPupilDatarq=[MyGrade][!] [/!]&eqSubCodeDatarq=[k2]&allBLNK=T] [founditems] <td>[K2Q1]</td> <td>[K2Q2]</td> <td>[K2Q3]</td> <td>[K2Q4]</td> <td>[K2FG]</td> [/founditems] [/search] </tr>[/founditems] [/search]</table> 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 <td></td> 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.
-- Matthew A Perosi Corporate Consultant Mobile Marketing Expert Senior Web Developer SEO Analyst & Educator matt@psiprime.com 323 Union Blvd. Totowa, NJ 07512 Direct: 888.872.0274 Fax: 888.488.5924 http://www.perosi.com --------------020004070405030103040703--
Associated Messages, from the most recent to the oldest:
This is a multi-part message in MIME format. --------------020004070405030103040703 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Somewhere in the Talk List archives is a long discussion I posted about my experiences with blank fields and fields with the number zero (0) in them. If I'm remembering correctly, you'll have strange results when searching for blank records unless you search for [blank], as in neK2datarq=[blank] Normally if I want to search for something that's "not equal" I will use this old trick from the WebDNA docks: neK2datarq=find_all Naturally you won't have a character string "find_all" in your db, but this is a sanity check to quickly explain what you are doing. But again, it looks like you want to compare for a zero, not characters. What I've found is that zero always seems to be a zero, and not a character. You can't compare for it unless you designate to specifically do the query with the type, as in: &neK2data=0&K2type=num&SEQsort=1 Give that a try. -Matt On 9/18/2014 8:43 AM, 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 -- Matthew A Perosi Corporate Consultant Mobile Marketing Expert Senior Web Developer SEO Analyst & Educator matt@psiprime.com 323 Union Blvd. Totowa, NJ 07512 Direct: 888.872.0274 Fax: 888.488.5924 http://www.perosi.com --------------020004070405030103040703 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Somewhere in the Talk List archives is a long discussion I posted about my experiences with blank fields and fields with the number zero (0) in them. If I'm remembering correctly, you'll have strange results when searching for blank records unless you search for [blank], as in neK2datarq=[blank] Normally if I want to search for something that's "not equal" I will use this old trick from the WebDNA docks: neK2datarq=find_all Naturally you won't have a character string "find_all" in your db, but this is a sanity check to quickly explain what you are doing. But again, it looks like you want to compare for a zero, not characters. What I've found is that zero always seems to be a zero, and not a character. You can't compare for it unless you designate to specifically do the query with the type, as in: &neK2data=0&K2type=num&SEQsort=1 Give that a try. -Matt On 9/18/2014 8:43 AM, 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] <table border=1> <tr> <td>Subject</td> <td>Q1</td> <td>Q2</td> <td>Q3</td> <td>Q4</td> <td>FG</td> </tr> [search db=data/classsubjects.db&neK2Data=0&SeqSort=1] [founditems] <tr><td>[search db=data/subjects.db&eqCodeData=[k2]] [founditems][subject][/founditems][/search] </td>[search db=data/grades.db&eqPupilDatarq=[MyGrade][!] [/!]&eqSubCodeDatarq=[k2]&allBLNK=T] [founditems] <td>[K2Q1]</td> <td>[K2Q2]</td> <td>[K2Q3]</td> <td>[K2Q4]</td> <td>[K2FG]</td> [/founditems] [/search] </tr>[/founditems] [/search]</table> 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 <td></td> 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.
-- Matthew A Perosi Corporate Consultant Mobile Marketing Expert Senior Web Developer SEO Analyst & Educator matt@psiprime.com 323 Union Blvd. Totowa, NJ 07512 Direct: 888.872.0274 Fax: 888.488.5924 http://www.perosi.com --------------020004070405030103040703--
"Psi Prime Inc, Matthew A Perosi "
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:
Best way to handle 404 errors with WebDNA and Web* V (2003)
WebCat2 Append problem (B14Macacgi) (1997)
[WebDNA] FW: Weird non-interpretation of some templates since move to MacTel version (2009)
my price won't move (1997)
The List is Changing (1997)
Browsername (1998)
Mass Mail (2000)
counting characters and/or words (1997)
A multi-processor savvy WebCatalog? (1997)
Date format problems (1997)
[WebDNA] HTTP Streaming - POSSIBLE! (2010)
using WebCat for Associate Programs? (1998)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
[WebDNA] Using WebDNA with MAMP (2010)
Database (2002)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Multiple prices (1997)
Attention all list readers (1997)
[shell]? (2000)
SMSI -- a [notfound] context? (2002)
| |