String Count - Dev Shed

Dev Shed Forums Sponsor:

March 11th, 2003, 09:26 AM

sanj

Contributing User

Join Date: Mar 2003

Posts: 133

Time spent in forums: 21 h 18 m 21 sec
Reputation Power: 11

String Count

Hi,

Is there something wrong with this statement?

SELECT COUNT(applod.CAT) AS CATSR FROM applod WHERE applod.CAT LIKE '%SR%'

This colum has various values such as 1, 2, SR all I want is the number of records that have the value SR in them.

Also are you able to make calulations to recordsets, for example

producta = 20
productb = 30
productc =40

((Sum (producta) + sum (productb) + sum (productc)) / (Sum (productc)))

to give me a percentage?

Regards,

Sanjay

March 21st, 2003, 12:40 AM

mohecan

Contributing User

Join Date: Feb 2003

Location: Melbourne, Australia

Posts: 212

Time spent in forums: < 1 sec
Reputation Power: 11

Try the following

Code:

<%
Dim Checkvalue
CheckValue="SR"
strquery="SELECT COUNT(applod.CAT) AS CATSR FROM applod WHERE applod.CAT=" & Checkvalue
%>

As for the maths on your results, you should be able to write ASP code via loops etc to add up your values, divide them, multiply them etc.

__________________
How can I soar like an eagle when
I'm flying with turkey's?

Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > String Count

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump