Reading JPG Blob From Mysql
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
ADVERTISEMENT
ADO Streams And Binary Data Held In A MySQL Database Blob Field
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.
BLOB
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?
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.
BLOB Objects
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 ?
Blob Issues
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.
Use With Blob In Oracle
I'm searching some code samples that using blob data type with asp.
View Replies View RelatedImages From Oracle(blob) To ASP
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.
Insert A Blob Field
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 RelatedDisplay BLOB Images
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 RelatedCan't Display Blob Image
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 RelatedInserting/Displaying BLOB Files
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?
Retrieving BLOB Fields From A Database?
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:
I Need A Code For Uploading Files Into Oracle Database In Blob Fields Through ASP
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:
Reading XML With ASP
Could somebody please help me out with this? I have been researching it all day and can't figure it out.
All I want to do is put some info from this XML file (staff.xml):
<staff>
<employee id="1">
<name>John</name>
<job>Janitor</job>
</employee>
<employee id="2">
<name>Mary</name>
<job>Accountant</job>
</employee>
</staff>
into an ASP page. I already started an ASP page:
<html>
<head></head>
<body>
<%
Set objXMLDoc = CreateObject("Microsoft.XMLDOM")
objXMLDoc.async = False
objXMLDoc.load("staff.xml")
response.write("<p>")
'I NEED TO INSERT THE FIRST PERSON'S NAME HERE
response.write("<br>")
'I NEED TO INSERT THE FIRST PERSON'S JOB HERE
response.write("</p>")
response.write("<p>")
'I NEED TO INSERT THE SECOND PERSON'S NAME HERE
response.write("<br>")
'I NEED TO INSERT THE SECOND PERSON'S JOB HERE
response.write("</p>")
%>
</body>
</html>
That's all I have in the ASP page because I am having trouble with it. Could somebody please help with it real quick? I'm sure it's very simple, but I am having trouble learning the XMLDOM thingy.
Reading RSS/XML
anyone know a simple to use RSS/XML feed getter so i can add external news
to my site?
Reading Xml
I got a little piece of ASP code to read from a remote url, which is expected to be an xml, like a RSS feed, and echo the content out to be processed by downstream xml processor. The code is like this:
<%response.ContentType="text/xml"%><%
Response.Buffer = false
Dim objXMLHTTP, xml, url, text
Set xml = Server.CreateObject ("Microsoft.XMLHTTP")
url = Request.QueryString("url")
xml.Open "GET", url, false
xml.Send
text = xml.ResponseText
Response.write(text)
Set xml = Nothing
%>
Using firefox, I get the request.responseXML object back from the code above, works fine. But in IE, the request.responseXML is returned null, but request.responseText did show the entire xml file.
My question is how should I make change to the above code to let IE honor the request.responseXML object? I gues the xml is somewhat ill formatted and IE can not recognize it as an xml.
Reading XML
I have an ASP classic site that needs to add the option of reading an XML file send back from another web site and parsing it into a multi-column HTML table. The server is Windows Server 2003. Can anyone direct me to where I might find more info on this?
View Replies View RelatedCd Reading
I have just created a cd based demo web with FP2000 under XP pro. The disc plays back fine on the XP machine, but when tried on a WIN 98 machine it doesnt play, and I get " G: is not accessible Device not ready" when I try to read it in Win Explorer. The disc is a 48x speed 700mb CD-R. Is it too fast for the older machine?
View Replies View RelatedReading A Cookie Value?
am trying to create a login page for the first time, I have a login page, validate login page and if the password is correct it takes me to the first page.
I have customized this code someone else created,but what I have a problem with now is I need to log who submitted that data and that is why I am trying to read UserName cookie so I can later match that data.
This is the error I get which is telling me that it is reading the cookie since this is the UserName I am logging in with
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'boxhill'.
but I can't see what is wrong, and there is not much out there for this kind of error.
So I can login successfully but now i need to read and dispaly that cookie and then insert the value of the cookie but,but don't worry about that now, just trying to give you the full picture.
So this is the code for reading the cookie ...
Reading Mp3 ID3 Tags?
i was wondering if any one could give me some info on how to get mp3 ID3 tags in ASP?
I've seen it done, but don't really have any idea how,
just looking for info like song lenth, bitrate, and so on.
Reading DIV Tags
I have a function in ASP and I want to read a DIV tag. Any ideas? I know
the syntax but when I apply it, doesn't work.
Reading/Echoing
What is a good method to read a file that is hosted on another server. I really want to echo the code found between a "<PRE>" and "</PRE>" tag found in the source of an externally hosted file. How should I go about this? I am somewhat new to ASP, but am confident there is a way.
View Replies View RelatedReading File
I have a routine I'm writing to read the contents of a file and modify it. However the file will not parse properly into an array, so I strongly suspect I'm using the wrong character to parse the file. The line of code that is supposed to parse the file is:
arrLines = Split(sFileContent, vbCRLF)
When I view the array, it appears as one continuous line, but when I open the file in a file editor it's very clear there are 15 lines.
Reading An Xls File
I've got a league standings file that gets uploaded as an xls file. To display the contents, I'm not sure what the most efficient way is:
1.) Import the xls file into a database every time the file is updated
2.) Read the contents of the xls file using OpenDataSource or OpenRow Set
3.) Something I haven't thought of yet!
Reading A Sql File
I've to got a login script, but in the middle of the verification script, I'd like once the vify has been ok'd to look for a sql file, that has insertion data in it, once the file has been found the asp code must read and carry out the sql command (insert the data in the access db), once done the sql file gets deleted. Code:
View Replies View RelatedReading The Cell
I have to upload one excel file. In that excel file I need to check the availability of data in particular cells and also the worksheet name. If the data is not available at particular cell, say for eg: $F1, an error should be thrown to user saying that the data is manadatory. How to do that? How to read the particular cell in ASP? If anybody knows the code, please send the same.
View Replies View RelatedReading A Variable
How do you read a variable that you've declared on one page
For example
I've declared
dim x
x=23
then i goto the next page. I can't seem to access it.
How do I get access to that variable that has been defined in the previous page.
Reading From Csv File And ,
Im having a bit of trouble with taking a csv file and sperating each row with a "," because we all know that csv's are serpated by cammas, my problem is the rows are getting messy because say I have for the first Collum "Toy, Really fast", it will seperate the collum name because of the , Is there any way I can remove these or whats the best way.
Heres my code right now: Code:
Reading File
I am developing a web page, in that i have to get user's photo from user and insert it in to database. how to upload this photo from local drive to my server
View Replies View RelatedReading Title
i dont know that is this right to put the question in this forum or in html forum.
anyways, the question is how can we read/find the value of title tag of html page using asp or any scripting langauge.if any one has idea, please do share
Reading The Data Of A .xls
I cannot figure this out for the life of me. All the tutorials I've gone though give code (and from what it looks like, wrong code) with absolutely no explanation?
My ultimate end is to read the xls file into a mysql database.. but I need some method, way or idea of actually doing this. Presently the data is an a .mdb database (so I can save it to different formats) but I cannot use the .mdb itself to upload the info (server disallows reading and writing from .mdb).
I've looked all over and there is no detailed method of doing this (all I really need is just the basic code for connecting to a .xls sheet (excel sheet) and then reading the data from a line and displaying it on the screen (there is no present tutorial that explains that, least that I can find)
Reading From An Email
I need to read from a weekly email and extract the contents of that email then convert them into HTML. I do not have control over the email that is being sent but do have control over the email account the notice is sent to? So to explain everything I need to take this email and post it onto a site, I can do it manually everytime but am looking for a way to let the script do it?
View Replies View Related