«

ok. using access and asp, can someone tell me why i would be getting this
error?

script

set admin4 = conn.execute("select count(username) as cnt3 from members2
where username not in (select top 16 username from members2 order by
total_score desc)")

error

Item cannot be found in the collection corresponding to the requested name
or ordinal.

/GIG/Tourney/admin/td_admin.asp, line 11

username and total_score are both in the table. could it be because there
aren't 16 records present yet??

Bam

What does the code on line 11 look like? How are you attempting to get your
count value? You're not doing yourRS("username"), are you?

Does this query work when you copy and paste it into the query window in
Access?

Ray at home


"Jeff" <> wrote in message
news:msqdncK7WLbcBljeRVn-...
> ok. using access and asp, can someone tell me why i would be getting this
> error?
>
> script
>
> set admin4 = conn.execute("select count(username) as cnt3 from members2
> where username not in (select top 16 username from members2 order by
> total_score desc)")
>
> error
>
> Item cannot be found in the collection corresponding to the requested name
> or ordinal.
>
> /GIG/Tourney/admin/td_admin.asp, line 11
>
> username and total_score are both in the table. could it be because there
> aren't 16 records present yet??
>
> Bam
>
>

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:...
> What does the code on line 11 look like?

Line 11 is what I pasted in my post

How are you attempting to get your
> count value? You're not doing yourRS("username"), are you?

i am getting the count value in the beginning if the statement as cnt3
count(username) as cnt3

i entered this into access:

SELECT count(username) AS cnt3
FROM members2
WHERE username not in (select top 16 username from members2 order by
total_score desc)

and i don't get an error. it displays the output as it should.
so the error lies on the asp page somewhere??



>
> Does this query work when you copy and paste it into the query window in
> Access?
>
> Ray at home
>
>
> "Jeff" <> wrote in message
> news:msqdncK7WLbcBljeRVn-...
>> ok. using access and asp, can someone tell me why i would be getting this
>> error?
>>
>> script
>>
>> set admin4 = conn.execute("select count(username) as cnt3 from members2
>> where username not in (select top 16 username from members2 order by
>> total_score desc)")
>>
>> error
>>
>> Item cannot be found in the collection corresponding to the requested
>> name or ordinal.
>>
>> /GIG/Tourney/admin/td_admin.asp, line 11
>>
>> username and total_score are both in the table. could it be because there
>> aren't 16 records present yet??
>>
>> Bam
>>
>>
>
>

ok. i feel like a complete idiot. i figured it out.
should have been admin3 not admin4
thanks anyway

bam


"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:...
> What does the code on line 11 look like? How are you attempting to get
> your count value? You're not doing yourRS("username"), are you?
>
> Does this query work when you copy and paste it into the query window in
> Access?
>
> Ray at home
>
>
> "Jeff" <> wrote in message
> news:msqdncK7WLbcBljeRVn-...
>> ok. using access and asp, can someone tell me why i would be getting this
>> error?
>>
>> script
>>
>> set admin4 = conn.execute("select count(username) as cnt3 from members2
>> where username not in (select top 16 username from members2 order by
>> total_score desc)")
>>
>> error
>>
>> Item cannot be found in the collection corresponding to the requested
>> name or ordinal.
>>
>> /GIG/Tourney/admin/td_admin.asp, line 11
>>
>> username and total_score are both in the table. could it be because there
>> aren't 16 records present yet??
>>
>> Bam
>>
>>
>
>

>> should have been admin3 not admin4
Neither of which were mentioned in you r original post.

Bob Lehmann

"Jeff" <> wrote in message
news:dLidnYSi3eVbKFjeRVn-...
> ok. i feel like a complete idiot. i figured it out.
> should have been admin3 not admin4
> thanks anyway
>
> bam
>
>
> "Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
> message news:...
> > What does the code on line 11 look like? How are you attempting to get
> > your count value? You're not doing yourRS("username"), are you?
> >
> > Does this query work when you copy and paste it into the query window in
> > Access?
> >
> > Ray at home
> >
> >
> > "Jeff" <> wrote in message
> > news:msqdncK7WLbcBljeRVn-...
> >> ok. using access and asp, can someone tell me why i would be getting
this
> >> error?
> >>
> >> script
> >>
> >> set admin4 = conn.execute("select count(username) as cnt3 from members2
> >> where username not in (select top 16 username from members2 order by
> >> total_score desc)")
> >>
> >> error
> >>
> >> Item cannot be found in the collection corresponding to the requested
> >> name or ordinal.
> >>
> >> /GIG/Tourney/admin/td_admin.asp, line 11
> >>
> >> username and total_score are both in the table. could it be because
there
> >> aren't 16 records present yet??
> >>
> >> Bam
> >>
> >>
> >
> >
>
>

No worries. All that matters is that it's fixed.

Ray at work

"Jeff" <> wrote in message
news:dLidnYSi3eVbKFjeRVn-...
> ok. i feel like a complete idiot. i figured it out.
> should have been admin3 not admin4
> thanks anyway
>
> bam