Re: [WebDNA] Error 500 with SUMM=T

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113812
interpreted = N
texte = 1407 --001a11427b80e9c20f0560229f8d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Yes this works, [search db=3Dbases/_temp.db&ne_emaildatarq=3D[BLANK]&_emailSORT=3D1&_emailsdir=3Das= &max=3D10] [showif [numfound]>0]Yahooo![/Showif][/search]
it is when I add the Summ=3DT that it crash! Is there a delay in the search? 2017-12-12 11:59 GMT+01:00 Brian Harrington : > sorry... removed the summ but not the field name... below correct > > > > temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&max=3D10][sh= owif > [numfound]>0]Yahooo![/Showif][/search] > > On Tue, Dec 12, 2017 at 10:57 AM, Brian Harrington > wrote: > >> 12 years doing webdna never used a "FIND_ALL" but the first thing I >> would do is remove the summ, then re tab the database... do a copy, re >> paste on the tabs in the header! >> >> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email&max= =3D10][showif >> [numfound]>0]Yahooo![/Showif][/search] >> >> On Tue, Dec 12, 2017 at 10:47 AM, Brian Harrington < >> autoglasswny@gmail.com> wrote: >> >>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM= =3DT&max=3D10][showif >>> [numfound]>0]Yahooo![/Showif][/search] >>> >>> On Tue, Dec 12, 2017 at 10:44 AM, Brian Harrington < >>> autoglasswny@gmail.com> wrote: >>> >>>> add a max to see if u get a hit... >>>> >>>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email >>>> SUMM=3DT&max=3D10] >>>> >>>> On Tue, Dec 12, 2017 at 10:42 AM, Brian Harrington < >>>> autoglasswny@gmail.com> wrote: >>>> >>>>> also... why sort=3D1 but then no order? >>>>> >>>>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUM= M=3DT] >>>>> >>>>> On Tue, Dec 12, 2017 at 10:38 AM, Brian Harrington < >>>>> autoglasswny@gmail.com> wrote: >>>>> >>>>>> emp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailSUMM=3DT] >>>>>> >>>>>> >>>>>> On Tue, Dec 12, 2017 at 10:34 AM, Brian Harrington < >>>>>> autoglasswny@gmail.com> wrote: >>>>>> >>>>>>> have been following briefly but why the "NE_" ??? >>>>>>> >>>>>>> On Tue, Dec 12, 2017 at 8:00 AM, >>>>>>> wrote: >>>>>>> >>>>>>>> Just curiosity=E2=80=A6 try [search db=3Dbases/_temp.db&ne_emailda= ta >>>>>>>> =3DFIND_ALL&_emailSORT=3D1&_emailSUMM=3DT] >>>>>>>> >>>>>>>> - chris >>>>>>>> >>>>>>>> On Dec 12, 2017, at 10:39, Lawrence Banahan >>>>>>>> wrote: >>>>>>>> >>>>>>>> Hi Brian, tht's what I did with remove code down and down until I >>>>>>>> arrived to this issuu, and there are only one column of email data= .... >>>>>>>> The script was working perfectly for 3 years befor switching to 8.= 5 >>>>>>>> >>>>>>>> >>>>>>>> 2017-12-12 8:37 GMT+01:00 Lawrence Banahan : >>>>>>>> >>>>>>>>> My first thought... 5000000 it should be good lol >>>>>>>>> even it shouldn't create a server error... >>>>>>>>> >>>>>>>>> 2017-12-12 0:56 GMT+01:00 Stuart Tremain : >>>>>>>>> >>>>>>>>>> Have you set the *maximum found items* in WebDNA to accomodate >>>>>>>>>> your expected results ? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Kind regards >>>>>>>>>> >>>>>>>>>> Stuart Tremain >>>>>>>>>> Pharoah Lane Software >>>>>>>>>> AUSTRALIA >>>>>>>>>> webdna@idfk.com.au >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On 12 Dec 2017, at 02:10, Lawrence Banahan >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> Since I upgraded to WDna8.5 I have a strange situation. >>>>>>>>>> >>>>>>>>>> I make a search through a db that have about 15 000 entries >>>>>>>>>> >>>>>>>>>> This line works >>>>>>>>>> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL] Total emai= ls >>>>>>>>>> avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text show=3Dt]= nb-av=3D[numfound][/text] >>>>>>>>>> [/search] >>>>>>>>>> >>>>>>>>>> This one makes me a Error 500 >>>>>>>>>> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL&_emailSUMM= =3DT] >>>>>>>>>> Total emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[= text >>>>>>>>>> show=3Dt]nb-av=3D[numfound][/text][/search] >>>>>>>>>> >>>>>>>>>> "Internal Server Error >>>>>>>>>> The server encountered an internal error or misconfiguration and >>>>>>>>>> was unable to complete your request." >>>>>>>>>> >>>>>>>>>> I haven't purchase a licence for 8.5 is that the reason? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Thanks >>>>>>>>>> Lawrence >>>>>>>>>> --------------------------------------------------------- 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 Reportin= g: >>>>>>>>>> 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 Reportin= g: >>>>>>>>>> support@webdna.us >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> --------------------------------------------------------- This >>>>>>>> message is sent to you because you are subscribed to the mailing l= ist >>>>>>>> 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 >>>>>>>> >>>>>>>> >>>>>>>> --------------------------------------------------------- This >>>>>>>> message is sent to you because you are subscribed to the mailing l= ist >>>>>>>> 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 >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> > --------------------------------------------------------- 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.u= s > --001a11427b80e9c20f0560229f8d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Yes this works,
[search db=3Dbases/_temp.db&n= e_emaildatarq=3D[BLANK]&_emailSORT=3D1&_emailsdir=3Das&max=3D10= ]
=C2=A0[showif [numfound]>0]Yahooo![/Showif][/search]<br>
<= br>it is when I add the Summ=3DT that it crash!

Is there a del= ay in the search?

2017-12-12 11:59 GMT+01:00 Brian Harrington <= ;autoglasswny@g= mail.com>:
sorry... removed the summ but not the field name... below correct

=


temp.db= &
neemaildatarq= =3D[BLANK]&emailSORT=3D1&emailsdir=3Das&max=3D10][showif [numfound]>= 0]Yahooo![/Showif][/search]

On Tue, Dec 12, 2017 at 10:57 AM, Brian Harrington <= ;autoglasswny@g= mail.com> wrote:
12 years doing webdna never used a "FIND_ALL" but the first thing I would do is r= emove the summ, then re tab the database... do a copy, re paste on the tabs= in the header!

t= emp.db&neemail= datarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email&max=3D10][showi= f [numfound]>0]Yahooo![/Showif][/search]

On Tue, Dec 12, 2017 at 10:47 AM= , Brian Harrington <autoglasswny@gmail.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">
temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT&max=3D10][showif [numfound]>0]Yahooo![/Showif][/sea= rch]

On Tue, Dec 12, 2017 a= t 10:44 AM, Brian Harrington <autoglasswny@gmail.com> w= rote:
add a max to see i= f u get a hit...

temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT= &max=3D10]

On Tue, Dec 12, 2017 at 10:42 AM, Bri= an Harrington <autoglasswny@gmail.com> wrote:
also... why sort=3D1 but then no = order?

temp.db&neema= ildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT]

On Tue, Dec 12, = 2017 at 10:38 AM, Brian Harrington <autoglasswny@gmail.com> wrote:
emp.db&neemaildatarq=3D[BLANK]&emailSORT= =3D1&emailSUMM= =3DT]

=
On Tue, Dec 12, 2017 at 10:34 AM, Brian Harrin= gton <autoglasswny@gmail.com> wrote:
have been following briefly but why the &q= uot;NE_" ???

On Tue, Dec 12, 2017 at 8:00 AM, <christophe.billiottet@w= ebdna.us> wrote:
Just curiosity= =E2=80=A6 try=C2=A0[search db=3Dbases/_temp.db&ne_emaildata=3DFIND= _ALL&_emailSORT=3D1&_emailSUMM=3DT]

- chris=

On Dec 12, 2017, at 10:39= , Lawrence Banahan <banahan.l@gmail.com> wrote:

Hi B= rian, tht's what I did with remove code down and down until I arrived t= o this issuu, and there are only one column of email data...
The = script was working perfectly for 3 years befor switching to 8.5


20= 17-12-12 8:37 GMT+01:00 Lawrence Banahan <banahan.l@gmail.com>:
= My first thought... 5000000 it should be good lol
even it shouldn&= #39;t create a server error...

2017-12-12 0:56 GMT+01:00 Stuart= Tremain <webdna@idfk.com.au>:
Have you set the maximum found items<= /b> in WebDNA to accomodate your expected results ?



<Screen Shot 2017-12-12 at 10.55.02.png= >



Kind regards

Stua= rt Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au



<= /div>


On 12 Dec 2017, at 02:10, Lawrence Banahan &= lt;banahan.l@gmail= ..com> wrote:

Hi,
Since I upgraded to WDna8.5 = I have a strange situation.

I make a search through a db that = have about 15 000 entries

This line works
[search db=3Dbases/_tem= p.db&ne_emaildata=3DFIND_ALL] Total=C2=A0 emails avant suppr=C3=A9= ssion des d=C3=A9inscriptions=3D[text show=3Dt]nb-av=3D[numfound][/text][/search]

This one makes me a Error 500
[search db=3Dbase= s/_temp.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] Total=C2=A0= emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text show=3Dt]nb-= av=3D[numfound][/text][/search]

"Interna= l Server Error
The server encountered an internal error or mi= sconfiguration and was unable to complete your request."

I haven't purchase a licence for 8.5 is that the reason?
=

Thanks
Lawrence
--------------------------------------------------------- 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@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@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 --001a11427b80e9c20f0560229f8d-- . 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)
1407 --001a11427b80e9c20f0560229f8d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Yes this works, [search db=3Dbases/_temp.db&ne_emaildatarq=3D[BLANK]&_emailSORT=3D1&_emailsdir=3Das= &max=3D10] [showif [numfound]>0]Yahooo![/Showif][/search]
it is when I add the Summ=3DT that it crash! Is there a delay in the search? 2017-12-12 11:59 GMT+01:00 Brian Harrington : > sorry... removed the summ but not the field name... below correct > > > > temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&max=3D10][sh= owif > [numfound]>0]Yahooo![/Showif][/search] > > On Tue, Dec 12, 2017 at 10:57 AM, Brian Harrington > wrote: > >> 12 years doing webdna never used a "FIND_ALL" but the first thing I >> would do is remove the summ, then re tab the database... do a copy, re >> paste on the tabs in the header! >> >> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email&max= =3D10][showif >> [numfound]>0]Yahooo![/Showif][/search] >> >> On Tue, Dec 12, 2017 at 10:47 AM, Brian Harrington < >> autoglasswny@gmail.com> wrote: >> >>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM= =3DT&max=3D10][showif >>> [numfound]>0]Yahooo![/Showif][/search] >>> >>> On Tue, Dec 12, 2017 at 10:44 AM, Brian Harrington < >>> autoglasswny@gmail.com> wrote: >>> >>>> add a max to see if u get a hit... >>>> >>>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email >>>> SUMM=3DT&max=3D10] >>>> >>>> On Tue, Dec 12, 2017 at 10:42 AM, Brian Harrington < >>>> autoglasswny@gmail.com> wrote: >>>> >>>>> also... why sort=3D1 but then no order? >>>>> >>>>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUM= M=3DT] >>>>> >>>>> On Tue, Dec 12, 2017 at 10:38 AM, Brian Harrington < >>>>> autoglasswny@gmail.com> wrote: >>>>> >>>>>> emp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailSUMM=3DT] >>>>>> >>>>>> >>>>>> On Tue, Dec 12, 2017 at 10:34 AM, Brian Harrington < >>>>>> autoglasswny@gmail.com> wrote: >>>>>> >>>>>>> have been following briefly but why the "NE_" ??? >>>>>>> >>>>>>> On Tue, Dec 12, 2017 at 8:00 AM, >>>>>>> wrote: >>>>>>> >>>>>>>> Just curiosity=E2=80=A6 try [search db=3Dbases/_temp.db&ne_emailda= ta >>>>>>>> =3DFIND_ALL&_emailSORT=3D1&_emailSUMM=3DT] >>>>>>>> >>>>>>>> - chris >>>>>>>> >>>>>>>> On Dec 12, 2017, at 10:39, Lawrence Banahan >>>>>>>> wrote: >>>>>>>> >>>>>>>> Hi Brian, tht's what I did with remove code down and down until I >>>>>>>> arrived to this issuu, and there are only one column of email data= .... >>>>>>>> The script was working perfectly for 3 years befor switching to 8.= 5 >>>>>>>> >>>>>>>> >>>>>>>> 2017-12-12 8:37 GMT+01:00 Lawrence Banahan : >>>>>>>> >>>>>>>>> My first thought... 5000000 it should be good lol >>>>>>>>> even it shouldn't create a server error... >>>>>>>>> >>>>>>>>> 2017-12-12 0:56 GMT+01:00 Stuart Tremain : >>>>>>>>> >>>>>>>>>> Have you set the *maximum found items* in WebDNA to accomodate >>>>>>>>>> your expected results ? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Kind regards >>>>>>>>>> >>>>>>>>>> Stuart Tremain >>>>>>>>>> Pharoah Lane Software >>>>>>>>>> AUSTRALIA >>>>>>>>>> webdna@idfk.com.au >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On 12 Dec 2017, at 02:10, Lawrence Banahan >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> Since I upgraded to WDna8.5 I have a strange situation. >>>>>>>>>> >>>>>>>>>> I make a search through a db that have about 15 000 entries >>>>>>>>>> >>>>>>>>>> This line works >>>>>>>>>> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL] Total emai= ls >>>>>>>>>> avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text show=3Dt]= nb-av=3D[numfound][/text] >>>>>>>>>> [/search] >>>>>>>>>> >>>>>>>>>> This one makes me a Error 500 >>>>>>>>>> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL&_emailSUMM= =3DT] >>>>>>>>>> Total emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[= text >>>>>>>>>> show=3Dt]nb-av=3D[numfound][/text][/search] >>>>>>>>>> >>>>>>>>>> "Internal Server Error >>>>>>>>>> The server encountered an internal error or misconfiguration and >>>>>>>>>> was unable to complete your request." >>>>>>>>>> >>>>>>>>>> I haven't purchase a licence for 8.5 is that the reason? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Thanks >>>>>>>>>> Lawrence >>>>>>>>>> --------------------------------------------------------- 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 Reportin= g: >>>>>>>>>> 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 Reportin= g: >>>>>>>>>> support@webdna.us >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> --------------------------------------------------------- This >>>>>>>> message is sent to you because you are subscribed to the mailing l= ist >>>>>>>> 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 >>>>>>>> >>>>>>>> >>>>>>>> --------------------------------------------------------- This >>>>>>>> message is sent to you because you are subscribed to the mailing l= ist >>>>>>>> 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 >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> > --------------------------------------------------------- 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.u= s > --001a11427b80e9c20f0560229f8d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Yes this works,
[search db=3Dbases/_temp.db&n= e_emaildatarq=3D[BLANK]&_emailSORT=3D1&_emailsdir=3Das&max=3D10= ]
=C2=A0[showif [numfound]>0]Yahooo![/Showif][/search]<br>
<= br>it is when I add the Summ=3DT that it crash!

Is there a del= ay in the search?

2017-12-12 11:59 GMT+01:00 Brian Harrington <= ;autoglasswny@g= mail.com>:
sorry... removed the summ but not the field name... below correct

=


temp.db= &
neemaildatarq= =3D[BLANK]&emailSORT=3D1&emailsdir=3Das&max=3D10][showif [numfound]>= 0]Yahooo![/Showif][/search]

On Tue, Dec 12, 2017 at 10:57 AM, Brian Harrington <= ;autoglasswny@g= mail.com> wrote:
12 years doing webdna never used a "FIND_ALL" but the first thing I would do is r= emove the summ, then re tab the database... do a copy, re paste on the tabs= in the header!

t= emp.db&neemail= datarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email&max=3D10][showi= f [numfound]>0]Yahooo![/Showif][/search]

On Tue, Dec 12, 2017 at 10:47 AM= , Brian Harrington <autoglasswny@gmail.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">
temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT&max=3D10][showif [numfound]>0]Yahooo![/Showif][/sea= rch]

On Tue, Dec 12, 2017 a= t 10:44 AM, Brian Harrington <autoglasswny@gmail.com> w= rote:
add a max to see i= f u get a hit...

temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT= &max=3D10]

On Tue, Dec 12, 2017 at 10:42 AM, Bri= an Harrington <autoglasswny@gmail.com> wrote:
also... why sort=3D1 but then no = order?

temp.db&neema= ildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT]

On Tue, Dec 12, = 2017 at 10:38 AM, Brian Harrington <autoglasswny@gmail.com> wrote:
emp.db&neemaildatarq=3D[BLANK]&emailSORT= =3D1&emailSUMM= =3DT]

=
On Tue, Dec 12, 2017 at 10:34 AM, Brian Harrin= gton <autoglasswny@gmail.com> wrote:
have been following briefly but why the &q= uot;NE_" ???

On Tue, Dec 12, 2017 at 8:00 AM, <christophe.billiottet@w= ebdna.us> wrote:
Just curiosity= =E2=80=A6 try=C2=A0[search db=3Dbases/_temp.db&ne_emaildata=3DFIND= _ALL&_emailSORT=3D1&_emailSUMM=3DT]

- chris=

On Dec 12, 2017, at 10:39= , Lawrence Banahan <banahan.l@gmail.com> wrote:

Hi B= rian, tht's what I did with remove code down and down until I arrived t= o this issuu, and there are only one column of email data...
The = script was working perfectly for 3 years befor switching to 8.5


20= 17-12-12 8:37 GMT+01:00 Lawrence Banahan <banahan.l@gmail.com>:
= My first thought... 5000000 it should be good lol
even it shouldn&= #39;t create a server error...

2017-12-12 0:56 GMT+01:00 Stuart= Tremain <webdna@idfk.com.au>:
Have you set the maximum found items<= /b> in WebDNA to accomodate your expected results ?



<Screen Shot 2017-12-12 at 10.55.02.png= >



Kind regards

Stua= rt Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au



<= /div>


On 12 Dec 2017, at 02:10, Lawrence Banahan &= lt;banahan.l@gmail= ..com> wrote:

Hi,
Since I upgraded to WDna8.5 = I have a strange situation.

I make a search through a db that = have about 15 000 entries

This line works
[search db=3Dbases/_tem= p.db&ne_emaildata=3DFIND_ALL] Total=C2=A0 emails avant suppr=C3=A9= ssion des d=C3=A9inscriptions=3D[text show=3Dt]nb-av=3D[numfound][/text][/search]

This one makes me a Error 500
[search db=3Dbase= s/_temp.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] Total=C2=A0= emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text show=3Dt]nb-= av=3D[numfound][/text][/search]

"Interna= l Server Error
The server encountered an internal error or mi= sconfiguration and was unable to complete your request."

I haven't purchase a licence for 8.5 is that the reason?
=

Thanks
Lawrence
--------------------------------------------------------- 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@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@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 --001a11427b80e9c20f0560229f8d-- . 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:

Associative lookup style? (1997) Showif, Hideif reverse logic ? (1997) RE: Web*SSL and WebCatalog (1997) Formatting a .txt file (1998) [WebDNA] AC paymethod is missing (2008) emailer setup (1997) SiteGuard Admin Feature ? (1997) WebCat2 beta 11 - new prefs ... (1997) For those of you not on the WebCatalog Beta... (1997) Re:no template caching (1997) Image as submit button (2000) WebCatalog for Postcards ? (1997) I'm having trouble using [url][interpret][math] together in lookup (1997) Yahoo! Auto Response (2000) Size limit for tmpl editor ? (1997) wild question (1998) [GROUPS] followup (1997) WebDNA programmers needed (1998) AuthorizeNet & StoreBuilder (2002) Apple event reply error (-1) (1997)