Professional Web Applications Themes

Response Buffer Limit Exceeded - Ideas Please! - ASP Database

Hi All, I'm trying to run a simple query from an ASP page. I want the query to select each individual field in a table and compare it to another table. If the value doesn't exist, I want it reported. Here's the code I have to do this check: 'Check to see if there are any assemblies not in the database! strSQL = "select substring(mtoc,2,6) as deadmodel from bos_data where substring(bos_data.mtoc,2,6) not in (select code from tire_matrix) AND plantcode = " & Request.Querystring("pcode") rsAFON.Open strSQL, adoCon if rsAFON.eof = false then do while rsAFON.eof = false response.write("<tr><td colspan=15 bgcolor=000000 class=hilite ...

  1. #1

    Default Response Buffer Limit Exceeded - Ideas Please!

    Hi All,

    I'm trying to run a simple query from an ASP page. I want the query to
    select each individual field in a table and compare it to another table. If
    the value doesn't exist, I want it reported. Here's the code I have to do
    this check:

    'Check to see if there are any assemblies not in the database!
    strSQL = "select substring(mtoc,2,6) as deadmodel from bos_data where
    substring(bos_data.mtoc,2,6) not in (select code from tire_matrix) AND
    plantcode = " & Request.Querystring("pcode")
    rsAFON.Open strSQL, adoCon
    if rsAFON.eof = false then
    do while rsAFON.eof = false
    response.write("<tr><td colspan=15 bgcolor=000000 class=hilite
    align=center>***WARNING *** MODEL TYPE: " & rsAFON("deadmodel") & "IS NOT IN
    THE DATABASE! PLEASE NOTIFY ISD IMMEDIATELY!</td></tr>")
    loop
    end if


    When I run the SQL String in SQL's Query yzer, I get the expected
    results. However, when I run it in an ASP page, I get this error:
    ---------------
    Response object error 'ASP 0251 : 80004005'
    Response Buffer Limit Exceeded
    /ptest.asp, line 0
    Execution of the ASP page caused the Response Buffer to exceed its
    configured limit.
    -------------------
    Does anyone have any ideas? I've also made this into a Stored Procedure as
    well, but I received the same results. I'm running this page on an IIS 6.0
    / Win2k3 Web Edition box. All of my other SQL queries run except this one.
    Does it have anything to do with it doing another select from within the
    statement? If so, is there a better way to write this piece of code?
    Thanks!

    Brian.


    Brian Guest

  2. #2

    Default Re: Response Buffer Limit Exceeded - Ideas Please!

    You have an infinite loop.

    put rsAFON.MoveNext on the line before "loop"


    --
    Mark Schupp
    Head of Development
    Integrity eLearning
    www.ielearning.com


    "Brian Piotrowski" <simcoeparts.com> wrote in message
    news:%phx.gbl... 
    If 
    IN 
    as 
    6.0 
    one. 


    Mark Guest

  3. #3

    Default Re: Response Buffer Limit Exceeded - Ideas Please!

    Hi Mark,

    It worked like a charm. Thanks a lot!

    Brian.

    "Mark Schupp" <com> wrote in message
    news:phx.gbl... 
    > If [/ref]
    do [/ref]
    NOT 
    > as 
    > 6.0 
    > one. 
    >
    >[/ref]


    Brian Guest

Similar Threads

  1. Size Limit Exceeded error when querying ldap
    By tfesenmyer in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: June 23rd, 07:41 PM
  2. Redirection Limit for this URL exceeded????
    By orionMX in forum Macromedia ColdFusion
    Replies: 2
    Last Post: March 30th, 11:14 PM
  3. Implementation Limit exceeded
    By John_Slate@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 3
    Last Post: April 27th, 05:15 PM
  4. Replies: 5
    Last Post: April 12th, 02:24 AM
  5. maximum input buffer length exceeded: 1048576
    By Raquel Marques in forum PERL Miscellaneous
    Replies: 1
    Last Post: September 5th, 05:03 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139