Problems When Adding,deleting,editing Data In The Database
actually, I have a problem while i want to add, delete, or edit a record to a database through a asp page, I can read well but when i want to submit changes using rds object , the data does not change on the source database,
I tried hard to get a solution but i think that the actual problem is only on one figure which is the server value of the data control when i use my own iis server, I do not know this value and microsoft is saying use an empty value but it does not work either.
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
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:
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:
What is the best Method, for deleting or editing existing XML Data? I have a form that submits to XML via ASP using VBScript. I now need to pull data into another ASP page which allows for either Editing or Deleting Individual fields.
I know I can use XSL but is there any better methods as the original form imports data into the Drop Down lists?
I can edit information in tables no problem with insert delete etc etc. My question: is it possible to edit the tables themselves ie make new fields, tables etc! If so can someone provide a simple example or point me to a tutorial im sure I will pick it up pretty quick but I have no idea where to start!
I have a roster of people from a db showing up in a frame containing ans asp page. In order for the client to edit a record on the roster, I have an edit page opening up in a javascript pop-up.
I know how to edit the db but what I don't know is how to 'bind' the text boxes in the pop up to the correct record in the db (based on which record they selected to edit). Here is how it looks:
John Smith 12 123 Main Street Your Town State edit this
the 'edit this' is a link that opens the pop-up. How can I get the correct record to show up in the pop up?
I'm new to programming databases with MS Access. I'd like to know how I get user input for a database, in a form, read from it and do "if" statements. Does anyone know how to do this? I've tried ASP approaches (with the FSO function and .txt files) but none are as effiecient and organized as databases appear to be.
I have two tables: Table-A and Table-B. I extract info into a page from Table-A, Row-1. This displayes nicely into a page. I would then like this info to be inputted into Table-B Row-4 remembering that it came from Row-1.
[so far no problems]
I then want at a later stage, Row-4 to update Table-A, Row-1 with it's contents AND for Table-B, Row-4 to change a value in itself. Hope that makes sense, if so how would I go about it? Otherwise I can really go into detail.
I am having considerable difficulty figuring out how to delete more than one entry in my online database at a time. I thought I had it Sub Delete() SET Conn = SERVER.CREATEOBJECT("ADODB.Connection") Conn.OPEN "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/database.mdb") sqlWhere = "" aSelected = request.form("Select") sqlWhere = "ProspectId IN ('" & aSelected & "')" sql = "Delete * from tblProspect where " & sqlWhere Conn.Execute sql Conn.Close Set Conn = Nothing RESPONSE.REDIRECT("prospects.asp") End Sub
I have an online store with a database (windows 2003 small business server) and i want to delete a product or a dealer from my database via asp with a button or a link. how can i do this?
i have a registration form in my website. the requests are going to the database (windows 2003 small business server). I have an other page who the entries are displayied. how i can delete the each entry separately with a button?
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 have a database that is for E-Cards. I want it to delete all of the entries that are more than a month old. I have the date stored in a field called "dags" (without the quotes). Please help me on this!
******************************************* Also, I would also like to have an option for "Send the E-Card Later" and then have the options possible dates. What script(s) could I use to do the actual sending on a later date? ********************************************
I have discovered that in my website,when a user tries to add data to the Access DB via a form,there is an error if the data contains an apostrophe,For e.g.If the user were to add the user Martin O'Neill to the DB,this would cause an error OR if the user were to add a book called User's Guide,this would also cause an error.
Does anyone know of a generic way to resolve this problem,preferably within the SQL statements which add the data to the DB?
Is it better to use the Recordset methods or make an SQL query string and use conn.Execute() if I want to add to a table? I figure the first might be safer, but it seems weird to someone who learnt on PHP... I'm using SQL Server if that matters.
I have an drop down box.I want a button next to it which says ADD.Once i click that button I get text box where i type my data and after submiting it,it gets added to the drop down box on the page and now i can select that data from the drop down box and proceed ahead with my order.
I am trying to test a form at home which is for registration purposes. I dont have a server connection yet. Im wondering if it is possible to check whether the form is working offline or whether my code just isnt working! ?
I should also say that my html files, asp files and database are in the same folder. Code:
Right now I think I've got the idea on how to work on ASP pages after such a hectic start, then I 've got a small problem . i have contructed my form but i can't seem to add to the dbase, i can fill the info but i see nothing on my dbase.
I have been working on this form for a couple of weeks already but I keep running into errors after errors. Can someone try to test it on their computer and see if it works? My guess is that our server's setting is causing all these problems. All the files are uploaded.
I am trying to run a script that will add users to a database so they can register with the site. ive got it working so that the users are added however i am trying to prevent people from registering the same username or email address and this is not working. the script firstly checks that the user has filled out all the fields in the form from the previous page then the script is supposed to check the database for the username and email then adds the user if it is all ok however if the fields have all been filled out it simply adds the users anyway. here is one of the check scripts i am using VBscript and an access database .....
I am trying to add entries in a database together and place the summed value into a text box. Like a total ordered type function for an ecommerce site. I have a field called ArmChairs in my database and based on how many people buy them, I want to know how many I need to have shipped.
I am really struggling with this last bit and would be really appreciative if someone has some code examples.
i cant add a record to my access database! i think the code is right which i used asp script but then only blank record was added! It added a record but then no data in it! Code:
This code has worked in the past on this same page, and for some reason it doesn't want to calculate the numbers anymore. Anyone see anything that is out of whack?
Basically I am taking the input numbers for each field and adding them up on one column, then taking the totals of all of those columns and adding it up to display as an overall total. Code:
I'm trying to add a record to an access database using asp. I create the database, the input form where i put the information, the asp code where i process the information and last the asp code to view the record added but when i press the submit button it show me a Downloading box for a downloaing process.