How To Get A Blob In & Out
I figured out yesterday how to get a blob in, then found an easier way (basically put them all in access then import them into sql).
My problem is getting them out. I dont care if its ASP, PHP or what, but I dont know exactly how I would go about getting it.
I have 2 fields in the database, one is the blob data, and the other is just a name, so I'll be selecting on that, and then displaying its corresponding blob data (tif files).
How would I go about doing this? I've never done blobs, I've normally just done an echo $variable type of thing for string and integers and such.
View Replies
ADVERTISEMENT
Just wondering if any one can tell me why on my machine in Inetpub, when I
want to display data from a blob column, I get data that is like =
"4�D�6�5�7�3�7�3�6", using Response.BinaryWrite. My ado version is 2.8, does
it have some thing to do with missing some thing?
View Replies
View Related
I have stored a .gif and jpeg file in the database as the BLOB object.
Now I am trying to create a report which displays that gif file along with another information.
Is there a way I can display the BLOB objects on the page without having to use any crystal report tool or anything ?
View Replies
View Related
I need some help with ADO types. I use an stored procedure to insert records in a table. One of columns needed is a Blob type (subtype Text). In adition I use ADODB.command configured as I show:
...
oProcedure.Parameters.Append oProcedure.CreateParameter("Description", adLongVarChar, adParamInput, 1234567, description)
...
But it doesn't work well. After call, the table shows something like binary data.
I'd tried to use other ADO types like adVarChar, adVarWChar, adLongVarBinary,... with same result or type errors.
View Replies
View Related
I'm searching some code samples that using blob data type with asp.
View Replies
View Related
I am feeling it tough to retreive a image(blob) from oracle to asp.
I am getting an unspecified error while running the select query.
Could anyone please let me know how to retreive a blob from oracle 9i to ASP.
View Replies
View Related
I have problem to insert a record contains a blob field . Everything fine except the blod field . Platform :VStudio 2003, database :Firebird.net 1.5
View Replies
View Related
anyone know of an application that integrates with Dreamweaver to allow me to work with blob images from a SQL database and put them in an ASP.NET page?
View Replies
View Related
Im trying to display a default image on my asp page that pulls data from a sql server database but i can't get the default image to display. I get error messages saying type mismatch everytime on line 25... Code:
View Replies
View Related
I have stored a Blob (jpg) in mySQL, I now want to retrieve it and paste it on a page, What do I do?
View Replies
View Related
How would a guy go about inserting BLOB files into an Oracle database? My company wants me to put logos in a database, and then depending on the client logging in, display a certain image. My boss wants an interface to allow for us to upload them to the database, also.
I personally think just dropping them into a centralized directory and then storing the path, or the image name in a char or varchar field would make more sense, but. Can someone help me with this, or give me any ideas? I've floated the idea to him to buy a third-party component to facilitate the upload, but he's not really appreciative of that idea.
What about .NET? From what I understand, it has very good file upload capabilities. I already have the framework installed on our server, so I should be able to use it if needed. Would that be a better route to go?
View Replies
View Related
I am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
View Replies
View Related
I don't know how to upload word doc, images and other files into Oracle Blob fields with binary format.
I tried with the following code, normally it's inserting, suppose if i try to convery binary. Code:
View Replies
View Related
Has anyone else found a memory leak using ADO streams to access binary data held in a database. I have searched through this forum and have not come across anyone else, so maybe it is just me.
The scenario is as follows:
Windows 2000 SP3
MDAC 2.7 SP1
IIS5
MySQL 3.23
MyODBC 2.50
If I query the database and do a response.binarywrite everything works fine and no memory leak. eg. response.binarywrite myrecordset("blobfield")
If I read the very same BLOB field into a ADOstream I then get a memory leak in DLLHOST.EXE of how big that binary field was. ie If the picture is 140k in size DLLHOST.EXE increases its memory size by 140k.
This keeps on happening until DLLHOST.EXE is something like 250 MBytes in size at which point it stops working. Quick restart of the IIS Web service and I get all my memory back.
The command I am using to get the data into the ADOstream is picturestream.write myrecordset("blobfield")
I have also tried putting the binary data into a variable first before inserting it into the stream:
set x=myrecordset("blobfield")
picturestream.write x
The stream is closed and set to nothing at the end of processing. Everything is cleanly shut down. Through testing I know the memory leak occurs once the data has been written into the stream. The stream is correctly created as type binary.
The stream problem I am encountering does not seem to be limited to ASP, I tried it using Visual Basic to create a COM component to do the same job and still got a memory leak.
So the questions are:
1. Has anyone come across this before or fixed it?
2. Is there another way of getting binary data out of MySQL, something like the opposite of LoadFile?
I have wasted so much time on this problem but cannot find, having searched Microsoft's knowledge base and the rest of the web, any reference to the problem.
View Replies
View Related
