Jump to content

dieterm

New Members
  • Posts

    8
  • Joined

  • Last visited

Posts posted by dieterm

  1. HI,

     

    I've upgraded from PHP version 5.2 to PHP version 5.4 and are not able to load / find mssql extension ?

     

    How do I use MSSQL in version 5.4 ??

     

    Is MSSQL not supported in this version or am I (hopingly) missing something ???

     

    Regards

    Dieter

  2. Hi,

     

    I have pdf files strored in a database. When I try to display the pdf file from the database, I can see that the field is truncated.

    How do I correct this ?

     

    Here is some code:

     

          $STH = $DBH->prepare("Select blobFile  from tblDoctors");

          $STH->execute($data);

      echo $STH->queryString."<p>";

        $counter = 1;

      $STH->setFetchMode(PDO::FETCH_ASSOC);   

      while($rt = $STH->fetch()) { 

     

            // Print headers

                    header("Content-Type: application/pdf");

                  //header("Content-Length: ". $rt['size']);

                    header("Content-Disposition: attachment; filename=ampathreports.pdf");

     

                    // Print data

     

     

                    echo $rt['blobFile'];

                }

     

    I've tried to cast the varbinary file to text but get an error that his type of casting is not allowed

     

    Any help much appreciated....

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.