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:

[isfile] ? (1997) math on date? (1997) [cart] not being interpreted inside [founditems] (1997) b12 cannot limit records returned and more. (1997) FCKeditor (2008) WebCatalog f2 Installation (1997) database size? (1997) Post arguments problem mac? (1997) Nested tags count question (1997) [SubTotal] again (1998) Date Calulation (1997) [date] problem with %d%m%Y (1998) Mystery File - Solved (2005) Search crashing server (1998) Server IP address? (1998) How can I record purchases to a database? (1998) [WebDNA] First-timer feedback (2014) Pithy questions on webcommerce & siteedit (1997) Trouble serving graphics on protected templates (1998) SET (1998)