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. Wehave been considering setting up a MySQL server and it was thought that wewould have little reworking on our current WebCat/MSSQL code.Beginning to second guess that.AJMOn 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. Wehave been considering setting up a MySQL server and it was thought that wewould have little reworking on our current WebCat/MSSQL code.Beginning to second guess that.AJMOn 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:
how to use WebCat w. SSL & CyberCash (1998)
How about the Pascal approach? (2004)
WebDNA vs SQL ? (2002)
Some Advise needed (1997)
Searching for words equal to A or equal to B (1999)
[WebDNA] Installation problems for IIS 6 (2010)
verify online (1997)
Setting up the server (1997)
Looking up two prices in database? (1997)
Email (1998)
PSC recommends what date format yr 2000??? (1997)
How long does a cart last? (2002)
A little syntax help (1997)
RE: Nesting [ListFiles] (1998)
Country & Ship-to address & other fields ? (1997)
Conference? Heres my sniplete contribution! (1998)
Looking for a Manual (1997)
WebCatalog for guestbook ? (1997)
PCS Frames (1997)
Looping control (1997)