Hi Isabelle, here is a post that I've maid in august 2001: Dave Shelley explain well that <@totalrows> is only available with search action, so you can do it with another select statement (what is done in search action if you check 'Get Total Rows') like SELECT count(*)...
Hope this help :) Gauthier ----- Original Message ----- From: "ISABELLE" <[EMAIL PROTECTED]> To: "Multiple recipients of list betatest-talk" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 9:36 PM Subject: BetaTalk: TOTALROWS with DirectDBMS... > Hi Everybody > > I try for first time "directDBMS" action, all is ok except that i can't have > the "totalrows" found...<@TOTALROWS> seems to be without effect. > Is it normal? > If yes, how to have it? > > Thanks > > Isabelle > August 2001 POST ----- Original Message ----- From: "gauthier" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Friday, August 10, 2001 8:18 PM Subject: Re: WiTango-Talk: [Help Tango2000] <@TOTALROWS> with DirectDbms? > In fact i want to build a previous-next consultation template without having > large resultsets (for optimising performances). > Is there a difference if I set a max limit or not in database's actions > (search & directdbms) when the query return many records? > > Thanks > > Gauthier > > ----- Original Message ----- > From: "Dave Shelley" <[EMAIL PROTECTED]> > To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> > Sent: Friday, August 10, 2001 6:38 PM > Subject: RE: WiTango-Talk: [Help Tango2000] <@TOTALROWS> with DirectDbms? > > > > Gauthier, > > > > When you check the 'Get Total Rows' box in a search action, it does a > second > > select statement against the database. SELECT COUNT(*) ... > > > > You can do this directly in another direct dbms action. Or, if you don't > > have a row limit set on the results tab of your direct dbms action, then > > <@NUMROWS> will give you the total number of rows returned. > > > > Dave > > > > > ----- Original Message ----- > > > From: "gauthier" <[EMAIL PROTECTED]> > > > To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> > > > Sent: Friday, August 10, 2001 5:22 PM > > > Subject: WiTango-Talk: [Help Tango2000] <@TOTALROWS> with DirectDbms? > > > > > > Hi, > > > A little question about SQL queries: Is there a way to obtain a variable > > > similar to the <@TOTALROWS> MetaTag when using DirectDbms Action instead of > > > a SearchAction? > > > > > > Thanks > > > > > > Gauthier _____________________________________________________________________ GRAND JEU SMS : Pour gagner un NOKIA 7650, envoyez le mot IF au 61321 (prix d'un SMS + 0.35 euro). Un SMS vous dira si vous avez gagni. Rhglement : http://www.ifrance.com/_reloc/sign.sms ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
