Strange Error Message (Help!)

Results 1 to 2 of 2

Thread: Strange Error Message (Help!)

  1. #1
    Join Date
    Dec 1969

    Default Strange Error Message (Help!)

    I keep getting this error meassage<BR><BR>Response object error &#039;ASP 0185 : 8002000e&#039; <BR><BR>Missing Default Property <BR><BR>? <BR><BR>A default property was not found for the object<BR><BR><BR>when I try running the following code wich reads in a value from a form and then searches through a database returning all rows with a match. Can anyone help<BR><BR>thanks Peter<BR><BR><BR>CODE:<BR>Dim conn,StringToConvert,UpperCaseString,RSSharename<B R><BR>StringToConvert = Request.Form ("Epic")<BR>UpperCaseString = Ucase(StringToConvert)<BR><BR>response.write("<BR> " & UpperCaseString & "<BR>")<BR><BR>set conn = server.CreateObject ("adodb.connection")<BR> conn.Open "Spam", "SPAMWeb", "password"<BR> <BR><BR>set RSSharename = conn.Execute("select * from companyname where " _<BR> & "Epic = &#039;" & UpperCaseString & "&#039;")<BR>If not RSSharename.EOF Then<BR>Response.Write(RSSharename) %&#062;<BR><BR>&#060;P&#062; The following Shares were found &#060;/P&#062;<BR>&#060;% Response.Write(RSSharename) %&#062;<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Inget konstigt alls

    This has to do with the statement Response.Write(RSSharename) and what is indicated is that a recordset does not have a default property. You need to refer to a field in the recordset, either by name or by index. The names are the same as the columns in your select query. Assuming that the table contains the columns Name and adress it could look like<BR><BR>If not RSSharename.EOF Then<BR> Response.Write "Company name: " & RSSharename("Name") <BR> Response.write "Adress : " & RSSharename("Adress") <BR>end if<BR><BR>There is also a possibilty to loop through all fields in the recordset<BR><BR> for each RSfield in RSSharename.fields<BR> Response.write "Field name :" &<BR> Response.write "Field value:" & RSfield.value<BR> next<BR><BR><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