Re: mySQL numfound
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66667
interpreted = N
texte = Thanks adam.I think I will go with the double search. I would be interested to see howyou put together that paging function though.thanks Brian BoegershausenEndeavotech Advanced Business Solutions LLC.http://www.endeavotech.combrian@endeavotech.com-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of AdamO'ConnorSent: Saturday, April 01, 2006 11:48 AMTo: WebDNA TalkSubject: Re: mySQL numfoundBrian,Sorry was out of town, there are a couple of methods to retrieve thenumfound via MySQL - however they both require more than one search - thatis if you are limiting the main recordset. 1) You can either do anun-restricted search and return all rows thus get a numfound value or 2) Usean alias within your SQL syntax using MySQL's count(*) function.If you need more assistance, I can send you a paging function that resembleswebcats. 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 functionvia 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 toWeb 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:
Thanks adam.I think I will go with the double search. I would be interested to see howyou put together that paging function though.thanks Brian BoegershausenEndeavotech Advanced Business Solutions LLC.http://www.endeavotech.combrian@endeavotech.com-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of AdamO'ConnorSent: Saturday, April 01, 2006 11:48 AMTo: WebDNA TalkSubject: Re: mySQL numfoundBrian,Sorry was out of town, there are a couple of methods to retrieve thenumfound via MySQL - however they both require more than one search - thatis if you are limiting the main recordset. 1) You can either do anun-restricted search and return all rows thus get a numfound value or 2) Usean alias within your SQL syntax using MySQL's count(*) function.If you need more assistance, I can send you a paging function that resembleswebcats. 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 functionvia 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 toWeb 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/
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:
WebCat2 several catalogs? (1997)
[OT] Test (2003)
[Webcat 2]Next (1997)
oops private message leaked into talk list (1997)
Locking up with WebCatalog... (1997)
[Sum] function? (1997)
fieldsumm quandary (2001)
OT Cookie limit (2001)
WebDNA resources (Was: I am sorry...) (2004)
OT: SourceForge (2005)
[HIDEIF] inside [FOUNDITEM] (1997)
Not sending email !!! (2002)
Fwd: Problems with Webcatalog Plug-in (1997)
Frames and WebCat (1997)
WebCatalog f2 Installation (1997)
QuantityPrice computed? (1998)
A quickie question (1997)
Redirect frame targets (1998)
Non-repeating Random Numbers - CORRECTION (2002)
Date Help (2004)