Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Help-Simple asp statement(newbie)[?]		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

neerajdeo
Starting Member

USA
33 Posts
Posted - 27 June 2001 :  21:55:43  Show Profile  Visit neerajdeo's Homepage  Send neerajdeo a Yahoo! Message
Hello

I want to get the result of the following query

The query = "Select COUNT(Some_Column) FROM Tablename"

Set rs = oConn.Execute(query)

Once this is done how do I get the value returned by the query. I want to store it in some variable

Thanks for all the help

Neeraj

Doug G
Support Moderator

USA
6493 Posts
Posted - 27 June 2001 :  22:32:29  Show Profile 

...
set rs=oConn.Execute("Select Count(*) as TheCount from Table")
...
nVar = rs("TheCount")
...



======
Doug G
======
Go to Top of Page

neerajdeo
Starting Member

USA
33 Posts
Posted - 27 June 2001 :  22:37:17  Show Profile  Visit neerajdeo's Homepage  Send neerajdeo a Yahoo! Message
Thanks a lot

You are a lifesaver
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.01 seconds. Powered By: Snitz Forums 2000 Version 3.4.07