Deleting Record And Images From File
I have a tbl.pictures on my website, several of the columns have refferal links to images. Having read through another link on this site, apparently it's the best way to do it. (Keeping the images in file rather than on/in the database)
My problem is that when a photographer deletes a photograph from my database the image files remain on my server. For the moment its ok but long term when they delete the record I would also like the images to removed from my server.
Any ideas where I could start to look to do this?
View Replies
ADVERTISEMENT
I'm having trouble creating a one record recordset then deleting it. I've never done this before. The code below returns: "Type mismatch: objRS".
Code:
View Replies
View Related
i have a site that has several joins. I need a function that will go out to see if the master table is using a value from a dependant table before it allows the value in the dependant table to be deleted. nothing more than that.it could be a a simple js function that basically does?
rs = recordset
if count(rs) = 0 then delete field
else
if count(rs) is > 0 then "You can't delete this record"
View Replies
View Related
i have listing.asp to list all the records in both tables .i want to create a hyperlink to to update.asp in which this will update any fields that changed but i was able to update first table but having problem updating the second one. how can i update the second one as well . i have the same problem with delete too.
View Replies
View Related
i have a shopping cart that gets its information from the cookie.
is it possible to add a remove item to my shopping cart so that i can delete a specific item from my cart?
View Replies
View Related
I'm trying to delete some record information but only a set number of fields. when i run the following, it deletes all the record and not the field information in the given records:
set rs = server.CreateObject ("adodb.recordset")
StrSql = "DELETE field4, field5, field6," _
& " field7, field8, field9" _
& " FROM tblStock" _
& " WHERE field1 ='" & Request("loc") & "'" _
& " AND field2 ='" & Request("pdt") & "'" _
& " AND NumberOut =" & Request(" numberout")
'DEBUG ONLY
'Response.Write StrSql & "<br>"
'Response.End
cn.Execute StrSql
View Replies
View Related
In my Access database I have multiple images for some of the records. What is the best way to retrieve and display the multiple images. I am storing the images in a folder and only the path in the DB. Some of them have just 1 image, some 2, some 3 and so on. I have the record ID # and the image name same, for eg. if the record id is R01 then the image name would be R01.jpg if there is only 1 image otherwise R01a.jpg, R01b.jpg, R01c.jpg etc. Is there any way I can open the folder and check for the name and list the image file names as a link to display the images if the ID name and image name matches.
View Replies
View Related
I'm building a simple image gallery. When I upload the photos, they all have the same filename except for an incremental number. For example:
photo_of_event_1.jpg
photo_of_event_2.jpg
photo_of_event_3.jpg
photo_of_event_4.jpg
I have a SQL table where enter in the filename "suffix" ("photo_of_event_") and then I enter a start number (1) and an ending number (4).
So, each gallery only has one record entry.
Now, I need some advise on how to take this record and generate a page that displays all three photos.
Is there a SQL statement that would generate an incrimental list of number (1,2,3,4 in this example?).
View Replies
View Related
I am using the File System Object to create server side cookies and part of
the Function that I am writing deletes a file but I am getting a permissions
denied error on that line of code.
I am using Integrated security only on this site but how do I get the
IUSER_Machinename account to work with Integrated Security?
View Replies
View Related
On my webpage users can upload files and also delete those files. Everything seems to work, but when they upload a file that contains spaces, I am having problems getting the file deleted, for example: "This is my file.txt"
Is there a way I can delete this file. I have tried to take out the spaces, but the file still doesn't delete:
<%=Replace(Request("MyFile")," ","+")%>
View Replies
View Related
I have a little app running in ASP which lists a bunch of files that are in a directory. This is attained using the following code:
View Replies
View Related
I have this script in my global.asa file: Code:
set objFSO=server.createobject("scripting.FileSystemObject")
strPath = "C:SPharm3Verif.asp"
set objFile = objFSO.DeleteFile(strPath,true)
and it returns this error:
Run-Time Error Microsoft VBScript error '800a01a8'
Object required: 'objFSO.DeleteFile(...)'
//global.asa, line 29
line 29 happens to be the objFSO.DeleteFile(strPath,true)
View Replies
View Related
Is it possible to use ASP to delete a file on the web server?
I have a form that allows users to submit files to my site, but I now want
them to be able to delete their files too if possible.
I know the location and filename of the files (this is taken from a
recordset).
I am not 100% adept in ASP (I am using Dreamweaver to make my site) so an
example would be good please.
View Replies
View Related
I have a xml file with this structure: Code:
<online>
<user id="1">Alethesnake</user>
<user id="4">Goofy</user>
<user id="7">Donald duck</user>
</online>
Could you suggest me the best way to delete a node knowing its id (i.e. id=4)?
View Replies
View Related
How do I got about deleting a file with the TextStream Object?
View Replies
View Related
I can easily upload images, add to db etc etc... but is there a way of actually dynamically removing image files from the server? At the moment I have clients uploading banner adverts to the server, but if they decide to delete the image, it removes the record from the database.
I need to go one step further and remove these 'old files' from the server instead of simply taking up space etc. anyone have any great applications or scripts I can use with a delete statement?
View Replies
View Related
It worked fine with access db's but now it's giving me this error...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM releases WHERE title = 'Cabela's Big Game Hunter 2005 Ad
/releaseerase.asp, line 16 Code:
View Replies
View Related
I am trying to write a sub that will delete a spreadsheet file created by the web user. THis is the code I have inserted into the global.asa file, but it is not working.
sub Session_OnEnd
'delete the temporary excel spreadsheet
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
objFSO.DeleteFile(Server.mappath("temp/<%=session.sessionid%>.xls"))
Set objFSO = Nothing
end sub
I have made sure that the temp folder has permissions set for the IUSR_machinename account to be able to delete files. I am running IIS 5 on a windows 2000 server.
View Replies
View Related
I have a text file being create with the FileSystemObject. It's being
built based on results from a SQL query. All this is working fine, but
so that I have a carriage return VBCRLF at the end of each row, I have
an empty row at the end of my text file. How do I delete this last line?
Code:
View Replies
View Related
After looking all over the place and finding codes in vb and in php I even had asked several people on other boards but none of them knew how to do it I say the best way to learn this .asp .aspx junk is to DO IT yourself although Ive scripted in the past with the mIRC client which is why I know programming and html but if anyone is looking for the code this is how its done Code:
View Replies
View Related
I get an error message when deleting an table from a Access database. The code is as follows and the error message is after it. Code:
View Replies
View Related
I would like to know is it poss to show images from the images folder when used within an include file? Folders I have are:
inc
images
The include fie is requested via a Querystring, but images don't show.
I've tried:
../images/img1.jpg
images/img1.jpg
still blank.
View Replies
View Related
Can someone please give me advice or help me ...I don't know why the include file / image doesn’t work. What did I do wrong?
Here is my project:
In the wwwrootmyproject has the includes folder, images folder, and index.asp.
wwwrootmyprojectindex.asp
wwwrootmyprojectimages
wwwrootmyprojectincludesheader.htm
wwwrootmyprojectmathcalculas.asp
I create an header.htm page and save it in the includes folder. Because, I want to use the header.htm page in other places.
The images folder contains all the images in there.
Here is my header.htm page:
<table>
<tr>
<td>
<img src=”images/header.jpg”>
</td>
</tr>
</table>
==
Index.asp page - the include works..the header image shows.
<body>
<!--#Include File="includes/header.htm"-->
</body>
here is a problem, I created a Math folder in the myproject. In the math folder I have a calculas.asp page.
In the calculas.asp, I've included the header.htm page
Here is what I did in the calculas.asp page.....
View Replies
View Related
I am working on a book selling website using ASP with an Access DB.
Basically i would like to have an image of each book in the DB to be displayed upon request in the website. So I guess what i would really like to know is
1. Can i store .jpg or .gif files in an Access DB?
2. Does it make sense to do this?
3. Would it be better to have some kind of pointer in the DB to a place in the file system where the image is stored? .......
View Replies
View Related
I would like to know ho to validate a file name when uploading via asp. I need to upload 2 images and the file names must be the same...
1) browse for 1st image.
2) image path and file name appears in text box i.e. IMAGE1.JPG
3) browse for 2nd image.
4) 2nd image file name MUST match the file name in the text box of 1st image
i.e IMAGE1.JPG.
Hope this is clear... How can this be done.
View Replies
View Related
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?
View Replies
View Related
I want to download record set from my SQL database as csv files but in ZIP file .I can download as a csv file now ..But i can put that in zip file and download.
View Replies
View Related
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
View Replies
View Related
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 Related
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies
View Related
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
View Replies
View Related
This code works fine, it deletes the record that already exist in the database and displays a message to the user the record has being deleted.... but it also it has a problem, if you enter a record to delete from the database and this record does not exist it displays the message that the record has being deleted, while instead it should display an error that this record does not exist in the database.
Code: ...
View Replies
View Related
Ive run into a little trouble. I am sure all of you have used hotmail. Well you know when you select all items to delete, i would like to do something like that, however not delete, but update a field from no to yes.
I would like to add checkboxes to an asp table. So if the user selects say three items they then click on a button, say marked and for each item, it will go to the table and find each record in turn and update the corresponding field from a no to a yes.
Updating is no problem. The problem is, how do i add checkboxes to corresponding asp table. So that particular checkbox corresponds to that particular record. I don't know how to link them together.
Can someone help me out please?
View Replies
View Related