Re: [WebDNA] Error 500 with SUMM=T

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113827
interpreted = N
texte = 1422 --089e082d74bcca9a6f0560237fa8 Content-Type: text/plain; charset="UTF-8" maybe it does not like your YELLING... LOL try summ=T and you left the max=10 on? I like the summ and the end... LOL [search db=bases/_temp.db&ne_emaildatarq=[BLANK]&max=10&_emailsumm=T] if you don't care about sort GET rid if IT!!! On Tue, Dec 12, 2017 at 11:16 AM, Lawrence Banahan wrote: > Thanks Kenneth, > > I did add the "_" in Brian's code, so this isn't a problem. Exept if it > gets a problem with the DB... > > I'm going to try your exemple. > > *But what I don't understand is...* > Why this work, *without SUMM=T* > [search db=bases/_temp.db&ne_emaildatarq=[BLANK]&_emailSORT=1&_ > emailsdir=as&max=10] > > And *once I add the Summ=T* it creat a Crash > [search db=bases/_temp.db&ne_emaildatarq=[BLANK]&_emailSORT=1&_ > emailsdir=as&_emailSUMM=T&max=10] > > The page > http://www.tourismethaifr.com/admin/letter/sendmail/maj_base_emailing.tpl > > > 2017-12-12 12:04 GMT+01:00 Kenneth Grome : > >> > sorry... removed the summ but not the field name... below correct >> > temp.db&neemaildatarq=[BLANK]&emailSORT=1&emailsdir=as&max=10][showif >> [numfound]>0]Yahooo![/Showif][/search] >> >> Brian, you keep posting example code that won't work because >> you're apparently assuming that the field name is "email" when in >> fact it is "_email" ... >> >> I actually think that this field name may be the source of the >> problem here. Hasn't it always been a "rule" that we are supposed >> to begin our field names with alphabetical characters? If so, >> then maybe this rule was not strictly enforced until version 8.5. >> >> Lawrence, if you try this maybe it will help diagnose the problem: >> >> 1- close the db >> 2- manually change the field name from "_email" to "email" >> 3- test with these new searches: >> >> [search db=bases/_temp.db&neemaildatarq=x][numfound][/search] >> >> [search >> db=bases/_temp.db&neemaildatarq=x&emailsumm=T][numfound][/search] >> >> If these searches work then you need to stop using "_" as the >> first character in your field names. >> >> BTW, you should absolutely not need to use a sort or max parameter >> when doing a search of this (or any other) database. >> >> Regards, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> Web Database Systems and Linux Server Administration >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list talk@webdna.us >> To unsubscribe, E-mail to: talk-leave@webdna.us >> archives: http://www.webdna.us/page.dna?numero=55 >> Bug Reporting: support@webdna.us >> > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=55 Bug Reporting: support@webdna.us > --089e082d74bcca9a6f0560237fa8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
maybe it does not like your YELLING... LOL try summ=3DT
and you left the max=3D10 on?=C2=A0 I like the summ and th= e end... LOL

[search db=3Dbases/_temp.db&ne_emaildatarq=3D[BLANK]&max=3D= 10&_emailsumm=3DT]

if you don't care about sort GET rid if IT!!!=

On Tue, Dec 12, 2017 at 11:16 AM, Lawrence Banahan <= banahan.l@gmail.co= m> wrote:
=
Thanks Kenneth,

I did add the "_"= ; in Brian's code, so this isn't a problem. Exept if it gets a prob= lem with the DB...

I'm going to try your exemple.

<= /div>But what I don't understand is...
Why this = work, without SUMM=3DT
[search db=3Dbases/_temp.db&ne_emailda= tarq=3D[BLANK]&_emailSORT=3D1&_emailsdir=3Das&max=3D1= 0]

And once I add the Summ=3DT it creat a Crash
[search d= b=3Dbases/_temp.db&ne_emaildatarq=3D[BLANK]&_emailSORT=3D1&= ;_emailsdir=3Das&_emailSUMM=3DT&max=3D10]
=C2=A0
The page
http://www.tourismethaifr.com/admin/letter/sendmail/= maj_base_emailing.tpl


2017-12-= 12 12:04 GMT+01:00 Kenneth Grome <ken@webdnasolutions.com>:
> sorry... removed the sum= m but not the field name... below correct
> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsd= ir=3Das&max=3D10][showif
[numfound]>0]Yahooo![/Showif][/search]

Brian, you keep posting example code that won't work because
you're apparently assuming that the field name is "email" whe= n in
fact it is "_email" ...

I actually think that this field name may be the source of the
problem here.=C2=A0 Hasn't it always been a "rule" that we ar= e supposed
to begin our field names with alphabetical characters?=C2=A0 If so,
then maybe this rule was not strictly enforced until version 8.5.

Lawrence, if you try this maybe it will help diagnose the problem:

1- close the db
2- manually change the field name from "_email" to "email&qu= ot;
3- test with these new searches:

[search db=3Dbases/_temp.db&neemaildatarq=3Dx][numfound][/search]<= br>
[search
db=3Dbases/_temp.db&neemaildatarq=3Dx&emailsumm=3DT][numfound]= [/search]

If these searches work then you need to stop using "_" as the
first character in your field names.

BTW, you should absolutely not need to use a sort or max parameter
when doing a search of this (or any other) database.

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration


---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list talk@w= ebdna.us
To unsubscribe, E-mail to: talk-leave@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --089e082d74bcca9a6f0560237fa8-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  2. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  3. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  4. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  5. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  6. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  7. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  8. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  9. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  10. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  11. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  12. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  13. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  14. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  15. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  16. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  17. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  18. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  19. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  20. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  21. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  22. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  23. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  24. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  25. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  26. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  27. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  28. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  29. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  30. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  31. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  32. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  33. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  34. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  35. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  36. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  37. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  38. [BULK] Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  39. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  40. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  41. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  42. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  43. Re: [WebDNA] Error 500 with SUMM=T ("Lawrence Banahan - Author's Image" 2017)
  44. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  45. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  46. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  47. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  48. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  49. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  50. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  51. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  52. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  53. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  54. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  55. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  56. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  57. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  58. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  59. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  60. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  61. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  62. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  63. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  64. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  65. Re: [WebDNA] Error 500 with SUMM=T (christophe.billiottet@webdna.us 2017)
  66. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  67. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  68. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  69. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  70. [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
1422 --089e082d74bcca9a6f0560237fa8 Content-Type: text/plain; charset="UTF-8" maybe it does not like your YELLING... LOL try summ=T and you left the max=10 on? I like the summ and the end... LOL [search db=bases/_temp.db&ne_emaildatarq=[BLANK]&max=10&_emailsumm=T] if you don't care about sort GET rid if IT!!! On Tue, Dec 12, 2017 at 11:16 AM, Lawrence Banahan wrote: > Thanks Kenneth, > > I did add the "_" in Brian's code, so this isn't a problem. Exept if it > gets a problem with the DB... > > I'm going to try your exemple. > > *But what I don't understand is...* > Why this work, *without SUMM=T* > [search db=bases/_temp.db&ne_emaildatarq=[BLANK]&_emailSORT=1&_ > emailsdir=as&max=10] > > And *once I add the Summ=T* it creat a Crash > [search db=bases/_temp.db&ne_emaildatarq=[BLANK]&_emailSORT=1&_ > emailsdir=as&_emailSUMM=T&max=10] > > The page > http://www.tourismethaifr.com/admin/letter/sendmail/maj_base_emailing.tpl > > > 2017-12-12 12:04 GMT+01:00 Kenneth Grome : > >> > sorry... removed the summ but not the field name... below correct >> > temp.db&neemaildatarq=[BLANK]&emailSORT=1&emailsdir=as&max=10][showif >> [numfound]>0]Yahooo![/Showif][/search] >> >> Brian, you keep posting example code that won't work because >> you're apparently assuming that the field name is "email" when in >> fact it is "_email" ... >> >> I actually think that this field name may be the source of the >> problem here. Hasn't it always been a "rule" that we are supposed >> to begin our field names with alphabetical characters? If so, >> then maybe this rule was not strictly enforced until version 8.5. >> >> Lawrence, if you try this maybe it will help diagnose the problem: >> >> 1- close the db >> 2- manually change the field name from "_email" to "email" >> 3- test with these new searches: >> >> [search db=bases/_temp.db&neemaildatarq=x][numfound][/search] >> >> [search >> db=bases/_temp.db&neemaildatarq=x&emailsumm=T][numfound][/search] >> >> If these searches work then you need to stop using "_" as the >> first character in your field names. >> >> BTW, you should absolutely not need to use a sort or max parameter >> when doing a search of this (or any other) database. >> >> Regards, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> Web Database Systems and Linux Server Administration >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list talk@webdna.us >> To unsubscribe, E-mail to: talk-leave@webdna.us >> archives: http://www.webdna.us/page.dna?numero=55 >> Bug Reporting: support@webdna.us >> > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=55 Bug Reporting: support@webdna.us > --089e082d74bcca9a6f0560237fa8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
maybe it does not like your YELLING... LOL try summ=3DT
and you left the max=3D10 on?=C2=A0 I like the summ and th= e end... LOL

[search db=3Dbases/_temp.db&ne_emaildatarq=3D[BLANK]&max=3D= 10&_emailsumm=3DT]

if you don't care about sort GET rid if IT!!!=

On Tue, Dec 12, 2017 at 11:16 AM, Lawrence Banahan <= banahan.l@gmail.co= m> wrote:
=
Thanks Kenneth,

I did add the "_"= ; in Brian's code, so this isn't a problem. Exept if it gets a prob= lem with the DB...

I'm going to try your exemple.

<= /div>But what I don't understand is...
Why this = work, without SUMM=3DT
[search db=3Dbases/_temp.db&ne_emailda= tarq=3D[BLANK]&_emailSORT=3D1&_emailsdir=3Das&max=3D1= 0]

And once I add the Summ=3DT it creat a Crash
[search d= b=3Dbases/_temp.db&ne_emaildatarq=3D[BLANK]&_emailSORT=3D1&= ;_emailsdir=3Das&_emailSUMM=3DT&max=3D10]
=C2=A0
The page
http://www.tourismethaifr.com/admin/letter/sendmail/= maj_base_emailing.tpl


2017-12-= 12 12:04 GMT+01:00 Kenneth Grome <ken@webdnasolutions.com>:
> sorry... removed the sum= m but not the field name... below correct
> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsd= ir=3Das&max=3D10][showif
[numfound]>0]Yahooo![/Showif][/search]

Brian, you keep posting example code that won't work because
you're apparently assuming that the field name is "email" whe= n in
fact it is "_email" ...

I actually think that this field name may be the source of the
problem here.=C2=A0 Hasn't it always been a "rule" that we ar= e supposed
to begin our field names with alphabetical characters?=C2=A0 If so,
then maybe this rule was not strictly enforced until version 8.5.

Lawrence, if you try this maybe it will help diagnose the problem:

1- close the db
2- manually change the field name from "_email" to "email&qu= ot;
3- test with these new searches:

[search db=3Dbases/_temp.db&neemaildatarq=3Dx][numfound][/search]<= br>
[search
db=3Dbases/_temp.db&neemaildatarq=3Dx&emailsumm=3DT][numfound]= [/search]

If these searches work then you need to stop using "_" as the
first character in your field names.

BTW, you should absolutely not need to use a sort or max parameter
when doing a search of this (or any other) database.

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration


---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list talk@w= ebdna.us
To unsubscribe, E-mail to: talk-leave@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --089e082d74bcca9a6f0560237fa8-- . Brian Harrington

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:

PCS Emailer's role ? (1997) Protect and Serve (1999) can pull down menu do a ONCHANGE= without Java script? (2000) [PROTECT... (2000) assigning a id no. (2000) Listfiles context (2000) Strange sort in search... (2000) Template Cache problem (2000) Editing Users.db (1997) So many lookers, hey smith micro (2003) Databases going to sleep (1998) all records returned. (1997) Images in WebCat (2000) referrer and no caches (1997) back one? (2000) Handy Browser Counter Tip (1997) Multiple fields on 1 input (1997) New (1998) WCS Newbie question (1997) [WebDNA] detailed description of what [sendmail] does - repost please (2012)