Re: mySQL numfound
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66662
interpreted = N
texte = Brian, Sorry was out of town, there are a couple of methods to retrieve the numfound via MySQL - however they both require more than one search - that is if you are limiting the main recordset. 1) You can either do an un-restricted search and return all rows thus get a numfound value or 2) Use an alias within your SQL syntax using MySQL's count(*) function. If you need more assistance, I can send you a paging function that resembles webcats. My best advice is to study PHP when developing with MySQL & webcat. Whenever you get held up from webcat's limited SQL functionality, just look at how to accomplish the task via PHP, then model this function via webcat. Hope this helps. Donovan Brooke wrote: > brian@orderbywire.com wrote: > >> Has anyone come across a solutions to display the [numfound] in a mysql >> search result? >> >> 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 and >> not set the LIMIT. >> >> Any thoughts would be appreciated. >> >> Thanks >> Brian > > Brian, > could you post your code. If you are putting a limit on your select > statement, yea, numfound would return your limit. I'm a newb at > SQL but I would think you could execute an SQL native "numfound" > and then reference that. Off the top of my head, Isn't it something > like foundcount? > > I'm sure somone will have better info for you but it would help > us if you posted your code. > > Donovan > > > ------------------------------------------------------------- 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:
Brian, Sorry was out of town, there are a couple of methods to retrieve the numfound via MySQL - however they both require more than one search - that is if you are limiting the main recordset. 1) You can either do an un-restricted search and return all rows thus get a numfound value or 2) Use an alias within your SQL syntax using MySQL's count(*) function. If you need more assistance, I can send you a paging function that resembles webcats. My best advice is to study PHP when developing with MySQL & webcat. Whenever you get held up from webcat's limited SQL functionality, just look at how to accomplish the task via PHP, then model this function via webcat. Hope this helps. Donovan Brooke wrote: > brian@orderbywire.com wrote: > >> Has anyone come across a solutions to display the [numfound] in a mysql >> search result? >> >> 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 and >> not set the LIMIT. >> >> Any thoughts would be appreciated. >> >> Thanks >> Brian > > Brian, > could you post your code. If you are putting a limit on your select > statement, yea, numfound would return your limit. I'm a newb at > SQL but I would think you could execute an SQL native "numfound" > and then reference that. Off the top of my head, Isn't it something > like foundcount? > > I'm sure somone will have better info for you but it would help > us if you posted your code. > > Donovan > > > ------------------------------------------------------------- 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/
Adam O'Connor
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:
Stopping bad HTML propagation ? (1997)
List Name Change (2002)
If search results are blank... (2003)
Date problems-more (1997)
Extended [ConvertChars] (1997)
[WebDNA] How to Combine a search with Webdna and JS (2017)
Limitations on fields? Server is crashing (1997)
Re1000001: Setting up shop (1997)
Summing results of a nested search (2006)
WebCat2b12plugin - [search] is broken ... not! (1997)
problem with [include] and Web*/SSL 3.0.1 (1998)
File Uploads... (1997)
Feature Request [SentenceCase] (2005)
Purchase command error problem (1997)
[UPPERCASE] (1997)
Secure server question (1997)
Summing fields (1997)
Logging purchases (1997)
RE: Languages (1997)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)