Assigning value to Record Set

Results 1 to 3 of 3

Thread: Assigning value to Record Set

  1. #1
    Pankaj Jain Guest

    Default Assigning value to Record Set

    i&#039;m getting this error<BR><BR>Microsoft VBScript runtime error &#039;800a01b6&#039; <BR><BR>Object doesn&#039;t support this property or method: &#039;rs&#039; <BR><BR>/sun_try2.asp, line 20 <BR><BR>i this line, how else can i asign a value to record set<BR><BR>i.e Set rs("area_name")=temp<BR> <BR><BR><BR>set con=Server.CreateObject("ADODB.Connection")<BR> strConnect<BR> sql_select="select * from instruments"<BR> set rs=con.execute (sql_select)<BR><BR> set temp=rs("area_name")<BR><BR> while not rs.eof<BR><BR> if rs("area_name")="!" then<BR> Set rs("area_name")=temp<BR> else <BR> temp=rs("area_name")<BR>

  2. #2
    Reggie Guest

    Default RE: Assigning value to Record Set

    Only use "set" when you are setting up your recordset: &#060;%set rs=con.execute (sql_select)%&#062; Delete the word set in these 2 lines of code: &#060;%set temp=rs("area_name")%&#062; or &#060;%Set rs("area_name")=temp%&#062;

  3. #3
    Pankaj Jain Guest

    Default RE: Assigning value to Record Set

    thnx, i knew i shouldn&#039;t but now i&#039;m getting this error<BR><BR>ADODB.Field error &#039;800a0cb3&#039; <BR><BR>The operation requested by the application is not supported by the provider. <BR><BR>/sun_try.asp, line 20 <BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts