response.write field in ms access 2

[stpmtp]

I have an access db I have 3 fields, A, B and C

I have an asp script that goes on Field C

<%if rsget("FieldB") = rsget("FieldA") then response.Write(Recordset1("FieldB")) %>

Field A has all the records, Field B has records that have been entered and In field C you are supposed to see the result of field B if the record exists on Field A.

This works well with only the first record but after that I get nothing. Is there a way to do this?

 

[DotNetGnat]

you mean:

do until rsget.EOF
<%if rsget("FieldB") = rsget("FieldA") then response.Write(Recordset1("FieldB")) %>
rsget.Movenext
Loop

-DNG

 

[stpmtp]

if I had more field would I have to do this in every field?

 

[steven290]

to work with multiple records you need to place this within a loop of some kind ex.

Do While Not rsget.EOF

if rsget("FieldB") = rsget("FieldA") then response.Write(rsget("FieldB"))
'notice i change recordset1 to rsget

rsget.MoveNext
Loop

 

[Sheco]

Are rsget and Recordset1 separate ado recordset objects?

 

[steven290]

too slow ~

 

[DotNetGnat]

have the loop only once...something like this

<%
do until rsget.EOF
response.Write(Recordset1("FieldB"))
response.Write(Recordset1("FieldC"))
response.Write(Recordset1("FieldD"))
rsget.Movenext
Loop
%>

-DNG

 

[stpmtp]

ahhh works very well thank you very, very much

 

[steven290]

not a problem