Re: Getting a a Binary Error

From: Steve Easton (admin_at_95isalive.com)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 14:28:09 -0500

Don't store the image in sql, store a "link to the image" in sql and have the image in an outside
location. 

-- 
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
.......................with a computer
"Jim Warren" <jwarrenatl25@comcast.net> wrote in message
news:eBTNZo9AFHA.2016@TK2MSFTNGP15.phx.gbl...
> I front Page capaiable of reading a jpg file. I have a created a asp page in
> front page that will pull data from a external SQL database  Picture Name
> Description and Picture(its the actual jpg file stored in SQL)
>
> The ASP page runs fine I get Name Description  but under Picture I get
> #Binary# no Image display I need the actual image to be inserted
>
> Thanks
>
>

Relevant Pages

  • Re: Problems with querying date field
    ... >> If you want to put a database somewhere for safekeeping, ... database - SQL isn't about persistence, ... says nothing about the physical storage media to be used. ... store data on a tape, or a disk, or a CD, or a file, or any physical ...
    (microsoft.public.sqlserver.programming)
  • Re: Need Aggregate Query Help!!!
    ... else than what I am suggesting. ... I was using Access SQL with JET backend. ... (SELECT EmpName, Store, SUM(Qty) ... GROUP BY EmpName, Store) as B ...
    (microsoft.public.access.queries)
  • Re: Problem with PR_ENTRY_ID and uniqueness
    ... have to define a huge column width for SQL column. ... two pieces and store each independently. ... intend to save more than one Exchange Server Store ... One last thing about Exchange Re-Using EntryIDs. ...
    (microsoft.public.win32.programmer.messaging)
  • Re: Current System as Global Variable
    ... > Yeh I can do this in SQL like in Oracle I can have the following SQL> select * from Table where DateCol=sysdate> ... > but the problem is that my ETL takes around 5 hrs to load the data into the> warehouse and I have to schedule the ETL at 11:00 pm. So if I use the sysdate> in SQL queries then in one SQLExecute Step I would have different date and in> the that might execute after midnight the sysdate would return a diferent> value. ... Thats why I want to store the cuurent system date> in the global variable at start of the ETL and then use that value for all> the steps. ... I don't know Oracle, but in T-SQL I would just>> do something like- ...
    (microsoft.public.sqlserver.dts)
  • Re: How can I transfer Session info to a different domain on same server?
    ... Using a SQL Server, store your to-be-preserved values to a record in a ... parameterize the URL or redirect over to the other server. ... same code base for every store using host headers to determine which data ... session variables that contain sensitive data that I don't want to pass ...
    (microsoft.public.dotnet.framework.aspnet)