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!
My database and ASPs are currently on my local server and now I want to put it on the company's server.
Any pointers how can I do that? Do I need to keep both the ASP's as well as the database on the server?
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 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 RelatedAm 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 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?
I have a form with '/' in some of the field names, when I pass through to
the next page the field name comes back as though it's been htmlencoded, so
getting the value out of the field I need to convert this back to '/' with
the replace (same problem if I have a ',' in the name)
Is there an easy way to htmldecode or something what it converted to the
encoded versions? (I have written a short function to basically do all my
replaces for me, but I am guessing this isn't the ideal solution)
I have a database table where I managed to add with ASP an extra column which breaks down the previous column "text_data" and counts the number of words: Code:
View Replies View RelatedI have an app that I want to send out an email to each user in our member
list giving them their username & pw, but I don't want to overwhelm my mail
server since there are over 1000 users in my database.
I don't want to overwhelm my web server, either, having this app hog all
resources.
Luckily, I do have two processors running in this web server.
Note: web server and mail server are different boxes.
So... what kind of pause routine would you all put into my VBscript ASP
within the loop that sends out emails to all users?
If you have a href such as this,
href="somepage.asp?home=alpha&street=beta, how would you include a reference to a bookmark on that page, such as <li id="bookmark">Some List Item</li>
Is it possible to put the logoff/shutdown/restart buttons on an ASP page or something similar? If so can anyone point me in the direction of some code or where I can read how to do it?
View Replies View RelatedI have an application which loops through several thousand subscriber
records, compares each subscriber's requirements to a database of
businesses for sale, and then prepares and mails off an email
containing info from the database that the client is interested in.
Problem is that the ASP file exits as soon as it has sent about 50 or
so records to the Mercury/32 mail server on the local Ethernet. No
error message or program execution issues noticed. I then delete the
first 100 or so subscriber records and set the file off again. In the
loop thru the next 100 subscribers it prepares an email for approx
every second subscriber, then seems to hit this 50 max limit and
terminates again. Driving me crazy.
I figure that somewhere there's a queue building up which maxes
something out and causes some low level termination. To test that,
I'd like to build something into the loop thru the subscriber file
that causes a delay of 10 seconds or so before the loop starts again.
Code:
We have two applications for one system. The first application is a vb-app
and the second is a web-app.
From the vb-app users have the possibility to enter right into the web-app.
The vb-app is creating an appropriate url and opens the web-browser with
this. The url contains user-information like user name and password. We
don't want this url-information to be stored in the history-list, because
then advanced users can find passwords etc here and that's not so good.
I am retrieving data from html form, perform some math. calculations on it and now i need to put this data back to some presentable form to display in asp.Earlier I get the data from FORM in text format, convert it into double value, now want to put it back in text format for dispal.
View Replies View RelatedI'm trying to put my data from Access DB into a table, but, where I know how to do it creating one row per record, what I'm wanting to do is essentially extract each record into 1 cell, and then have the next record in the next cell, creating a table 2xn in size.
The data I'm getting for each record is a URL & a file location, to create an image hyperlink for each record, and need the images to appear in a table 2 columns x however many rows required.
Is it possible to put a variable in parameter for a URL? I'm looking to have a page with an input box and a link. When someone puts in a value in the input box and clicks the link it will take the value and pass it through the link to an asp page.
example:
Employee Name <input type="text" name="Tname" size="20">
<a href="emp_info.asp?e_num= Tname.value">Employee Info </a>
How can I get this to work?
I'm practicing making cookies and I've run into a small problem. I'm following this
Response.Cookies("name") = "Suzy Q."
I'm not using a physical, I want to load the information from a variable. all my variables that are not using letters work fine.
i've tried this: Code:
Response.Cookies("attyname")=attyname
and it will not get inserted into the cookie. how do i get the quotes around it like my example?
I know this is Visual basic code, but the response should be global. I one line of code that stretches from here to Mars. Infact, it was used to guide the last probe there. How do I make it go over seperate lines? Code:
View Replies View Relatedi need to put a date of the following format: 14 June 2003 into a text box. i have seen some samples but i can't get what i want. i tried the following: <%=FormatDateTime(todaysDate,0) %> and it only rendered 00:00:00 .
View Replies View RelatedI'm trying to create a VBScript using ASP. However I'm having
problems getting data from session variables into the right places.
The example I have copied below works, however I need to replace
"data1" and "data2" with real data from a session variable. Code:
Is there any way of setting the URL of the current page in a session
variable?
I want to do this so I can create links and redirects back to the page on
which the user invokes a particular procedure.