- Scores: 0
- Joined: 5/23/2016
Need help please! Rgding Returning value from Oracle database
Monday, May 23, 2016 9:27 PM
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
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!