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:
I 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
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
I am using ASP with SQL for my database.The problem I have is that even after I have ordered certain items from the shopping cart table on the webpage, I cannot remove them - that is the entire list shows up the next time the table is opened.
is there any way I can delete the items once ordered so as to not let them show in my table?
I am not sure if this is the right place to ask. but... I need to delete records where two fields in the same record are equal. I am not sure how to go about this.will this work?
strQ ="DELETE FROM Request_Notify WHERE Field1 = Field2"
when i click the link, it goes to the correct "case" and will run through my deleteRecord subroutine. I checked it with output at the very beginning and end of the delete routine.
my problem is that nothing happens and i want the record to be deleted.
I may have made a typo somewhere. I am trying to delete collections from RelProdCollection Table that has a certain record with Product ID number of __ and then readd them based on the user's choices on the edit form. Code:
Can I loop through a recordset and with each record, see if the value of a field is higher than 5. If it higher than 5, just delete that record, not the whole record set and continue the loop.
I am accustomed to using a sql statement to selecting an entire recordset based on similar criteria and deleting the whole recordset in one swoop, but not this time. Code:
The column prefix 'username' does not match with a table name or alias name used in the query. I am not sure what this error is. I checked all over the place for the problem.
I got an asp page that supposed to add,delete records from access 2000 mdb file. It loads all the records but when i try to delete or update i get these errrors. Code:
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'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.
using 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'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.
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:
I 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:
This is the SQL statement I am executing to pull the field, which is meant to be the last record inserted into the shopping cart by a particular individual. Code:
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?
I'm trying to break this loop for 4 different contacts to be inserted into the system.
For new inspections I want to be able to search the DB for the Owner, User, Contractor, and Cert_Recipient for new boilers the certificate will be mailed to the contractor which will be the Cert_recipient first.
then for annual inspections I want to be able to search for Owner, user, and Cert_Recipient for annual inspections I will have to search the DB for either the owner or User as the Cert_Recipient
For some apparent reason I can't stop the search, it keeps going thru the loop. I must be missing something. Code:
I am trying to put together a little ASP page that lets you paste a block of HTML in a text area then, at the click of a button, convert it to Javascript document.write statements (including any concatenation, switching of single and double quotes). A really useful tool! Code: