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:

WebCatalog2 Feature Feedback (1996) WebCatalog on Linux (2000) [WebDNA] Is [math] on a number with too many digits the only way that I can get scientific notation out of webdna? (2011) Price and Formula.db (2002) WebCat2: Items xx to xx shown, etc. (1997) Frames and WebCat (1997) OFF-TOPIC: Check www.godaddy.com for me ... (2003) [ConvertChars] problem (1997) Re:Can this be done? (1997) RE: 2nd WebCatalog2 Feature Request (1996) Problem (1997) syntax question, not in online refernce (1997) How Many SKU's is enough? (1997) New public beta available (1997) Giving out error pages (1997) Search/sort in URL Was: GuestBook example (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) PIXO support (1997) Affiliate Marketing Question #2 (1998) WebCat2b13MacPlugIn - [showif][search][/showif] (1997)