join problem

[jordan11]

Hi,

I have this select statement,
select o.questionID,p.questionid
from opportunityanswers o inner join physiciananswers p
on o.questionID = p.questionID
and physicianID='128'

I would to use 0.question in my query below

I tried this questionid=rs(o.questionID)

and then tried to use questionid in my asp page

and I keep on getting an error

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

if i run the same query in sql analyser i get the results i want.


Thanks in advance

 

[DotNetGnat]

missing quotes...

questionid=rs("o.questionID")

-DNG

 

[jordan11]

sorry but in my page i did have the quotes around the rs("o.questionID")
but i still get that same error

 

[DotNetGnat]

oops..sorry it should be:

questionid=rs("questionID")

with o

-DNG

 

[DotNetGnat]

ok now got it...try this:

select o.questionID as oQuestionID,p.questionid as pquestionID
from opportunityanswers o inner join physiciananswers p
on o.questionID = p.questionID
and physicianID='128'

now you can do...

questionid=rs("oquestionID") or

questionid=rs("pquestionID")

-DNG

 

[jordan11]

thanks DNG
I found out what the problem was as your suggestion did not work either so i had a closer look at my query.

I had conn.Execute txtsql
and my sql statement=txttsql

that change made it worked


thanks once again