ADO Select statement clobbers html

Discussion in 'HTML / PHP / JavaScript / CSS' started by bjinecs, Nov 16, 2016.

  1. I'm using ADO and MS Access. It seems that as I add to the number of fields that I evaluate, there is a point where I exceed some buffer and I clobber a portion of the html; starting at the end of the html.
    Does anyone know of this problem? Is there some space I should be initializing or limiting?

    Here is an example:

    $first=$DataRs["first"];
    $last=$DataRs["last"];
    $initial=$DataRs["initial"];
    $ss=$DataRs["ss"];
    $address=$DataRs["address"];
    $city=$DataRs["city"];
    $state=$DataRs["state"];
    $zip=$DataRs["zip"];
    $email=$DataRs["email"];
    echo "<br>2. sql = ".$email;
    $phone=format_phone_us($DataRs["phone"]);
    $license=$DataRs["license"];
    $rCity1=$DataRs["rCity1"];
    $rPhone4=format_phone_us($DataRs["rPhone4"]);
    $statement=$DataRs["statement"];

    About half the html gets wiped out.
    If I remove the line - $rCity1=$DataRs["rCity1"]; (third from bottom), the html survives.
    I get slightly different results when I remove different lines. I'm sure something is getting clobbered.
     
  2. I just saw mjp',s comment on my other thread, and I agree I should be using mysql.
    I'm trying to figure out a reasonable migration from ms access and not doing well. I'm migrating a classic asp site.
    I have seen some size parameters in the ADO manual, but don't have it figured out yet.
     

Share This Page