I don't know if this problem is on the display side (where getrows gettext would actually be helpful) or on the database side (where a properly placed index would save the day).
ASIF: Is it time to execute the query or display the results? Do you display a lot of results? Or are you timing out? Jeff On Wed, 11 Aug 2004 01:50:03 -0400, Charles M. Carroll <[EMAIL PROTECTED]> wrote: > You really really really need to read: > http://www.learnasp.com/advicoe/whygetrows.asp > as well. > > http://www.learnasp.com/learn/speedscale.asp > has good advice as well. > > Looping through Recordsets is a bad idea. GetRows and GetString remove > recordsets from the picture. > > At 01:39 AM 8/11/2004, you wrote: > >--- asif mehdi <[EMAIL PROTECTED]> wrote: > >hi > > > > > >please use the combanation table and display time > >brack your requirement > >for example > > > >table a,b,c > > > >ssql"select a.field,b.field,c.field from a,b,c > > where a.field=b.field and c.field=b.field" > > > >open rs,ssql > > > >alter query use the loop and display you information > > > > ---------- > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.735 / Virus Database: 489 - Release Date: 8/6/2004 > > [Non-text portions of this message have been removed] > > > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
