[newbie] name and value properties

[manauz]

Hallo,
I'm looking for which object has name and value properties in a recorset.
That is, it should be a row, is it recorset?
I've looked on http://www.w3schools.com/ado/ado_ref_recordset.asp
but it didn't turn up (nor I dare to make a search on google with 'value'
and 'name' terms

thanks!
m.

 

[Ray at]

ADODB Parameter? ADODB Property?

What are you trying to find out or do?

Ray at work

 

[Mark Schupp]

field object as in

rsdata.fields.item("colname").name
rsdata.fields.item("colname").value

usually abreviated to

rsdata("colname").name
rsdata("colname").value

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
(e-mail address removed)
http://www.ielearning.com
714.637.9480 x17

 

[manauz]

What are you trying to find out or do?

I'm trying to print a specific row... From Mark's explanation, if I would
print values from row 7 of a DB, I'd write:

rs.MoveFirst
rs.Move(7)
Response.Write(rs("name").value & " " & rs("phone").value)

(name and phone are field names)

thanks();
m.

 

[Ray at]

What's the reason that you'd jump to the sevent record like that? How do
you know it's the seventh that you're after? Can't you alter your query to
just grab whatever data is currently in your 7th record?

rs.fields.item("name").value is preferred, arguably anyway.

Ray at home