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:
I have this list of records (from an Access DB) and would like to use check boxes to delete 1 or many records. I think there is something wrong with the SQL though, cause the records are not deleting when the form is submited. Code:
View Replies View RelatedI am having trouble with the edit, update and deleting of records. I got the codes from a user in a different forum. Now I can't find ant help from that forum. Here is a link to a zip file with the pages and database in it.
bkdphoto.com/problem.zip
Simply open the listings.asp page then click on one of the Edit or Delete labels. I am getting the following message when I do:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/Tests/New Folder2/delete.asp, line 7
I am having trouble with my file uploader. I do not program a lot of .asp and its a bit confusing. As well, I just took over the development on this webpage so the code is not my own.
The file uploader worked before but now that I have the webpage put to a test site it doesn't. Would this be a reason why I cannot upload? i am also having trouble accessing the database, which makes it even harder for me to see whats hapening to the file.
When I upload it says that it uploaded successfully but when I see the webpage the photo isn't there. Would you like to see the code for the uploader?
This ASP (Visual Studio 6) code works on other PCs (The ASP code runs locally on localhost), but it causes IE to hang on a new PC (again, the ASP code runs locally on localhost). I think it may be a permissions issue. Code:
View Replies View RelatedI 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?
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")," ","+")%>
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 RelatedI 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)
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.
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)?
How do I got about deleting a file with the TextStream Object?
View Replies View RelatedI 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?
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?
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.
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:
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 RelatedI 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 RelatedI am trying to connect to mysql db through asp with code that is to upload a file from a computer. I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/uploadexmple.asp, line 47
I am using code that i got from http://www.asp101.com/articles/jacob/scriptupload.asp, a program by jacob gilley to upload files with asp ....
I was wondering If there is any way to grab just the viewable text of a webpage
using xml. Not the html, just what the user can see.
I am having trouble with installing IIS, I tried to do it in my control panel, but it wants the disk, I don't have the disk because my computer came with Windows XP Pro 2002 Service pack 2.
so I went to the microsoft website and downloaded the free download of IIS6. Then when I go to my control panel and Administrative tools it is in there and when I click on it, there is no computer name available.
I have a sign-in box that is an IFrame, with a form target of "_top", and
the current (parent) page URL as a hidden field.
If sign-in in successful, there is a response.redirect to the page URL,
having set the session variable LoggedInOK=true.
However, if the sign in is not OK, I want the IFrame to be the target, (i.e.
_self, not _top) to display the error.
Is there a way for ASP to control whether it redirects to _top or _self, as
setting the form target in the Login page requires "pre-knowledge" of
whether it will be successful.
I am moving a ASP website to a new Window 2003 server with
IIS 6, but an error occur for the metadata declaration in
my global.asa
<!--METADATA TYPE="TypeLib" NAME="Microsoft Scripting
Runtime" UUID="{420B2830-E718-11CF-893D-00A0C9054228}"
VERSION="1.0"-->
the error message is
Active Server Pages error 'ASP 0223'
TypeLib Not Found
/LM/W3SVC/1/Root/myweb/global.asa, line 4
METADATA tag contains a Type Library specification that
does not match any Registry entry.
I'm writing an Online registration system for my friends new business.
I'm trying to incorporate checkboxes so when a person checks on 3 or 4 checkboxes and hits the Submit button I can
pass the information of what they checked_on to a new page.
When I get to the new page I would like to update a database, based on what they checked_on on the previous page.
I'm not sure how to do this.
I'm not sure how to pass the information.
Ive got a script here that searches using info from querystrings. it's just a snippet from the other lot. Code:
View Replies View Relatedusing PWS on test machine (NT4 workstation SP6) and everything was fine but cpshost.dll was used in the website we're maintaining, so I idiotically installed it from a Visual J++ disc. now the website works fine but when i navigate to 127.0.0.1 nothings happens. I've checked directory browsing is enabled but still nothing happens!
I'm aware that cpshost.dll was never meant to be used on NT workstations but as I said before the upload functionality works fine, it just seems to have screwed the directory browsing up - and also the code document.referrer equals nothing.
I am primarily a front-end designer and not familiar with ASP beyond
breaking up pages into include files. Recently, one of my freelance
clients wanted to display an RSS feed from his blog on his site. I did
some research and found the rss2html.asp script. I chose this over a
javascript solution because those scripts apparently don't affect
search engine rankings.
I implemented the script and it was running fine until about a month
ago, when the site and sometimes the server running it started to
crash. The ISP and the blog company the RSS feed originates from blame
the script. Bytescout, who wrote the script, says that it's probably
the feed that's causing the problem. The RDF version of the feed
validates as RSS, but the ATOM one has specs that are too new for the
validator to parse correctly. Code:
I keep having trouble connecting to my database I am running windows xp pro and Access 2000
Error Type:
Provider (0x80004005)
Unspecified error
/test.asp, line 60
It keeps bringing up the above error message sometimes it works fine then other times it dosen't has anyone had any similar problems.
i'm working on access db the problem is when i enter date in d/m/y format it wrote db m/d/y format but this happens only with small numbers i.e if date 04/09/2002 it become 09/04/2002 in db but if it is 24/09/2002 there is no problem.
View Replies View RelatedI've narrowed down my error to one particular function. It looks as if the function may not be receiving the variable that is passed to it.
The error message is:
error '80020009'
results.asp, line 21
Line 21 is: Code:
I'm having some trouble parsing an XML document I'm getting from my company's bank in response to a XML document I'm sending. Both docs are transferring fine, and in fact if the transaction in the document I send is accepted (valid credit card), everything parses perfectly.
The prob is when the transaction is not accepted by the bank server (invalid credit card), and the document that's returned to me has different tags. Code:
I am having trouble with someone else's code that worked when it was used last, but now it's not. I am new to ASP programming so I not too sure what's happening. Code:
View Replies View RelatedI have started session("visitorID") in global.asa in order
to keep track of how many users are on our site at any
given time, trouble is I can't seem to call the session
while on another page.
As I am relatively new to asp I'll post both the setting
of the session and the call to it on the other page below Code: