I have this page/form in asp that connects to my ms access database that I would like to have it either a) upload a picture or b) display the picture if one's already uploaded. I'm looking for direction on this and have no idea where to begin or even what's what. Can I upload a picture into the database?
View RepliesAnybody want to make this easy for me and show me how to upload pictures using ASP?
Users enter information through a form and it will be sent to a database (including the image name), but I need to upload the image as well.
I have an upload facility which is working fine. uploads to a folder (photos) through aspsmartupload and database. Ive checked the folder, n database to see if the file is being uploaded and it is.
ITs just not being displayed properly on the site. ALl the pictures come up with a little white box with a red cross in it, in the top left had corner.. so its identidied as an image , but its not showing the actual image. .
Can anyone tell me the simplest easiest way to upload pictures to a directory. It's for a content management page - text boxes for new record information and a file browse form box for the picture
View Replies View RelatedI need some help with aspupload and a database. I have used the same script before and it worked fine, but now it wont upload. Code:
View Replies View Relatednow I want to send a picture in my e-mails that are send using asp code
first I create the mail Object: Set objMail =
Server.CreateObject("CDONTS.NewMail")
After I fill a variable with the html code that will be the mail
txtMailBody = "<html>"
txtMailBody = txtMailBody & "<center>Hi <BR> This is a test"
txtMailBody = txtMailBody & "<center><img src='CommAd.jpg'>"
finally I send the mail using the following code:
objMail.Body = txtMailBody
objMail.Send
Im doing a basic update to a table using asp:Code:
rs.AddNew
rs("qsID") = request.Form("qsID")
rs("qsType") = request.Form("qsType")
rs("qsTitle") = request.Form("qsTitle")
rs("qsRevision") = request.Form("qsRevision")
rs("qsUpdated") = date()
rs("qsFileType") = request.Form("qsFileType")
rs.update
The only difference is this time I am inserting the primary key rather than using an auto number. the following error message appears:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F)
[Microsoft][ODBC Microsoft Access Driver]Error in row
I went onto the microsoft kb and the said that it was something to do with the PK. Has anyone encountered this problem before
I am trying to develop a web site in which the user can add records to the database from an admininstration section of the site. I'm using an access database (there will only be about 60 or so records at any time).
I can create a page that makes the user fill out a form to add a record like the sample below...but I'd also like a place where the user can just upload a CSV file directly into the database. I don't know a lot about ASP, but I'm planning on doing it in DMX.
I have a web page that displays properties for sale. The web page links to a database.
The page shows information in the database and the path to the picture.
The code is:
<p><img border="0" src="file:///D:/HousePics/<%response.write
rsData("id")%>.jpg" width="350" height="262"></p>
the rsData("id")% gives the name of the picture file and appends .jpg to it.
When I browse the page on the local machine the page displays ok and the
graphics show up ok.
When I browse to the page at work the grpahics don't show.
Permissions on the folder 'everyone full control', web sharing is enable
for the site.
This code displays all the pictures in a defined folder as thumbnails. That works fine. But I would like to have it roll over onto a new page after a certain number of thumbs have been displayed and a back forward message. Code:
View Replies View RelatedI'm new to ASP and a few querys
I have created my database in Access with the following fields
StockCode (Text Box, Primary Key)
Item (Memo)
Price (currency)
Picture (memo)
OnOffer (Yes/No)
and I know that access table cannot have a picture in it, only a access
form using OLE, but how do I get my asp page to display a picture for
every record? The picture would be a picture of the product with the
Stockcode as the filename - m001110.jpg?
I have created a rtf document using java which also contains the image.I am including the images in Hexadecimal Form. I am able to view the document with images properly in word 2002. But same document if I open with word 2000, I am not able to view the images.I am including the images using following command
{pictwmetafile8picwNpichN
Hexadecimal data of picture
}
Where N is long integer used to specify height and width of image.Can any body tell me what is problem with this command. I am including JPEG, JPG, BMP,PNG images in hexadecimal.
I am looking for code which can rotate pictures without refreshing the page. I want to read randomly selected 5 images from database and then keep on rotating them every 5 seconds.
View Replies View RelatedI have a site with galleries of pictures and I want to add a logo watermark on them. How can I do it with ASP?
View Replies View RelatedI want 2 upload a image and some text to the sql server database. and in anothere page i will retrieve all the fields . so can anybody help me.i am giving u the html source....
View Replies View RelatedI have this page/form in asp that connects to my ms access database that I would like to have it either a) upload a picture or b) display the picture if one's already uploaded. I'm looking for direction on this and have no idea where to begin or even what's what. Can I upload a picture into the database?
View Replies View RelatedHow can i upload a file from a asp form to a database?
View Replies View RelatedI am developing a forum style website using ASP and I need to have a file attachment function when people post notices. Does anyone know how to do this? So far has only helped with showing me how to upload files to a server but I need to upload them into the access database to retrieve it when needed. Is this possible?
View Replies View Relatedi am working with asp form where the user can upload files to a folder or to the database, uploading files in folder in working, but the database one is not working it give me the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/test/uploadexmple.asp, line 48
and here is my code:
I want to upload either image or word document into either access or SQL server database so far I am doing some small testings and what I can do is upload the file from first page and display at the next page with (both image or word are working fine).
however, I cann't insert them into the database, Plus, what type should I use in access database? Code:
Code:
Dim sConnection
sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=" "; UID="";PASSWORD=""; OPTION=3"
using this code(connection), how can i upload the mySQL Database? you see, i can't install mySQL online..
I have this page where I want to display 3 random pictures in a vertical table. Each picture represents a record in an Access database. The field "picname" holds the name of the picture (e.g. "pic1.jpg", "pic2.jpg", etc). Each record has a unique ID. How do I go about selecting these 3 records? I want the pictures to alternate everytime someone enters the page or refreshes it. I found a couple of javascript options, but they only choose the picture from within a folder, and I need to be able to link the pictures to each record.I don't know if I made myself clear enough.
View Replies View RelatedI'm looking for a script that lets me add certain images from a directory (from like a drop down menu) plus add text (through like a text field) to a html file which would be saved in a directory. So I could then go and open the html file and the new text would be there with the embedded images.
View Replies View RelatedI have uploaded several pictures from my computer to the server. I know the file names and paths, I want to allow users to be able to see these pictures. How can I display them or better have a slide show of my pictures using ASP codes. I know there are many good JavaScript available. Is there a VBScript (ASP code) available for this?
View Replies View RelatedI don't know a thing about asp, but I want people to be able to upload their picture to me.
I've tried various codes but none of them seem to be working. Is there some kind of program I need to get to enable it (if so, a free one?). Also, I want it to fit in with the rest of my form which is built in html as of now, but I'll switch it to asp once I get the code working. Here's the form.
how to insert pictures into Word Documents using
Response.ContentType="application/MSWord" ?
Been trying this for ages, but can't seem to do it.
I am trying to add an option on a form to upload an image to an access database, but I can't seem to get it working. I am able to upload regular text fields to the database with no problem, but got stuck at uploading image.
I don't want to upload the name of image, just the actual jpeg/gif image. I've searched many websites and forums, but codes aren't working. Can someone help me with this? Here are the codes:
i would like to ask isit can upload image into database(ms access 2003) from asp. if can, how the code can be written? then if after upload image into database. how we can retrieve it from database into asp page for viewing?
View Replies View Relatedi 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 RelatedI want to upload a file then add a record in a database using info from the uploaded file. I can't figure this out. If anyone has something working that isn't this please let me know. I would rather have this working as I don't want to recode the whole thing.
First the upload doesn't work. The MBRequest(file1).Save isn't supported in this manner. I know you can use .save to upload a file.
Second You'll see that MBRequest is called to form a filename. The filename is called in another page to form a link to the file......
I have just uploaded the files to a where they will reside and am now getting the following error
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file '
syd9004papc$InetpubwwwrootGMS_Statsgms_st ats.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I have checked IIS on the server where this DB resides and have allowed as much rights as I can ... Has anyone seen this error before? I realise it must have something to do with security but I don't know if it's IIS or DB related?
I'm having this problem with uploading a file and updating the database at the same time the file will get uploaded but nothing will get updated into the database. Can anyone help me out. The third page is where everything is going wrong but i put all my pages in so you can see whats going on.
Here is my first page .....
I have attached the file upoading system in this thread.
It is working fine with MS Access Database but when i change the database to MS Sql Server then its upload not works i think its security problem, or the problem is that when i import the MS Access table into MS SQL server it change the field datatype from oleobject to image.