Am storing images on a database and users query the database to retrieve the images. I want to add a zoom in and zoom out button that will enlarge and reduce the images depending on which button the user clicks.
View RepliesI'm having problems retrieving certain images from my web server, such as, Dozier SrB9057.
The problem I'm having is w/, Jr., Sr., II, and III get the drift. How can I get rid of the space in between the last name and Sr?
Now, the Sr is included in the field along with last name.
Here's my code:
strSQL = "Select * from vw_licenseholder_PrimAddr where L_ID = 5940"
Set rs1 = objConn.Execute(strSQL)
ImagePath = "w:" ....
The user basically queries the database for some data, and I initially retrieve just part of the data matching the query...
I display the Primary Key as a hyperlink..and when the user clicks on a particular retrieved data..i want to display all the contents about that element alone on another new page...
The problem i am facing is that i do not know the syntax to use the onClick event within an ASP code:
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
Totally new to this html / javascript thing so haven't got a clue how I'm gonna to this - but hope to get some help here.
I've got a page with 2 frames one called "left" another one called "right" in the left frame i would like to make a "div" - menu ?? and on
the right I just load an image. My menu in the left i want to be able to zoom on the picture in the right frame... ex. make 5 different zoom
levels..
Hope that you understand my problem and is able to help - never really programmed in html/javascript before.
I want to create a database in which I store images. I dont want anyone else to upload images, just me. All i want to be able to do, is put the URL of the image in my database. Then i can click next, back, to veiw all the images. How will i do this?
View Replies View RelatedI would like to know if there is a way to upload an image and text into an Access database using asp. I have a web site hosted on a web server which doesn't accept to install components. If anybody knows some sample code (in case this is possible), a link or some code would be welcome.
View Replies View RelatedMy database only has an image field (sql2005).
All the tutorials I find have the databse with additional fields like Filename, FileSize, FileData, FileID, Contenttype, etc.
I want to upload into ONLY that image field because my windows app accesses the same database, and it doesn't use those additional fields. does someone out there have a tutorial or some code example or SOMETHING related to uploading a file into a SQL database?
I 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:
Dreamweaver, Access, IIS
Okay. Here is my goal: I have a database that contains a volume, a chapter, and file names in that chapter. I have a drop-down list that selects the volume (this works!) I have a drop-down list that is dynamically populated by the volume to select the chapter (this works!).
Now I want to have images corresponding to the filenames that correspond to the previous selections:
volume --> chapter --> file1, file2, file3, file4... (I have images named file1,file2,file3,file4)
My question is what is the best way to get the text name of the file stored in the database to become an image that will be posted on the screen. An array? Take it right from a recordset? Any ideas?
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 am trying to put in images from the database and using something like:
<img src="I:/in_uni/<% response.write rs.fields('Image') %>">
but it isnt working.
also tried in:
<img src="http://cms-stu-iis.gre.ac.uk/ck227/test/in_uni/<% rs.fields('Image') %>">
but it still aint working!
i 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 Relatedhow to load pictures from database... I know the part how to store the URLs of the images in the database... I've done that before with other technologies.
what should I use for image palceholder (is just regular HTML witn the <%...> for the URL
written out) and how I get the separate indexes from the DataSet object returened from the database for loading imgaes into placeholders?
I have an Access database set up with a number of text fields and a hyperlink field which references a different image per record. I am trying write ASP code to retrieve allt his data and images onto a web page. I have the data but the images are causing a problem.
The code I am using is as follows:
For the data: ....
i have now found codes to get the images from the the access database, but i havnet found the code for uploading to an access database. can anyone please help me? i just need the code sample to upload images to an access database.
View Replies View RelatedHow can I display images that reside in my database through an ASP page?
View Replies View RelatedI have some difficulty in stroring uploaded images name in database. Images files are uploaded successfully, but when i want to store images name into database it only contain
last file name and stroe only this file name in all images fields into database....
uploading images directly to a field (of type OLE Object) in the table in access database and also how would I get them displayed in the products page.I need to know this for an online catalogue management site and have done similar things a lot of times using Persits.
Upload where I upload the images to a location in the site and refer the location and file name in the database. But, unfortunately, this server doesnt support this object and I need to find a way as explained above.
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%>
How can I accomplish the following:
I want to upload image files (jpg) into a sub-directory of a website root directory using a web interface allowing the user to browse their drive and select the jpg file to upload.
Also, is there a way to parse the information from the jpg file and insert the information into a SQL database table which would hold the file name, image height, and image width?
I'm new to handling binary files, so I'm not sure how to accomplish this?
In retrieve among other data an emailaddress from an SQL table and put it in a tabel (see code below)
How can I make the email address an active mailtolink
greetz
edwin
<ItemTemplate>
<table border="0" width="100%">
<tr>
<td valign="top" width="115px">
<%# DataBinder.Eval(Container.DataItem, "User_name") %></td>
<td valign="top" width="180px">
<%# DataBinder.Eval(Container.DataItem, "User_Email") %></td>
I added a column to my Access database and defined it as hyperlink.
I added some URL in the fields and i was able to see the underline under each address.
In my code i added the following line :
Response.Write("<td align=right>" & oRS("info").Value & "</td></tr>")
(The hyperlinks defined in my database as info).
I'm able to see the hyperlink when i retrieve all other data but it appears as
#http://www...asp# and with no underline what is the reason and how can i change this ?
does anyone knows how i can layout items retrieved from db such as example from this online shop site . most items retrieeved from db such as Accesss are always in vertical layout.
View Replies View RelatedI haven't started to mess with this yet, but is it possible to store
.ASP source script in a Database field, then use ADO to get the string
from the field and then force the scripting host to interpret that
string from the database and flush it into the buffer for output to
the browser? I was thinking you'd have to use EVAL() on the string or
something...Anyone done this yet?
I was working with Vignette story Server a couple of years ago, and
all of the TCL source script and html is stored completely in the
database, only cached pages are in virtual directories.
The link for the photos are requested from the server and so the photo
appears on screen. I can produce a long list by using the response.write ***
& "<br>" or whatever. but is it possible to have it start on the next line
after say 5 photos in a line. i.e. where each - is a photo
- - - - -
- - - - -
- - - - -
rather then
- - - - - - - - - - - - - -
or
-
-
-
-
etc.
I'm attempting to read data written to a MySQL database and view it in the browser. I've searched the net for over 3 days and I've seen many posts that say it works great, but it's not working for me. The only thing that displays properly is a text file. Everything else is garbled. I desire to store & read PDF files though. Here's my code:
<%@ Language = VBSCRIPT %>
<% Option Explicit %>
<!-- #include file="dbConn.asp" -->
<!--#include file="adovbs.inc"--> ...
Im doing a password retrieval page that is working fine, but it wont appear in the html page i want it to.
1)When i dont try and put it on any page the text appears no problemo on a white background.
2)When i attempt to put it on my designed page all that appears is my designed HTML page with none of this text. Code:
I have a feedback form which asks someone to enter their personal details and then submits them to db. There are input, checkboxes and selection boxes on form.
Now I want to allow user to edit this form. When user clicks 'edit', I retrieve all the values from db and populate the text boxes.
What happens with the options and checkboxes. How can I get these to reflect what their values in db? Also I have some drop downs allowing user to select date of birth ie. day drop down, month drop down and year drop down. How do I show user the details we have for them if I'm using drop downs?
While trying to retrieve a large number of records, I would like to show a progress bar to indicate that the user are to wait. How can I do so?
View Replies View RelatedI managed to retrieve a table from a database and displays records on the browser using the ASP code below.
but I also want some of the retrieved record be clickable and editable so if a user decides to upadate a record it can be clicked and updated. there are two options either redirect to another page and the selected records will be displayed again to be edited or edit them on the same page,I m not sure how to make the selected records editable using the code below. Code:
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 Related