Welcome !
         

 Need help please! Rgding Returning value from Oracle database

Author Message
Averylim

  • Total Posts : 1
  • Scores: 0
  • Reward points : 0
  • Joined: 5/23/2016
  • Status: offline
Need help please! Rgding Returning value from Oracle database Monday, May 23, 2016 9:27 PM (permalink)
0
Hello guys, i will be so grateful if someone could point me in the right direction. >< i am trying to get a SUM of this particular column in my database, connection and everything are already set up, and its working. please advise if i am writing any part of this wrongly
 
Dim rsStrReturn, mstrMaxSum
mstrMaxSum = "SELECT SUM(ticNo)totalTicNo FROM nbs_eventreg WHERE eventdesc='ThisEvent' 
set rsStrReturn = mobjCn.execute mstrMaxSum
 
response.Write(rsStrReturn("totalTicNo")) 
response.end
 
by right i am suppose to get a response value of the total sum of whatever thats inside my ticNo colum right?
 
much appreciated guys!
 
#1
    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 1 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2017 ASPPlayground.NET Forum Version 3.9