Skip to main content
Known Participant
February 27, 2007
Question

uploading images

  • February 27, 2007
  • 12 replies
  • 783 views
i have done a tutorial for uploading images the images were going into the folder but when i added the command for uploading the data to the database nbothing is working now just wont display anything
browse file name = Filename
description = Description
form = form1

the name of the desription field is Description
file field = Filename
form = form1

'Add the details of the uploaded file to the database
Dim myFile, myDescription
myFile=Filename
myDescription=Uploader.Form("Description")

set cAddDetail = Server.CreateObject("ADOBE.Command")
cAddDetail.ActiveConnection = MM_robdalt_starsearch_STRING
cAddDetail.CommandText = "INSERT INTO tblUploadedFiles (Filename,
Description ) VALUES ( '" & myFile & "', '" &
myDescription & "' ) "
cAddDetail.CommandType = 1
cAddDetail.CommandTimeout = 0
cAddDetail.Prepared = true
cAddDetail.Execute()

anyone help
This topic has been closed for replies.

12 replies

Known Participant
February 27, 2007
yeah i have a website i use asp and access and work with dreamweavermx i my server supports the upload my images were going into the folder but the command was not working
Deaf_Web_Designer
Inspiring
February 27, 2007
Rob,

First of all, are you new working with data-driven website? I see that you are probably new to work with data-driven website.

The question is obvious and not to overlook. Because it is the core of any database design project. What kind of database server does your web hosting support? For example, PHP, ASP, JSP, so on.

In order to work with data-driven website project, you need to have some things installed on your local machine. Do you have ASP or JSP or PHP installed on your local? How about Apache web server installed?

I realize that you didn't mention what system architecture and what version of Dreamweaver you are working with?

Lastly, and it is important not to overlook this important topic -- security of your local machine and web servers. You need to make sure that your data-driven code is done correctly and need to make sure to prevent some kind of virus, macious, horrible infection of software which can be uploaded to your web server without your knowledge or realization. There are ways to prevent that from happening. That is to say, it is a bit more challenging, and involves a deep understanding on how data-driven websites work, and what is invovled and what not.


quote:

Originally posted by: rob dalton
i have done a tutorial for uploading images the images were going into the folder but when i added the command for uploading the data to the database nbothing is working now just wont display anything
browse file name = Filename
description = Description
form = form1

the name of the desription field is Description
file field = Filename
form = form1

'Add the details of the uploaded file to the database
Dim myFile, myDescription
myFile=Filename
myDescription=Uploader.Form("Description")

set cAddDetail = Server.CreateObject("ADOBE.Command")
cAddDetail.ActiveConnection = MM_robdalt_starsearch_STRING
cAddDetail.CommandText = "INSERT INTO tblUploadedFiles (Filename,
Description ) VALUES ( '" & myFile & "', '" &
myDescription & "' ) "
cAddDetail.CommandType = 1
cAddDetail.CommandTimeout = 0
cAddDetail.Prepared = true
cAddDetail.Execute()

anyone help