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:
Replacing a Word (1999)
Anyone have a register your domain app? (2000)
pc (1997)
[returnraw] and form variables (1998)
Searching a field and returning the highest value (1997)
Help! WebCat2 bug (1997)
OSX Install error (2000)
Search results problem (2003)
problem with [Format Days_To_Date] (2000)
Emailer tracking (1997)
NT BETA BUG???? (1997)
WebCat2b12 forgets serial # (1997)
Searching multiple Databases (1997)
Stopping a [Loop] in mid-stream ... (1997)
Sku numbers (1997)
Accessing Server Environment Variables (2003)
Dates! (1998)
Banner Ad example (Typhoon) and WebCatalog (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Calling Tom Duke.... (2004)