recordset increment

[jestin]

hi can u help me i am trying to incremnt the recordset value with 1.



the asp code below

[HTML]dim selautono,rsaut on, autonobr
rsauton= server.CreateOb ject("ADODB.Rec ordset")

selautono="SELE CT ACPADMIN.Tbl_Re questInfo.reqid FROM ACPADMIN.Tbl_Re questInfo WHERE ACPADMIN.Tbl_Re questInfo.reqid =(SELECT MAX(ACPADMIN.Tb l_RequestInfo.r eqid) FROM ACPADMIN.Tbl_Re questInfo)"
set rsauton=MMToCon n.execute(selau tono)
if rsauton.eof then
autonobr= "1"

else

autonobr = rsauton("reqid" ) + 1

rsauton.close
end if[/HTML]

the code showing as Type mismatch

if u have any solution plz

[AricC]

If your trying to increment the recordset why are you just saying +1 or say Recordset.MoveN ext to fetch the next record if need be set an integer variable for your count.

[idsanjeev]

hi jestin
I think your problem in data declaration in table and entry in form if field is declare as integer then why u inputed as a string at line no. 7
thanks
jha

[jhardman]

so which line is giving the error?

Jared