Is the image stored in the database actually a JPEG as specified in your header?

On Wed, Mar 17, 2010 at 5:41 PM, ukuta ken <ukutaken@gmail.com> wrote:
Actually i was doing everything right.
The binary image can be opened in adobe photoshop and on conversion by
leadtools can be displayed by the browser.

So now i have to use curl and do some conversions before display.
Is there any shortcut???

On 3/17/10, ukuta ken <ukutaken@gmail.com> wrote:
> have also done that, still nothing
> <?php
> odbc_exec($connH, "set textsize 131072");
>
> On 3/17/10, ashok+skunkworks@parliaments.info
> <ashok+skunkworks@parliaments.info> wrote:
>> On Wed, Mar 17, 2010 at 11:21 AM, ukuta ken <ukutaken@gmail.com> wrote:
>>> ------------------------------------------
>>> <?php
>>>
>>>    $connH=odbc_pconnect("myDB","me","mypass") or die(odbc_errormsg());
>>>    $result=odbc_exec($connH, "select top 1 image from images where
>>> id='2'");
>>>    if ($result) {
>>>        odbc_longreadlen($result, 131072);
>>>        odbc_binmode($result,ODBC_BINMODE_RETURN);
>>>        $out=odbc_result($result, 1);
>>>    }
>>> ?>
>>>
>>
>>
>> I remember that in older versions of sql server (which was almost a
>> cousin of sybase) you had to set the textsize when retrieving binary
>> data ... otherwise the default textsize returned by the db for blobs
>> and var-binary data types was 32 kilobytes or something like that ...
>>
>> can you set the textsize to a large number before your retreival query
>> and see if it works ? something like 'set textsize 1024000' ?
>> _______________________________________________
>> Skunkworks mailing list
>> Skunkworks@lists.my.co.ke
>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
>> ------------
>> Skunkworks Server donations spreadsheet
>> http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
>> ------------
>> Skunkworks Rules
>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
>> ------------
>> Other services @ http://my.co.ke
>>
>
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke