Re: [WebDNA] Error 500 with SUMM=T
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113811
interpreted = N
texte = 1406 > 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 .
Associated Messages, from the most recent to the oldest:
1406 > 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 .
Kenneth Grome
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:
Format question WC Mac f3 (1997)
thread discussion solution (2000)
Where is the bug fix info for 4.0.1? (2000)
IE-caching (1998)
Question about replacing words (1998)
Search in 2 or more catalogs (1997)
Protect vs Authenicate (1997)
Server Freeze (1998)
carriage returns in data (1997)
ALL CAPS converted to All Caps - first letter capitalizedonly (2002)
WebMerchant Process Orders errors (2000)
[WebDNA] Version 7 Config problem (2011)
Seeking Better Display of results... (1997)
Sorting error (1997)
syntax question, not in online refernce (1997)
Showif with an or (2003)
Sandbox scripts (2004)
Server crash (1997)
Emailer Blackmail (1998)
Virtual hosting and webcatNT (1997)