Re: [WebDNA] Error 500 with SUMM=T

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113814
interpreted = N
texte = 1409 --001a11427b8060005f056022c90c Content-Type: text/plain; charset="UTF-8" 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 > --001a11427b8060005f056022c90c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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=3DT
[search db=3Dbases/_temp.= db&ne_emaildatarq=3D[BLANK]&_emailSORT=3D1&_emailsdir= =3Das&max=3D10]

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


2= 017-12-12 12:04 GMT+01:00 Kenneth Grome <ken@webdnasolutions.com= >:
> sorry.= ... removed the summ 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][/sea= rch]

[search
db=3Dbases/_temp.db&neemaildatarq=3Dx&emailsumm=3DT][numf= ound][/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-lea= ve@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
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=3D55 Bug Reporting: support@webdna.us --001a11427b8060005f056022c90c-- . 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)
1409 --001a11427b8060005f056022c90c Content-Type: text/plain; charset="UTF-8" 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 > --001a11427b8060005f056022c90c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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=3DT
[search db=3Dbases/_temp.= db&ne_emaildatarq=3D[BLANK]&_emailSORT=3D1&_emailsdir= =3Das&max=3D10]

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


2= 017-12-12 12:04 GMT+01:00 Kenneth Grome <ken@webdnasolutions.com= >:
> sorry.= ... removed the summ 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][/sea= rch]

[search
db=3Dbases/_temp.db&neemaildatarq=3Dx&emailsumm=3DT][numf= ound][/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-lea= ve@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
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=3D55 Bug Reporting: support@webdna.us --001a11427b8060005f056022c90c-- . Lawrence Banahan

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:

Polls (2003) New Command prefs ... (1997) 300% usage - Clint (2007) (2000) WebCat2 - Getting to the browser's username/password data (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) questions on variations of Ken's [text (1999) Emailer setup (1997) Exclamation point (1997) [WebDNA] Error installing v6.2 on Ubuntu 10.10 ... (2012) Multiple prices (1997) wired [protect] action? (1998) something simple? (1998) [WebDNA] WebDNA 8.6 announced - New features (2018) WebCat2 - Getting to the browser's username/password data (1997) I give up!! (1997) Search returns all, not 20 (1997) FW: weird problem (2004) 2nd WebCatalog2 Feature Request (1996) Formating found categories (1997)