Help in Assigning SQL Values

[Cap2010]

HI,

I want to the value from the below statement

select count(party_id) from Master

assigned to a variable. so that I can
use for do while condition.

Will this do

dim vCount as variant

vCount = cn.Execute ("select count(party_id) from Master&quot

Really will solve much of my problems.

Lad

 

[Vince]

It would make it easier for you if you did the following


Change your code to read


dim vCount as variant
dim oRs as adodb.recordset

'Create an alias that can be referenced in the recordset object returned from the execute statement

set oRs = cn.Execute ("select count(party_id) as Count_PartyID from Master&quot

vCount = oRS.Fields("Count_PartyID&quot.value

Hope this Helps