I wish to display an image from a folder based on the name held in a field in a database.
<%
If len(rssal("picture"))>0 then
Response.Write ("<img src=""/ProductImages/rssal("ProductCode").gif"">")
ELSE
Response.Write ("<img src=""images/sorry.gif"">")
END IF
%>
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.
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
I can convert an image that is retrieved from a FileUpload object into a byte array and insert it into the database..
When the user signs-up i wish tosimply insert into the Picture (DB Type = Image) field to an image i already have saved in my images folder?
Anyone know of a way to do this? Tutorials, articles or advise??!
I am creating a dynamic ASP VBScript page, which gets data from an Access database.
In the database, there is a field which holds a URL to an image. I can get the image to display fine, but where there is no file that matches the URL (i.e. a missing image) I want to display an alternative, default image (e.g. one that says "Awaiting Image"). The field is never blank, but the image file may not exist for all records in the database.
I think what I am trying to get to is the following:
If file exists (using URL from database to get location of image file) then
display image using the url from the database as the image source
else
display default image - hardcoded in program
endif
I have had a go and come up with the attached but I get an error with my if statement...
Have two folders on my web server, data and public. Public is the www root and is read only, data has my database and is read/write.
I've got an asp upload script sending image files to data/images which works fine. I've also got a file listbox which picks out the file names on an asp script to add the names of the files to a database table.
However...I'm having real problem pulling the images out on the gallery page, I reference them with a virtual path '../data/images/imagename.jpg' etc, but they will not show.
Anybody know a way round this? Sorry if you need more info just say.
Everything works but the image that is called from the database does not dispay? no error messages are displayed, have double and tripple check paths and image name to no success, thought it could be the code:
View Replies View RelatedIs there a way to display a calendar created in a public folder? We are
using Exchange 2003 and have an intranet and I would like to pull the daily
view form the calendar and display it at the bottom of my daily
announcements page.
I have 1 form that put some text in Acces. After submitting that form there comes a form where 4 images can be uploaded. These image are stored in a folder on the webserver. Can I save the path to the image in the record (id) of the textfiles in Acces?
View Replies View RelatedI have a DB table, which contains the name of a image file stored in a folder. What i need to do is somehow retreive this image and display it in an asp page?
View Replies View RelatedI need code please..
View Replies View RelatedI'm sure I'm missing something completely obvious, but I can't figure out what. I have a path to an image file stored in a database. I'm trying to align the image to the right, but nothing seems to be working:
Response.Write("<img src='" & rs("faculty_link_to_photo") &"'>")
dispays the photo without any wrapping, but when I try the following, the images go all over the page:
Response.Write("<img align=""right"" src='" & rs("faculty_link_to_photo") &"'>")
Can someone tell me what I'm doing wrong?
I have ASP (classic) code that writes out a table and sets the <img....> tag
with a virtual directory source, e.g. src='/test/imghold/xyz.png', and the
images do not appear on the IE page. The code is from a production site
that works fine.
We just duplicated the web site to one named test and now
the images do not display. The IMG item is in a TD element of a table.
Also, I looked at the "view source" of the page and it shows the <IMG
src='/test/imghold/xyz.png'...> just fine. I even tried it with different
images and none of them show up.
It is not displaying the image thepicture. It is in the directory. I also have a similar bits of code for a other pictures with of and they is working The response write displays the correct reference.
The alt displays instead of the image as though the image has not been found and as I said the Code:
I have to display tif images using .asp page. I have tried to read the image
as a binary file and stream it to the browser. The relevant code is as
follows. Unfortunately, the display on the browser is a lot of gobledygook.
How can I ensure that the image displays correctly in the browser? Code:
The pic in the DB is just a named reference, as all the pics are stored in 2 common folders. 1 for the normal size pics and 1 for the thumbnail equivalents.
As this particular page has to be tight on space, I wanted to set the image as a percentage of it's size so I set the following:
<IMG SRC="thumbs/<%=picname%>' WIDTH="30%" HEIGHT=30%> etc....
Problem I have with this is that the browser seems to set all pics to 1 common percentage size rather than each being say 30% of each individual pic's size. This results in some piccies being completely distorted.
I don't want to go down the route of storing the x and y of each pic in the DB, so could you please let me know if I am doing something really stupid with the above.
I dont know if this is the right place to ask this but I have a database which contains shop details, each of which can have several images associated with it. In the database I am just storing the image paths, the actual images are held on a remote server.
I am able to grab the pathnames from the database and then use the following code to loop through the recordset displaying the associated image(s).
While NOT rs.EOF
Response.Write("<img src=""servernameImages" & rs.Fields(0) & """ width=""150"" height=""150"">")
rs.MoveNext
My question is, in the event of one of the images not being found, it just displays a red cross, is there any way of testing to see if the image exists before I try and display it?
I have designed asp pages where all pages have common header and footer. I have added Images to the footer page called as footer.asp.
now i have the footer.asp in another folder
and i call that footer.asp within my index.asp page as a include page.
but the images in the footer.asp are not displaying in the index.asp.
what could be the problem?
An application is logging faxes sent in SQL2000 image column type. I have
found code on the net but what it is doing is prompting to save to local
which is fine for single page image. Not good for multiple page faxes. I
have not been able to locate an example to load in the browser or how to
handle multiple image in the one column. Code:
The code sends an automatic email, but the email is html format. At the top of the email i want to include an image.
Everything is working except the image is not being included, instead a box with a X appears.
Here is the code that i am currently using
Dim htmlMess ' THIS STORES THE HTML CODE
PHP Code:
I am trying to filter a table of users to select only those records
whose roleID matches a value in an array. There could be any number of
IDs held in the array from one to a few hundred. The array is
generated by splitting a comma delimited memo field from a second
table in an Access DB. I can split the memo field OK, I can
response.write its values, but what I now want to do is add a value
from another table to my reponse write loop. Code:
This line of code works fine when the database is in the webroot folder:
DataConn.Open "Driver=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("LessonsDatabase.mdb")
but when the asp file containing this code is in the webroot but the database is in a subfolder called db. I dont know how to reference it relatively. PLease help! I'm sure this is very basic to anyone in the know.
I need to know how to display a new post above an old one:
here is my script to display the database (news):
Code:
<%@ Language=VBScript %>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("database/news.mdb")
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "SELECT * from news", Conn, 1,3
do while not rs.EOF
Response.Write rs("name") & " " & rs("when") & "<br>" & rs("news") & "<p>"
rs.MoveNext
loop
set Rs = nothing
set Conn = nothing
%>
I have a set of code for displaying information from the database. However now i can only view text with no pics... what can i add in order to see pics together with the text and what data type should i put for the pics in the database? Code:
View Replies View RelatedI am building a website where users can place advertisements with images. I have decided to place the images in an Access database to ensure the right images are matched the correct advertisements. My problem is that I can retrieve all of the data from the table which holds the photos (eg, filename, file size, content type) except for the actual photo itself. When I try to download the photo or press the hyperlink to display the photo all I get is the square with the red cross. I do not get any error messages.
Does anyone know why this is happening. My code is below:
I am trying to display images on a results page which have been saved in a Access database as BLOBS. I also trying to resize the images at the same time so that each record on the results page has the same dimensions. I have 2 include files on the webpage to resize the images, a processing ASP page to download the images and the syntax to make it all work.
My problem is that I am new at ASP programming and having the problem of putting all of the pieces together. I keep on getting an error message on 1 particular line and have no idea on how to fix it after many hours of trying different ideas. Code:
I have a page that allows users to sign on and then have access to the site. What I need to do is to have them sign on and see selected (tables) or data that is in the database.
I need some help. How would this be written. Unfortunalely the only book I have on the subject is asp.net. Code:
I have just recently use record paging, i now have a problem the way the records are displayed.
I have a table header with each header name of records to be displayed, and each individual record should be displayed directly underneath each other PHP Code:
I am using MS Sql server and asp pages together.The problem I am getting is not knowing what data type to best set my data to.There is a part # set to nvarchar which seems to work great.
THen an Inductance, currently set as float. My inductance values show as 1.5 and 5, 3, 3.2, etc etc, however I need it to show 5.00 and 3.00, 3.20 etc.the inductance is measured in mH and another column called DCR is measured in Ù. Is there anyway to get this symbol to show in my table on my asp page? or do I need to enter the symbol into the database table?
I am trying to display all the records in my database when I click a button that I made. Can anyone show me how to do that? Right now I have no code for this. I just want a button on my page, so that someone can print out a list of all the records in my database and have it for reference.
View Replies View Relatedi would like to store images in a database so that when a link is clicked on a html page a new page opens with the image taken from the database. I have heard that you should only store the image path name in the database. how i would do this and then display the image on a HTML page.
View Replies View RelatedI have a database on my server that houses information regarding trouble tickets. I know how to write asp page to take the inputted info from a form and put it in the database but what I would like to know if someone could show me or point me in the direction of a good tutorial that shows me how to list all the content in my database on a web page.
For instance I would have a page titled, view all tickets, then on that page would be a listing of all the tickets and their information with buttons to add, delete or update ticket.
I am displaying a table that contains 36 columns and 20-40000 rows.The first row is a header.When i scroll the page down the header disappears(anyways this is a fact).Is there any way in which i can keep the header/first row constant when i scroll the page downwards or sideways for n number of records? I am using Access as the Backend and the front scripting is by ASP and connecting thru ADO.
View Replies View Related