[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

RecordCount and Math Operations in ASP

Posted on 2005-05-04
3
Medium Priority
?
246 Views
Last Modified: 2008-03-06
Dear Experts,

I hardcoded a number (Total) to subtract the recordcount from. Now, I want to use a number from a field instead so we can just change the total in the database instead of using a hardcoded number like I am using here...

<%
dim Total
Total = 101              (I NEED TO MAKE 101 READ FROM A FIELD VALUE (rs.QTY) INSTEAD)
Response.Write "" & rs.RecordCount%>
 
<%Response.Write "" & CStr(Total -  rs.RecordCount)%>       (I TRIED RS.QTY HERE IT DIDNT WORK..)

Thanks Friends~
0
Comment
Question by:butter_fly
3 Comments
 
LVL 15

Expert Comment

by:babuno5
ID: 13928700
<%
dim Total
Total = 101              (I NEED TO MAKE 101 READ FROM A FIELD VALUE (rs.QTY) INSTEAD)
Response.Write "" & rs.RecordCount%>
 
<%Response.Write "" & CStr(Cint(Total) -  Cint(rs.RecordCount))%>
0
 
LVL 15

Accepted Solution

by:
joeposter649 earned 800 total points
ID: 13928728
It sound's like you want Total = rs("QTY").
0
 

Author Comment

by:butter_fly
ID: 13928801
That was it. I feel like a simpleton. haha =) Thank you.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month19 days, 9 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question