-
ASPDB - HOW TO GET A PICTURE FROM AN ORACLE DATABASE ????
Display Record limit = 50
In my Oracle database, I have a field named PHOTO which contains the photo of the employee.
Here is my code:
------------------------------------------------------------------------------
<%
response.buffer = true
set myDB = server.CreateObject("AspDB.Pro"
myDB.dbDSN="DSN=XXXXX; UID=XXXXXX; PWD=XXXXX;"
response.write "<b><center><font size=5>" & "This is my SQL query" & "</font></center></b><br><BR><BR>"
mydb.dbDBtype="oracle"
myDB.dbSQL="Select * FROM table_name where last_name like 'D%' and photo IS NOT NULL order by last_name"
myDB.dbColor = "Lightyellow,black,Lightyellow,black"
myDB.dbGridTableTag="border=1 cellspacing=3"
myDB.dbMode="grid"
myDB.dbGridDisplayFlds="photo"
mydb.dbNavigationItem="top,bottom,prev,next 4;
myDB.dbBLOB="photo,image/jpeg,browser,0"
myDB.dbUnit =1
mydb.dbButtonAnchor = false
myDB.aspDBPro
%>
------------------------------------------------------------------------------
This is the message I get:
Microsoft VBScript runtime error '800a0007'
Out of memory: 'myDB.aspDBPro'
/travail/sylvie/photo.asp, line 29 error 'ASP 0194'
OnEndPage Failed
/travail/sylvie/photo.asp
An error occurred in the OnEndPage method of an external object.
------------------------------------------------------------------------------
I'm sure that the PHOTO field in the database is not empty. I saw it directly in the database. It seems like it's trying go download the picture but at the end, the cell in the grid named PHOTO contains a square with a red X in it.
When I select fields with text only, as LastName field, it works.
Please anyone help me !!! I've been working on that problem for almost a month.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|