freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] TDS wants to show me raw hex via PHP from MSSQL2k
- From: Eddie Johnson <fast_eddie_007 AT yahoo.com>
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k
- Date: Tue, 5 Aug 2003 13:50:22 -0700 (PDT)
Trying to pull an Image field from MSSQL2000 ( i know bad idea fromt the
start...not my choice )
Can get it to echo out as hex characters, but that looks a bit goofy.
It works fine via an ODBC connection. But FreeTDS wants to just show it as is.
Header is set. what am i missing??? I am running it as version 8.0 in the
freetds.conf file
here is my code so far
-- begin code
$sql = " select imLarge from image where cCompanyID = '10CC-EAFH-6E59' and
ititlenum = $id ";
// echo "sql is $sql for now";
$dbh= mssql_connect( $db , $user , $pass );
$dbr = mssql_query( $sql , $dbh );
$row = mssql_fetch_array($dbr) ;
Header( "Content-type: image/jpeg" );
?>
<img src="<? echo $row['imLarge']; ?>" >
-- end code.
so it works fine on ODBC, but not via FreeTDS. Have scoured the net for
someone
who is doing this very silly idea. but no luck. And am getting cross eyed
reading old listing posts. And the searchable archive has been offline for
about 3 days now.
Obi-Wan you are our only hope.....
Thanks,
Eddie
-
[freetds] TDS wants to show me raw hex via PHP from MSSQL2k,
Eddie Johnson, 08/05/2003
-
Re: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k,
James K. Lowden, 08/05/2003
-
Re: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k,
Mario . Tschursch, 08/06/2003
- Re: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k, Mario . Tschursch, 08/06/2003
- Re: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k, Michael Peppler, 08/06/2003
- Re: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k, Eddie Johnson, 08/06/2003
-
Re: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k,
Mario . Tschursch, 08/06/2003
-
Re: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k,
James K. Lowden, 08/05/2003
Archive powered by MHonArc 2.6.24.