I've been trying to find information on displaying images from an Access database, however, the information that I've discovered does not clearly define the steps necessary to display the image with text. Can anyone provide a good reference or explain it to me (like a five-year-old) the complete steps to display an image from an Access database using ASP?
View RepliesI have a client who has had a ASP site with an Access database for several years. It stores information for the used cars on his lot. I have stored text in the database that points to the location of the image for each record. Each record will have a thumb image that is supposed to display in a list of vehicles available then the user can select an item from this list and a new page displays with the information and the regular size image. So far everything has worked fine exept for the display of the images which are stored in a separate directory called veh-photos. All I get are image place holders. I am using Dreamweaver 2004 and and Access 2000 for the database.
Following is the code to list vehicles: ....
This worked fine for enlarging my images until i put it onto a secure server, anyone know how i can fix it ??? just comes up with the standard box with a red cross in it .. and the url when i click image properties says: http://url/images/<%=request.querystring( which is only part of the code)
View Replies View RelatedI have some error in displaying Image in the fields here is the Code:
<tr class="productListing-<%=even%>">
<td class="productListing-data"> <img src=""" & <%=rsProducts("product_image")%> & """ width=""20"" height=""20""/><br /></td>
<td class="productListing-data"> <a href="?mod=product&cat_id=<%=cat_id%>&product_id=<%=rsProducts("product_id")%>"><%=rsProducts("product_name")%></a></td>
<td class="productListing-data"> <%=rsProducts("manufacturer_name")%></td>
<td class="productListing-data"> <%=strCurrency%> <%=RoundNumber(rsProducts("product_price"))%></td>
</tr>
Where is the error ....
I've been creating a page in asp which displays records from an access database. I have limited the number of records displayed to 5 per page. If there are more than 5 records then the user can click next to view the next 5 and so on.
My Image field in the database has a data type of "text" and then i put the path to the image. However when i run my asp page it displays the path as text and im not so sure were im going wrong.
Here is a section of the code used to display the recordset.
For intRec=1 To rs.PageSize
If Not rs.EOF Then
Response.Write "<tr>"
For Each fldF in rs.Fields
Response.Write "<td>" & fldF.Value & "</td>"
Next
Response.Write "<tr>"
rs.MoveNext
End If
Next
Response.Write "</tbody></table><p>"
I have asp pages running from a MySQL database.
I have placed a path in the required field (although not quite sure on
the correct format).
My asp page is just displaying the text path instead of the image.
I'm using response.write.
The Folder is called : images
This folder is within : wwwrootworksimagesimage1.jpg
How should I display this in the MySQL field ?
I have the field as type: VarChar
How do I display image1.jpg on my asp page ?
I'm trying to display an image which is stored in a database, followed by some other information, but I'm having some issues. It's stored in an access database as an OLE object. The code I've got right now is:
<%
Response.ContentType = "image/gif"
%>
<img src="<%= Response.BinaryWrite(rs("ItemImage")) %>">
The error message I get displayed "The image cannot be displayed because it contains errors"
I also tried it like this:
<%
Response.ContentType = "image/gif"
%>
<img src="<%= rs("ItemImage") %>">
which didn't display any errors, but also didn't display the image.
Any ideas where I'm going wrong with this?
I have an image database, I want my images to be displayed like google when you try to search an image - displays horizontally.
How would I check if the first row already has, say 5 images, and then add another row for the next set of images and so on?
can someone show me a tutorial, an article for this one?
mine doesnt require to search for any images, just concerned with the display.
I need to be able to display an image if the time is between two times. Here's the code I have, but it doesn't work.
dim strLink1, strLink2, strLink3
dim tcurrent, tstart1, tend1, tstart2, tend2
tcurrent = now()
tstart1 = "3/1/2006 7:00:00 PM"
tend1 = "3/1/2006 8:00:00 PM"
If Now() >= tstart1 OR Now() <= tend1 Then
'if tcurrent > tstart1 or tcurrent < tend1 then
strLink1 = "/images/2.jpg"
else
strLink1 = "/images/1.jpg"
end if
When I look at the page, the image never changes. It just always displays 2.jpg and not 1.jpg. I need help ASAP!
I have a image of an item and below it have a text which says "View larger Image".
so when someone clicks on the text i need to show them a bigger image from database
so what i am trying to do is open a new pop up window and show a larger size image
<%
rsimage=rsproducts("Large_Picture")
%>
<a href onclick="showpic('rsimage')">View Large Image</a>
and the javascript function is like this
<script language="JavaScript">
function showpic(pic)
{
popupWin = window.open("pic", "open_window", "location=1, width=640, height=480, left=0, top=0")
}
</script>
right now whats happening is i see a new pop window but message says
"Page cannot be Found"
I want to provide random image on my asp page. the image will display according to products searched by user.
e.g.
if user enter pharma machine in search box, in result page the banner of pharma company will display. i.e. the banner of manufaturer/exporter of pharma machine will display.
for this i have comapny info table in database
table: comapny_info
fields in comapny_info:
company_name
products (comapny products)
description (company_description)
banner (yes/no)
dusring registration, comapny has to specify whether it wants banner or not. so if there is yes in banner and prodcuts match the search string then banner will display.
this is according to the product seaarched by user.
any idea?
How to display the images from a lightbox randomly?
I have saw the image from a lightbox in the istockphoto website, it can display the images inside the lightbox. how to do it?
How would I do it for DATE instead of Day of the week?
View Replies View Relatedi want to display images in my search result page according to search text enetered by user. and i want more than one images display randomly.
View Replies View Relatedi have a database..(pics.mdb)
1 table
pics(table name)
id,file,display(3 fields)
4 records..
1,pic1.jpg,yes
2,pic2.jpg,no
3,pic3.jpg,yes
4,pic4.jpg,yes
what line of code do i use on my asp page to display the picture where display is yes?
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 have catalogue online but some of my items have no images. When there is no image I would like to show a note: response.write("There is no images at this time.") instead of the Icon of the image missing. I tried several ways but it ends up showing the response in all my records regardles if there is no image.
How would that be applied to the code below?
<% If (rsNeat.Fields.Item("product_image").Value) <> "" Then %>
<a href="#" onclick="MM_openBrWindow('cat_images/<%=(rsNeat.Fields.Item("product_image_big").Value)%>','','width=450,height=450 ')">
<img src="cat_thumbnails/<%=(rsNeat.Fields.Item("product_image").Value)%>" alt="" border="0" />
</a><% End If %>
On my index page I have got an area for one product to be displayed randomly from the
database. I have got it workign, but there is one problem i cant get my head around, here is the code so far:
' Initialize ASP RND() function
Randomize()
intRandomNumber = Int (1000*Rnd)+1
strsql = "SELECT TOP 1 art_Artist, art_Title, Rnd(" & -1 * (intRandomNumber) & "*cat_ID)" &_
"FROM eventDisplay " &_
"ORDER BY 3"
The code above isnt working and its when i try and draw out more that one value, as in art_Artist and art_Title.
It works fine if all I want is art_Artist, but as i said when i try to draw out more than one value the randomize function doesnt work.
I am trying to display records ( text and images) from a database. I get the text displayed but the image is displayed as a large series of Asscii text.
Connect.open "DSN=Rentals"
'declare sql statement that will query the database
query = "Select * FROM RentalTable WHERE Location LIKE '%"
query = query & Replace(request("varLocation"), "'", "''") & "%'"
query = query & " AND PropertyType = '" & Replace(request("varPropertyType"), "'", "''")
query = query & "' ORDER BY DateAvailable"
RS.Open query, Connect
do until RS.EOF
%>
<table width="75%" border="1">
<tr>
<td><%=RS("Address")%></td>
<td><%=RS("Location")%></td>
<td <%
Response.ContentType = "image/gif"
Response.BinaryWrite(rs("Image1")) %>
</td>
</tr>
</table>........
Hi, I am trying to output an image using a filename from a database.
My code:
Response.Write("<img src='uploaded/" & bannerRecordSet("Banner_Image_File") & "'>")
Response.Write("<img src='uploaded/homepage1.jpg'>")
The first example works but doesn't display the image
The second example works and always displays the image
I don't know what is wrong with my code as the images are definitely on the server.
principally I'm a photographer, and in the absence of any image galleries I could make sense of I created my own asp pages in Dreamweaver displaying images from a path stored in a database. These can then be paged through, all done using server behaviours in Dreamweaver. However, because I wanted to include some text next to my images, again a field in the database, I have to scale them down. I would like to give the user the option to see a larger version of the image on display, preferably in a pop-up window that is then closed by the user before they continue scrolling through the images....
View Replies View RelatedLooking for some good resources on coding an existing page to display images that are uploaded from a secured admin section. I.E. The only individual I want adding images to the page is the one I give permission to behind our Staff Section.
The Picture page is open to the public. Currently I have to create thumbnails, upload those then upload the full size image and then link it all on the pictures page. Looking for a way to let the end user do this themselves.
Just hoping to get some leads on how I can go about doing this. Do I need to save the images to a database, or can I just save them to a folder?
I've got a directory site for accommodation providers. I would like them to have the ability to display a couple of images on their details page. I can easily set it up so they upload images to my server and DB and are displayed etc etc... But I would rather have them just provide the links so that the pictures remain on their website etc....
The only issue I have is what happens if it is a bad link. By uploading to my server I can remove the risk of images not appearing, but by using a link, is there a way of 'testing' whether there is an image at the end of the link. Is there a script out there capable of verifying if an image file is where it should be for veiwing? My initial thought was to have a script that tests the image link for a width <> 0. On the page I would use an IF statement to allow displaying of the image if the image existed..... BUT HOW ?
Could someone help extend this ChangeImage function to also display a different hyperlink underneath the newly selected image?
<script language="javascript">
<!--
/*Combo Box Image Selector:
By JavaScript Kit (www.javascriptkit.com)
Over 200+ free JavaScript here!
*/
function showimage()
{
if (!document.images)
return
document.images.pictures.src=
document.username.u_BrokerID.options[document.username.u_BrokerID.selectedIn
dex].value
}
//-->
</script>
<form name="username" method=post action="join_step4.asp" onSubmit="return
CheckForm();">
<SELECT NAME='u_BrokerID' size='1' onChange='showimage()'><OPTION
VALUE='0'>--Select a Broker--</OPTION><option
value="/catamaranco/images/brokers/john_2.jpg">John Anderson</option><option
value="http://www.catamaranco.com/images/brokers/staley_2.jpg">Staley
Weidman </option>
<input type=submit value=submit>
</form>
<br><br>
<a href="Site1.asp">Change this url depending on the value of the image
selected in the dropdown?</a>
I have images stored in database how can display them in asp?
View Replies View RelatedI have been fighting with this for days now, and I can't seem to get it to work. Images are stored in an Access db as an OLE object. I have the following on my page Code:
View Replies View RelatedI would like to display a lot of binary source image in one html document. Those image are read from ms acess database
I know only read and display one image, such as:
Response.ContentType = "image/jpeg"
Response.BinaryWrite rs.Fields("iamge")
But, this cannot display any text and other image, only an image can see in the browser.
1.I want to show a image file of type '.tif' in the browser window; for that I'm writting as ASP code page.
2.This '.tif' type image can be shown better with 'Kodak Image Control'.
3.To have this 'Kodak Image Control' on my code page I just add it's ..ocx to tool box and then drag it from 'Toolbox' to the page.
4.Now after dropping this control to the code it's type is getting changed to 'object' instead of type 'ImgEdit'(and I think this is the
reason I don't get correct result).
5.On one button's 'Onclick' event I'm calling a javascript function with which I'm setting a 'Path'and'Display' property of a control.
6.And want to show a image at location -- '..MFTDRCMF919685173-62.tif' which get shown in new browser window but could not get shown in that particular control. That means the path is correct, then what is the problem?
For better understanding of problem I'm pasting a following code which I've tried up till now......
..................................................
<%@ Language=VBScript %>
<% OPTION EXPLICIT %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<SCRIPT LANGUAGE=javascript>
<!--
function showpic()
{
var path;
path = document.frmtif.path.value;
alert(path);
document.frmtif.ImgEdit1.Image =path;
document.frmtif.ImgEdit1.Display;
window.parent.self.open(path);
}
//-->
</script>
</HEAD>
<BODY bgColor=#ffe4e1>
<form name="frmtif">
The Image
<P>
<OBJECT id=ImgEdit1 style="WIDTH: 409px; HEIGHT: 218px" type="ImgEdit"
align=left
border=1 classid=clsid:6D940280-9F11-11CE-83FD-02608C3EC08A
name=imgtif></OBJECT>
<input type="hidden" name="path"
value="..MFTDRCMF919685173-62.tif">
<input type="button" name="show" value="Show" onclick="showpic();">
</P>
</form>
</BODY>
</HTML>
..................................................
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...
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??!
Here is my code. I'm using 2 pages.
(Page 1) blob.asp
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_blob_STRING
Recordset1.Source = "SELECT AboutPic FROM Elizabeth.GF_AboutUs"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Response.contentType = "image/jpg" 'Recordset1.Fields("AboutPic") <---Tried
both methods
size = Recordset1.Fields("AboutPic").ActualSize
blob = Recordset1.Fields("AboutPic").GetChunk(size)
Response.binarywrite(blob)
%>
(Page 2 Show the Image)
<%
Dim urlString
urlString = "?" & Request.QueryString
%>
<% Another rs to show other information as text from the same table %>
<body>
<img src="blob.asp<%=urlString%>" width="194" height="256">
</body>
I'm working on a project where I'm suppose to upload a image to a server. The uploading works fine but when I want to change the image I uploaded to another image I can't get the filepath of the old image to show in my "filefiled"....is it possible to set a "value" where I can retrieve a filepath in a form if the input type is "file"?
View Replies View RelatedI'm looking for a simple way to merge an image into another image.What i have is a screenshot uploader, and i want to make it so that when they upload the SS, the script will automatically merge a small copyright type image onto the bottom right of the picture.