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:

Download URL & access on the fly ? (1997) [shownext max=?] armed (1997) Max Record length restated as maybe bug (1997) Questions To Answer (1997) Re1000001: Setting up shop (1997) sort problems....bug or brain fart? (1997) Listserver problem (1997) Max Record length restated as maybe bug (1997) authorize.net hex coded variables OOPS (2002) autosensing lanague selection (1997) Where's Cart Created ? (1997) texta,b,c,d,e (urgent) (2003) Solution help needed (1998) Search Engine questions ... (2002) Errata: WCS Newbie question (1997) Re:no [search] with NT (1997) WebCatalog 4.0 has been released! (2000) [WebDNA] Happy Friday (2016) [WebDNA] Store down? (2014) WebCat2b15MacPlugin - showing [math] (1997)