Display 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 Repliesanyone 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 RepliesI 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.
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 RelatedI am trying to upload large images ( around 4 mb) from the server to show on
the client. Currently I'm using an http handler to do it and breaking it
into chunks sending it 1 mb at a time. Sometimes I'm getting errors, like
the page won't load. Any solutions on how this is done right?
I have managed up to the point that a byte[] imageContent contains a picture which i can show in a aspx page by:
// return byte array to caller with image type
Response.ContentType = "image/jpeg";
Response.BinaryWrite(imageContent);
but what i need is to post it back to the page that the user entered various details without losing them.
i have iis5. windows 2k advance server. I have many http sites on iis. One ftp site with folders protected with userid and password. e.g i have folders at
ftp://www.mysite.com/usa
fpt://www.mysite.com/India
i mapped these folders in virtual directory as:
http:/www.mysite.com/images
and here i have folders for usa and india.
now if i try to diplay image on asp page as
http://www.mysite.com/displayimages.asp
in displayimages.asp page i give url to images file as
http://www.mysite.com/images/usa/logo.jpg
i was asked to enter userid and password. I mean to say, How can i display images on asp pages from the users, whom have posted images to their ftp folder.
I am trying to retrieve images from the database and display them in a random order. The order of the images is supposed to change each time page is refreshed. Below is my code, I am using an array to store the images but the images are not displayed for some reason. Code:
View Replies View RelatedIn the site we want to display the vehicle (obviously) and then a list (graphically) of the features that vehicle has, ie, air con, electric windows, abs, etc. I have attached examples of the images that should be displayed.
The images are kept in a separate folder on the website and they are 'called for' from an access database where the filed name (image id) has a check box.Currently we are only getting a TRUE response and the image is not being displayed. We are looking for some help in how to develop this and get only the image displayed if the check box is ticked on the database.
I have an ASP 3.0 website on which the images are displaying intermittently.
In other words, when I request a page, the image is blank. There is no missing image place marker (rectangle with a red X).
The location where the image should be is just empty.
The code is there to display the image as can be seen when you view source in the browser
And if you later return to the page, or sometimes if you simply refresh it, the image will render properly.
What could be causing this erratic behavior?
I'm not sure whether this is an ASP issue, an HTML issue, a browser issue (the error occures in IE 6.0) or possibly a network issue.
How can I display images that reside in my database through an ASP page?
View Replies View RelatedI am creating a form with checkboxes that contains in the value property, the ID of the image. The filename of the image displayed above the checkbox along with the image.
On that page, I am storing the "checked" information in a cookie. When the user clicks submit, I need to retrieve the actual image that they selected on the previous page and display it along with the image name which I get from the value property.
Right now the only data being passed is the value in the checkbox input tage which is a text string and not the actual image. How do I retrieve the images my users checks off. I hope this make sense. Sort of like a shopping cart, but I only want to be able to select images and post back the ones selected.
I have the standard folder structure on my web server (sya that the server is estserver):
My site is in c:Inetpubwwwrootmysite
I have also introduced the folders:
c:Inetpubimagerootcompany1
c:Inetpubimagerootcompany2
c:Inetpubimagerootcompany3
The idea is security (the companyN folders store images belonging to the companies 1,2,3 - and never the twain shall meet - this does not matter so much). The images are stored above MySite (in the imageroot folder) so that no-one can see them - if they sat in mysiteimages, for example, anyone can see them. And to further thre security, /imageroot does not have a URL
What I need is someway that I can display an image in imageroot on a page in MySite, eg /mysite/gallery.
I need to use an absolute path from my page in mysite to the required image
so in HTML that would be
<IMG SRC=" estserverinetpubimagerootcompany1picture.gi f">
however, that don't work. So how do you do it?
just manged to get an image retireval search engine working. The ASP script works fine, my query results are filepaths of images.
i structured a query in within asp to obtain images which have similar textual values. It is more of a cosmetic issue. when i get my query results back, my script prints or displays the images from top to bottom. which means i have to scroll vertically up and down the asp page over 10-30 images. Code:
I am trying to retrieve images from the database and display them in a random order. The order of the images is supposed to change each time page is refreshed.
Below is my code, I am using an array to store the images but the images are not displayed for some reason. Any help would be appreciated.
<% Dim rstResult
Dim strSQL
Dim img(100)
imgID = 0
set rstResult = Server.CreateObject("ADODB.Recordset")
strSQL = "sp_sel_TilesByType 'O'"
rstResult.Open strSQL, strConnect
set rResult = Server.CreateObject("ADODB.Recordset")
sSQL = "sp_sel_TilesByType 'O'"
rResult.Open sSQL, strConnect
if not rResult.EOF then
do while not rResult.EOF
response.write("hi")
imgID = imgID + 1
img(imgID) = "images/tiles/" & rResult("TileImage")
response.write(img(imgID))
rResult.movenext
loop
end if
if not rstResult.EOF then
intVendorID = 0
do while not rstResult.EOF
if intVendorID <> rstResult("VendorID") then
rndNumber = RandomNumber(imgID)
Response.Write "<p>"
Response.Write "<a href=javascript:popWin('tileview.asp?" & rstResult("TileID") & "','',1,1,1,1,700,600);>"
'Response.Write "<img src=images/tiles/" & rstResult("TileImage") & " border=0>"
response.write(rndnumber)
Response.write "<img src=img(rndNumber)>"
Response.Write "</a>"
Response.Write "</p>"
end if
intVendorID = rstResult("VendorID")
rstResult.MoveNext
loop
end if
set rstResult = nothing%>
I am trying to build a simple image gallery,that displays image form the files on web server and displays it on webpage.
I tried,but it gives an error:
Quote: Error Type:
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
Here is the code:
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?
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.
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 ?
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.
I'm searching some code samples that using blob data type with asp.
View Replies View RelatedI 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 RelatedI 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 RelatedHow 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?
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 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:
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.
My page have background image,on that image have more images and text. My problem is whenever resize browser that images are not resized and also not moved correct place .(i.e look not like before alignment).I want to do everything in dyanamic....
View Replies View RelatedI have an asp page that displays thumbnails from my database. I want the user to click on the thumnbnails to open up the larger image which is also stored in a DB.
View Replies View Relatedi am uploading 3 images(jpg) to sql server 2000 using asp 3.0.i was using this code
http://www.stardeveloper.com/articles/display.html?article=2001033101&page=1
which was working fine when i uploaded 2 images when i tried to upload 3 images its not working.i had posted in the forum earlier about this issue
since i work for a non profit organization who cant spend money on buying some component for uploading images is there any other way or any other code or a free component thats not going to expire
I have an image page in which has a line of small images in a row. click on it it makes it larger below. The images aren't binary form, just the lnik to the image it self. I add the images in a form, so i type in 'image1.jpg' and then it adds it to the database, and then it routs to it and shows it in the database. Now on the image page which shows the image i want a little bit of writing below the image saying its properties. So when i add the image to the database i have to write about the image for example 'A picture of Joe Bloggs' and then when it veiws the image it will say that writing underneith
View Replies View Relatedive been looking for a .net script that will upload an image to the server, but saved an optimised thumbnail into a different directory (or under a different name) with the main image being saved as usual.
can you run regular asp within a .net page? anyone got those .net friendly url/querystring scripts again, my NG browser doesnt go that far back.
I am designing a website that is based from an Access database; in the database I have a table called "Categories" with fields called "Category" and "CategoryPic". On my index page I have coding to get the list of Categories, called rsCategories.
What I am attempting to do is create ASP code that would retrieve an associated GIF file from my images folder when a particular "Category" is chosen (ie. if you choose CategoryA from the recordset, then CategoryA.gif would appear on the page, CategoryB would retrieve CategoryB.gif, etc.). Can anyone kindly assist me in completing this one piece of code.
anyone here got an idea on what codes am i going to use? I got a folder full of images (jpg) and I want my asp page to display those images.
View Replies View Related