Re: mySQL numfound
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66668
interpreted = N
texte = Interesting that Numfound works perfectly with MSSQL through an ODBC. We have been considering setting up a MySQL server and it was thought that we would have little reworking on our current WebCat/MSSQL code. Beginning to second guess that. AJM On 4/1/06 5:17 PM, "brian@orderbywire.com"
wrote: > Thanks adam. > I think I will go with the double search. I would be interested to see how > you put together that paging function though. > > thanks > > > Brian Boegershausen > Endeavotech Advanced Business Solutions LLC. > http://www.endeavotech.com > brian@endeavotech.com > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Adam > O'Connor > Sent: Saturday, April 01, 2006 11:48 AM > To: WebDNA Talk > Subject: Re: mySQL numfound > > 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/ > > > > > > ------------------------------------------------------------- > 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/ -- Alex J McCombie ~ Alex@Adventureskies.com p:315~233~9403 Adventure Skies Interactive (ASI) "You can find it all under Adventure Skies" ------------------------------------------------------------- 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:
Interesting that Numfound works perfectly with MSSQL through an ODBC. We have been considering setting up a MySQL server and it was thought that we would have little reworking on our current WebCat/MSSQL code. Beginning to second guess that. AJM On 4/1/06 5:17 PM, "brian@orderbywire.com" wrote: > Thanks adam. > I think I will go with the double search. I would be interested to see how > you put together that paging function though. > > thanks > > > Brian Boegershausen > Endeavotech Advanced Business Solutions LLC. > http://www.endeavotech.com > brian@endeavotech.com > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Adam > O'Connor > Sent: Saturday, April 01, 2006 11:48 AM > To: WebDNA Talk > Subject: Re: mySQL numfound > > 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/ > > > > > > ------------------------------------------------------------- > 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/ -- Alex J McCombie ~ Alex@Adventureskies.com p:315~233~9403 Adventure Skies Interactive (ASI) "You can find it all under Adventure Skies" ------------------------------------------------------------- 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/
Alex McCombie
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:
Ok here is a question? (1997)
search vs lookup (1998)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
WebDNA Writer Needed (1997)
Username/Password with [Protect] (2000)
Webcat Crashing Error 1701 (2000)
Duplicate Carts (2000)
Text data with spaces in them... (1997)
Re2: frames & carts (1997)
SSL (1998)
Summing fields (1997)
What is the maximum record length? (1998)
WebCat name recognition (was MacFinder -- a new WebDNA website) (1998)
Online docs errata (2000)
email messages (1997)
Sort Order on a page search (1997)
Webcatalog error, Plug-in for Webstar (1996)
Database Field Additions (2000)
using showpage and showcart commands (1996)
WebCat2.0 [format thousands .0f] no go (1997)