Re: mySQL numfound
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66645
interpreted = N
texte = Hi Brian You could use a sql statement like: SELECT yourfield, count(yourfield) as myalias FROM test WHERE myfield =3D 1 Then you can reffer to the total count by using the [myalias]. Of course= the count returns the found records within the select statement. Thus i= f you limit the select statement with the WHERE clause it will return th= e numfound of this statement. Nitai -- eContentPark - Enterprise Asset Management System eServices - The complete SupportSuite eSurvey - Online Questionnaire made easy Redakto CMS - Content Management that simply works ComputerOil=AE AG Neugutstrasse 66 8600 D=FCbendorf / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com From: brian@orderbywire.com To: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] Sent: Fri, 31 Mar 2006 07:53:58 +0200 Subject: mySQL numfound Has anyone come across a solutions to display the [numfound] in a mysql search result=3F The [numfound] tag only shows the LIMIT in the mysql search content. If = you put a numfound tag in a WebDNA search, it shows the number found in the = DB, not the MAX in the search context. To properly set up my PREVIOUS & NEXT buttons, I need the know the total number of records returned in the search. The only thing I can think to do is write the search twice on the page a= nd not set the LIMIT. Any thoughts would be appreciated. Thanks Brian Brian Boegershausen Endeavotech Advanced Business Solutions LLC. http://www.endeavotech.com brian@endeavotech.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Brian You could use a sql statement like: SELECT yourfield, count(yourfield) as myalias FROM test WHERE myfield =3D 1 Then you can reffer to the total count by using the [myalias]. Of course= the count returns the found records within the select statement. Thus i= f you limit the select statement with the WHERE clause it will return th= e numfound of this statement. Nitai -- eContentPark - Enterprise Asset Management System eServices - The complete SupportSuite eSurvey - Online Questionnaire made easy Redakto CMS - Content Management that simply works ComputerOil=AE AG Neugutstrasse 66 8600 D=FCbendorf / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com From: brian@orderbywire.com To: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] Sent: Fri, 31 Mar 2006 07:53:58 +0200 Subject: mySQL numfound Has anyone come across a solutions to display the [numfound] in a mysql search result=3F The [numfound] tag only shows the LIMIT in the mysql search content. If = you put a numfound tag in a WebDNA search, it shows the number found in the = DB, not the MAX in the search context. To properly set up my PREVIOUS & NEXT buttons, I need the know the total number of records returned in the search. The only thing I can think to do is write the search twice on the page a= nd not set the LIMIT. Any thoughts would be appreciated. Thanks Brian Brian Boegershausen Endeavotech Advanced Business Solutions LLC. http://www.endeavotech.com brian@endeavotech.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
nitai@computeroil.com
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:
Search Engine bots (2002)
webcat- multiple selection in input field (1997)
send mail problem? (1997)
FAX orders (1996)
WebCat2b12 CGI Mac - [shownext] problem (1997)
[WebDNA] WebDNA app (2013)
New Webcatalog for Mac (1997)
payflowpro problem (2003)
How to add product size choices to form? (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
MacFinder -- a new WebDNA web site (1998)
Create Folder Question... (2000)
Browser Problem?!? NN 4.0+ and Browser Info.txt? (1997)
Email Not Being Sent (2004)
2.0Beta Command Ref (can't find this instruction) (1997)
default value from Lookup (was Grant, please help me) (1997)
[SearchString] problem with [search] context (1997)
PSC recommends what date format yr 2000??? (1997)
Dynamic Lists (2005)
WebCat2b15MacPlugin - showing [math] (1997)