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.
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.