Re: mySQL numfound
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66634
interpreted = N
texte = > 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.Sounds like a bug to me. > The only thing I can think to do is write the search twice on the page and> not set the LIMIT.That's how I would do it. I know it's frustrating to perform two searches simply to get around a bug like this, but what else can you do? Not much I guess ...Sincerely, Kenneth Grome owner@kengrome.comkengrome@gmail.comwww.kengrome.comOn Fri, 31 Mar 2006 00:53:58 -0500, brian@orderbywire.com wrote:> Has anyone come across a solutions to display the [numfound] in a mysql> search result?> > > 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 and> 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:
> 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.Sounds like a bug to me. > The only thing I can think to do is write the search twice on the page and> not set the LIMIT.That's how I would do it. I know it's frustrating to perform two searches simply to get around a bug like this, but what else can you do? Not much I guess ...Sincerely, Kenneth Grome owner@kengrome.comkengrome@gmail.comwww.kengrome.comOn Fri, 31 Mar 2006 00:53:58 -0500, brian@orderbywire.com wrote:> Has anyone come across a solutions to display the [numfound] in a mysql> search result?> > > 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 and> 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/
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:
FREE Web Server Monitor FREE (1997)
Problems searching from a FORM (1997)
[delete] problem (1997)
OT- AS/400 and Macs (2003)
Emailer help....! (1997)
[WebDNA] Topic... (2004)
WebCat and image maps (1997)
Database of Tax Rates? (1997)
LOG IN LOG OUT (1997)
WebCatalog for Postcards ? (1997)
authenticate and password (1998)
Stinkin' [Referrer] (1998)
Is it possible to pause or wait a process (2000)
[WebDNA] Installation on windows 2008 server (2010)
SiteEdit NewFile.html ? (1997)
[Q] Novice's question (1997)
using showpage and showcart commands (1996)
Protect and Serve (1999)
Searching (2004)
PSC recommends what date format yr 2000??? (1997)