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

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111591
interpreted = N
texte = --Apple-Mail=_870F00FB-9FA8-466A-B897-98FD76DDA0E7 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii This tells us that teh condition=20 [search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT] 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=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT 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).. >=20 >=20 > 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. >=20 >=20 > [text]MyGrade=3D22176[/text] >=20 > >=20 > > > > > > > > > [search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1] > [founditems] > [search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade][!] > [/!]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT] > [founditems] >  >  >  >  >  > [/founditems] > [/search] > [/founditems] > [/search]
SubjectQ1Q2Q3Q4FG
[search db=3Ddata/subjects.db&eqCodeData=3D[k2]] > [founditems][subject][/founditems][/search] > [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
> The code above produced this html below: >=20 >=20 > SubjectQ1Q2Q3Q4FG > Phonetics > Mathematics00000 > Environmental Science=20 > Filipino > Penmanship > Music-Eurytmics > Visual Arts > General Average00000 >=20 > With borders revealed, note that actually some from the = [founditems]...[/founditems] has been dropped. >=20 > This is the result that we intend to be: >=20 >=20 > SubjectQ1Q2Q3Q4FG > Phonetics00000 > Mathematics00000 > Environmental Science00000 > Filipino00000 > Penmanship00000 > Music-Eurytmics00000 > Visual Arts00000 > General Average00000 > Thanks, >=20 > Jess V. >=20 >=20 > On Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain = wrote: > try adding rq to your queries. >=20 > ie: &neK2Datarq=3D0 >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 18 Sep 2014, at 12:37 am, sgbc cebu wrote: >=20 >> 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 >> >> >> >> >> >> >> >> >> >> [search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1] >> [founditems] >> [search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT] >> [founditems] >> >> >> >> >> >> [/founditems] >> [/search] >> [/founditems] >> [/search]
SubjectQ1Q2Q3Q4FG
[search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems]= [/search] >> [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
>>=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 >=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 >=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 --Apple-Mail=_870F00FB-9FA8-466A-B897-98FD76DDA0E7 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii This = tells us that teh condition 

[search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k= 2]&allBLNK=3DT]

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=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k= 2]&allBLNK=3DT

somewhere

=

Then check this against your DB and what you are = expecting to = see



TC


On 18 Sep 2014, at 13:43, sgbc = cebu <sgbccebu@gmail.com> = 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=20 will happen. 


    [text]MyGrade=3D22176[/text]<table border=3D1><tr><td>Subject</td><td>Q1</td><td>Q2</td><td>Q3</td><td>Q4</td><td>FG</td></tr>[search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1][founditems]<tr><td>[search db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems][/search]</td>[search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade][!][/!]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT][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:


=09 =09 =09      =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09      =09 =09
SubjectQ1Q2Q3Q4FG
Phonetics
Mathematics 00000
Environmental Science
Filipino
Penmanship
Music-Eurytmics
Visual Arts
General Average 00000

With borders revealed, note that actually some <td></td> = from the=20 [founditems]...[/founditems] has been dropped.

This is the result that we intend to be:


                             =09          
SubjectQ1Q2Q3Q4FG
Phonetics00000
Mathematics00000
Environmental Science00000
Filipino00000
Penmanship00000
Music-Eurytmics00000
Visual Arts00000
General Average00000

Thanks,

Jess V.


On = Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:
try adding rq to your = queries.

ie: =  &neK2Datarq=3D0


Regards

Stuart Tremain
IDFK Web = Developments
AUSTRALIA




On 18 Sep 2014, at 12:37 am, sgbc = cebu <sgbccebu@gmail.com> = 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 <td>'s that'd = represent a cell.

To illustrate, heres the = code:

[text]MyGrade=3D22176[/text]

<table = border=3D0>
<tr>
<td>Subject</td>
<td>= Q1</td>
<td>Q2</td>
<td>Q3</td>
<= ;td>Q4</td>
<td>FG</td>
</tr>
[search = db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1]
[founditem= s]
<tr><td>[search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/foundit= ems][/search]
</td>[search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k= 2]&allBLNK=3DT]
    = [founditems]
    = <td>[K2Q1]</td>
    = <td>[K2Q2]</td>
    = <td>[K2Q3]</td>
    = <td>[K2Q4]</td>
    = <td>[K2FG]</td>
    = [/founditems]
    = [/search]
</tr>[/founditems]
[/search]</table>

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
<= /div>
--------------------------------------------------------- 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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us<exceldata= .jpg>
=
= --Apple-Mail=_870F00FB-9FA8-466A-B897-98FD76DDA0E7-- 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)
--Apple-Mail=_870F00FB-9FA8-466A-B897-98FD76DDA0E7 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii This tells us that teh condition=20 [search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT] 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=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT 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).. >=20 >=20 > 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. >=20 >=20 > [text]MyGrade=3D22176[/text] >=20 > >=20 > > > > > > > > > [search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1] > [founditems] > [search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade][!] > [/!]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT] > [founditems] >  >  >  >  >  > [/founditems] > [/search] > [/founditems] > [/search]
SubjectQ1Q2Q3Q4FG
[search db=3Ddata/subjects.db&eqCodeData=3D[k2]] > [founditems][subject][/founditems][/search] > [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
> The code above produced this html below: >=20 >=20 > SubjectQ1Q2Q3Q4FG > Phonetics > Mathematics00000 > Environmental Science=20 > Filipino > Penmanship > Music-Eurytmics > Visual Arts > General Average00000 >=20 > With borders revealed, note that actually some from the = [founditems]...[/founditems] has been dropped. >=20 > This is the result that we intend to be: >=20 >=20 > SubjectQ1Q2Q3Q4FG > Phonetics00000 > Mathematics00000 > Environmental Science00000 > Filipino00000 > Penmanship00000 > Music-Eurytmics00000 > Visual Arts00000 > General Average00000 > Thanks, >=20 > Jess V. >=20 >=20 > On Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain = wrote: > try adding rq to your queries. >=20 > ie: &neK2Datarq=3D0 >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 18 Sep 2014, at 12:37 am, sgbc cebu wrote: >=20 >> 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 >> >> >> >> >> >> >> >> >> >> [search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1] >> [founditems] >> [search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k2]&allBL= NK=3DT] >> [founditems] >> >> >> >> >> >> [/founditems] >> [/search] >> [/founditems] >> [/search]
SubjectQ1Q2Q3Q4FG
[search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems]= [/search] >> [K2Q1][K2Q2][K2Q3][K2Q4][K2FG]
>>=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 >=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 >=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 --Apple-Mail=_870F00FB-9FA8-466A-B897-98FD76DDA0E7 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii This = tells us that teh condition 

[search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k= 2]&allBLNK=3DT]

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=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k= 2]&allBLNK=3DT

somewhere

=

Then check this against your DB and what you are = expecting to = see



TC


On 18 Sep 2014, at 13:43, sgbc = cebu <sgbccebu@gmail.com> = 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=20 will happen. 


    [text]MyGrade=3D22176[/text]<table border=3D1><tr><td>Subject</td><td>Q1</td><td>Q2</td><td>Q3</td><td>Q4</td><td>FG</td></tr>[search db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1][founditems]<tr><td>[search db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/founditems][/search]</td>[search db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade][!][/!]&eqSubCodeDatarq=3D[k2]&allBLNK=3DT][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:


=09 =09 =09      =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09 =09      =09 =09
SubjectQ1Q2Q3Q4FG
Phonetics
Mathematics 00000
Environmental Science
Filipino
Penmanship
Music-Eurytmics
Visual Arts
General Average 00000

With borders revealed, note that actually some <td></td> = from the=20 [founditems]...[/founditems] has been dropped.

This is the result that we intend to be:


                             =09          
SubjectQ1Q2Q3Q4FG
Phonetics00000
Mathematics00000
Environmental Science00000
Filipino00000
Penmanship00000
Music-Eurytmics00000
Visual Arts00000
General Average00000

Thanks,

Jess V.


On = Thu, Sep 18, 2014 at 12:42 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:
try adding rq to your = queries.

ie: =  &neK2Datarq=3D0


Regards

Stuart Tremain
IDFK Web = Developments
AUSTRALIA




On 18 Sep 2014, at 12:37 am, sgbc = cebu <sgbccebu@gmail.com> = 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 <td>'s that'd = represent a cell.

To illustrate, heres the = code:

[text]MyGrade=3D22176[/text]

<table = border=3D0>
<tr>
<td>Subject</td>
<td>= Q1</td>
<td>Q2</td>
<td>Q3</td>
<= ;td>Q4</td>
<td>FG</td>
</tr>
[search = db=3Ddata/classsubjects.db&neK2Data=3D0&SeqSort=3D1]
[founditem= s]
<tr><td>[search = db=3Ddata/subjects.db&eqCodeData=3D[k2]][founditems][subject][/foundit= ems][/search]
</td>[search = db=3Ddata/grades.db&eqPupilDatarq=3D[MyGrade]&eqSubCodeDatarq=3D[k= 2]&allBLNK=3DT]
    = [founditems]
    = <td>[K2Q1]</td>
    = <td>[K2Q2]</td>
    = <td>[K2Q3]</td>
    = <td>[K2Q4]</td>
    = <td>[K2FG]</td>
    = [/founditems]
    = [/search]
</tr>[/founditems]
[/search]</table>

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
<= /div>
--------------------------------------------------------- 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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us<exceldata= .jpg>
=
= --Apple-Mail=_870F00FB-9FA8-466A-B897-98FD76DDA0E7-- 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:

Summing fields (1997) RE: format problem on NT? (1997) Protect (1997) unable to launch acgi in WebCat (1997) OT: anyone know how to prevent image hijacking with Apache? (2002) template includes encrypted template (1999) WebCat vs. ASP (1999) WebDNA 5 - Privacy Issue (Built in sniffer) (2003) HELP WITH DATES (1997) Protect vs Authenicate (1997) Stinkin' [Referrer] (1998) A Sensible Suggestion. Was: Major problem (1999) FINAL: STILL not starting on bootup (2002) Problem with updating 2.1b7 -> 2.1.1 (1998) SiteEdit Pro Update Announcement (1997) [WebDNA] Illegal character removal (2012) Emailer (2005) WebCat2 several catalogs? (1997) MOOOOOO (2000) EIMS Problems (1997)