End of line of a recordset

[ani4]

Hi

I am trying to detect the end of line of a record of a recordset, is it possible and how....

is there a keyword EOL like the EOF one for the end of file of a recordset ?

thanks

damien

 

[codestorm]

Not sure why you'd want to unless you're trying to cycle dynamically thru the fields (which can be done much easier).

However if you really want to do something like that I imagine you'd convert the recordset to a string (GetString in ADO) and look for you row delimiter chars .. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[ani4]

I am not converted the recordset in a string, I cycle effectively dynamically trought the different field, it s simple to detect the end of the recordset (EOF) but not the end of line. In fact I have a function wich created textbox, the default value of those one are the different information contain in the recordset.
The function works with a recordset , i cycle trought it and create the différent textbox. I want to add this line , or somethings like that,to it but i don t know why, here is the function :

<% Function mkedittext(rsobj)
Dim objprop
Dim strT
dim val
dim test

if (rsobj.EOF) then
rsobj.Movefirst
end if

cpt=0
val= rsobj.fields(cpt)

while not rsobj.EOF

while not rsobj.EOL

strT=strT & &quot;<input type=text name=texte&quot;&cpt&&quot; value=&quot;&val&&quot;>&quot;
cpt=cpt+1
val= rsobj.fields(cpt)

WEND

rsobj.moveNext

Wend
mkedittext = strT
End Function

-----------------------------------------------------------
many thanks

damien

 

[codestorm]

sounds like you want rsobj.fields.count

while cpt < rsobj.fields.count codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[onpnt]

to detect the end of a recordset use this movelast, like this

rsobj.MoveLast

hope that helps. I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.

 

[ani4]

Ok it s allright with &quot;while cpt < rsobj.fields.count &quot;
I havent thought to that, many thanks


Thanks for all

damien