Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Getting SUM() value from SQL function


Message #1 by "Young, Ashley" <Ashley.Young@c...> on Fri, 23 Aug 2002 15:42:11 -0400
I'm sure there is a very simple answer to this question, but I can't figure
out what to do.
I want to write an SQL statement like this:

sSQL = "Select SUM(MeritExempt2000) from survey_information where NOT
MeritExempt2000=''",connection,3
connection.execute(sSQL)

How in the world do I get the actual value the SQL statement returns into
the ASP page?

Any help is greatly appreciated.
--Ashley

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

  Return to Index