|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
SQL server fields access problem
The error is:
ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal. /Projecto/teste/Default_Teste.asp, line 36 ----------------------------------------------------------------- the code is: ................. Set rs = Lig.Execute(SQLstm) while not rs.EOF Response.Write "<TR>" Response.Write "<TD>" Response.Write rs.Fields ("NUSER") --->>(line 36) Response.Write "</TD>" Response.Write "<TR>" wend ........ ------------------------------------------- those fields are there and have some data in it.
__________________
atferraz |
|
#2
|
|||
|
|||
|
Usually this means the column name you specified in your response.write statement is incorrect.
|
|
#3
|
|||
|
|||
|
Problem solved. rs.MoveNext was missing
Thanks |
|
#4
|
|||
|
|||
|
that's not a good one to forget
![]() |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > SQL server fields access problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|