Thanks.
Dian ~ -----Original Message----- From: David Smart [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 1:45 AM To: [EMAIL PROTECTED] Subject: Re: [ASP] Help! Got a little rounding problem! Dian That's not VB - it's SQL. The database engine is doing both the AVG and the ROUND. The alternative would have been to bring it back to the VBS with all the decimal points then get it into floating point and round it in VBS. I think the ROUND (item, decimals) call is identical in VB, but I'm not totally sure (I use JScript myself). Dave S ----- Original Message ----- From: "Dian Chapman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 09, 2004 4:12 PM Subject: RE: [ASP] Help! Got a little rounding problem! > Cool...thanks! I THOUGHT it would be like that cos' I believe that's > how I've done it in VBA, just not always sure that my VBA codes will > work in a similar manner to VBS. > > REALLY appreciate the help! > > > Dian D. Chapman > Technical Consultant, Instructor > Microsoft MVP & MOS Expert Certified > > Free MS Tutorials: www.mousetrax.com/techtrax Free Word Tips & Tricks > eBook: www.mousetrax.com/books.html Learn VBA the easy way, thru > video! www.mousetrax.com/techcourses.html > > > -----Original Message----- > From: David Smart [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 09, 2004 12:54 AM > To: [EMAIL PROTECTED] > Subject: Re: [ASP] Help! Got a little rounding problem! > > ROUND(AVG(RatingNum),1) > > should do the trick (to 1 decimal), or just > > ROUND(AVG(RatingNum)) > > should give you a whole number. > > Dave S > ----- Original Message ----- > From: "Dian Chapman" <[EMAIL PROTECTED]> > To: "Group - ASP" <[EMAIL PROTECTED]> > Sent: Sunday, May 09, 2004 3:20 PM > Subject: [ASP] Help! Got a little rounding problem! > > > > ROFLMAO! Umm, okay, so I'm not a math person! > > > > You guys gave me the help I needed to realize that I could use AVG > > to get > an > > average for a bunch of numbers, but...there's a bit of a rounding > > problem > I > > didn't realize. > > > > Here's the line I use to get the average from a bunch of article > > rating > > numbers: > > > > averageRS.Open "Select AVG(RatingNum) as AvRating from rating where > > ArticleID = " & Session("varArticleID"), Conn, 1, 3 > > > > It seemed to work great...until more folks entered their ratings. > > Some results end up needing a 11" inch page width to display the > > number!<lol> > > > > Here's a fun example, click the rating button at the bottom of this > article: > > http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=297 > > > > Note the number of stars it says this article has received! > > > > 4.8571428571428571428571428571 > > > > Umm...anyone know how I can modify the code so we're not going nuts here? > > > > TIA... > > > > Dian ~ > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.677 / Virus Database: 439 - Release Date: 5/4/2004 > > > > > > > > > > > > --------------------------------------------------------------------- > > Home : http://groups.yahoo.com/group/active-server-pages > > --------------------------------------------------------------------- > > Post : [EMAIL PROTECTED] > > Subscribe : [EMAIL PROTECTED] > > Unsubscribe: [EMAIL PROTECTED] > > -------------------------------------------------------------------- > > - > > Yahoo! Groups Links > > > > > > > > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.679 / Virus Database: 441 - Release Date: 7/05/2004 > > > > --------------------------------------------------------------------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [EMAIL PROTECTED] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > > > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.677 / Virus Database: 439 - Release Date: 5/4/2004 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.677 / Virus Database: 439 - Release Date: 5/4/2004 > > > > > --------------------------------------------------------------------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [EMAIL PROTECTED] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.679 / Virus Database: 441 - Release Date: 7/05/2004 --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.677 / Virus Database: 439 - Release Date: 5/4/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.677 / Virus Database: 439 - Release Date: 5/4/2004 --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> 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/
